How to combine/merge rows in SPSS Modeler?

Question

Please advice how to transform the original dataset to the expected output as shown below on SPSS Modeler?

It is expected to merge the values of all rows shared the same ID No.

score 1 · Accepted Answer · answered Mar 01 '22 at 12:17

1

If SPSS syntax is availabel to you, the following aggregation command should do the trick:

aggregate outfile=* /break=ID /date_1 from_1 to_1 date_2 from_2 to_2=
                           max(date_1 from_1 to_1 date_2 from_2 to_2)

answered Mar 01 '22 at 12:17

eli-k

1

Thanks so much for your help!! I could replicate with equivalent process with the Aggregation Node at SPSS Modeler and got the expected output – StephL Mar 02 '22 at 00:19

1 Answers1