merging spss one to many data sets version 25

This would however lead to many records with duplicate entries. If I understand your question correctly, what you're asking is not possible in SAS and by extension, SPSS.īut in Access/SQL, you could create a query with many DLookUp fields. From what I have heard, SPSS is more user-friendly but not as powerful. Hopefully I have expressed the situation clearly. This would give me 240+ fields per record. Further more it does not seem feasable to define a table in the way that the statistician is asking for. This seems like a lot of effort for a very small sample size. I would like to do this in SQL but I don't think it is possible.Ģ) Is this even necessary? It seems to me that SPSS should be able to handle relationships in a database. So there would essentially be 6 columns in the same row for each question.ġ) what is an easy and elegant way to achieve this? It is likely that we will be expanding this process to many different feedback forms that we collect on achievment. TblFeedbackOutput(studentid, evaluator_observation_1, evaluator_observation_2, evaluator_observation_3). He wants the output to look something like: The statistician is working with SPSS and wants all the data on one student to be in one row. Observationid is mid or final observation (1 or 2)Īnd the numbers are the questions on the review form with a possible value of 1-5.

Merging spss one to many data sets version 25