Add values of t2 questionnaires to excitisting variables

[stracciatella]

Hello.

In a SPSS file, we have the values of a time one (t1) questionnaire and a time two (t2) questionnaire.
We add the t2 values in an ongoing process (more and more t2 questionnaires arrive) by ADD CASES.
Than we have them in one file (as new cases), but still needed them for calcuations in the same row as the t1 values.

Key        t1value1     t1value2      t1value3     t2value1    t2value1     t2value3
XXX             1,2           4,2              3,2
YYY             2,3           3,5              5,6
...
XXX                                                             1,4             4,3            3,3
     

We would likle to find a smarter way instead of adding the values handish to the row above. Do you have an idea?

Thanks in advance.
Mandy

[Bruce Weaver]

Check out the UPDATE command.  

https://www.ibm.com/support/knowledgecenter/en/SSLVMB_23.0.0/spss/base/syn_update_overview.html

stracciatella wrote

Hello.

In a SPSS file, we have the values of a time one (t1) questionnaire and a time two (t2) questionnaire.
We add the t2 values in an ongoing process (more and more t2 questionnaires arrive) by ADD CASES.
Than we have them in one file (as new cases), but still needed them for calcuations in the same row as the t1 values.

Key        t1value1     t1value2      t1value3     t2value1    t2value1     t2value3
XXX             1,2           4,2              3,2
YYY             2,3           3,5              5,6
...
XXX                                                             1,4             4,3            3,3
     

We would likle to find a smarter way instead of adding the values handish to the row above. Do you have an idea?

Thanks in advance.
Mandy

[David Marso]

UPDATE will certainly work for appending new data to existing records in a sorted file with common key.
To consolidate a file where you have distinct rows for T1 and T2 you can achieve joy with the AGGREGATE command.

DATASET DECLARE consolidated.
AGGREGATE OUTFILE=consolidated
 / BREAK=key
 / t1value1 TO t1value3 t2value1 TO t2value3
 =MAX(t1value1 TO t2value3).
DATASET ACTIVATE consolidated.

---

Bruce Weaver wrote

Check out the UPDATE command.  

https://www.ibm.com/support/knowledgecenter/en/SSLVMB_23.0.0/spss/base/syn_update_overview.html

stracciatella wrote

Hello.

In a SPSS file, we have the values of a time one (t1) questionnaire and a time two (t2) questionnaire.
We add the t2 values in an ongoing process (more and more t2 questionnaires arrive) by ADD CASES.
Than we have them in one file (as new cases), but still needed them for calcuations in the same row as the t1 values.

Key        t1value1     t1value2      t1value3     t2value1    t2value1     t2value3
XXX             1,2           4,2              3,2
YYY             2,3           3,5              5,6
...
XXX                                                             1,4             4,3            3,3
     

We would likle to find a smarter way instead of adding the values handish to the row above. Do you have an idea?

Thanks in advance.
Mandy