I've been struggling with a problem at work and was hoping that one of you might offer some advice. This is the data set I have (variable names in the top line, triple underscores indicate missing observations) : ID_ AGE Ja1 Ja2 Ja3 001 003 207 ___ 506 003 023 445 211 241 021 101 ___ 431 246 145 042 566 343 121 I need to use SAS to change the first data set into a data set that looks like this (ie. all of the observations have been shifted into new set of variables so that all of the missing observations are on the right-hand and all of the values are on the left): ID_ AGE Ja1 Ja2 Ja3 001 003 207 506 ___ 003 023 445 211 241 021 101 431 246 ___ 145 042 566 343 121 (edit: corrected the second data set.) One extra note: - It may not affect the solution, but there are about 200 rows in the original data set and the Ja* variables currently extend from Ja1-Ja7, but are increasing over time. Any thoughts or recommendations?
... View more