I am trying to reshape data in SAS in a very specific way.
The data looks like:
ID Q1 Q2
491 0 0
491 0 1
1040 0 1
1040 1 0
1040 2 1
And, I want to transform the data to the following shape:
ID Q1A Q1B Q2A Q2B
491 0 0 0 1
1040 0 1 1 0
1040 0 2 1 1
1040 1 2 0 1
So, a pair of variables...