Hi there,
I have the following data set (screenshot). What I want to do is to collapse the IDs, Semesters, Adjusted, Raw, and Scores.
Want:
ID Semester Type Score
1 Fall Raw xx
1 Fall Adj xx
1 Spring Raw xx
1 Spring Adj xx
...
I have started something like this...but it doesn't seem to be working out well. And I know the retain has to be there somewhere as well..
data want;
set have;
by id ;
if FIRST.ID THEN DO;
IF FALL_SEMESTER_RAW>0 THEN SEMESTER= 'FALL';
IF SPRING_SEMESTER_RAW>0 THEN SEMESTER= 'SPRING';
ELSE;
*if SPRING_SEMESTER_RAW>0 THEN SEMESTER=SPRING_SEMESTER_ADJ;
END;
RUN;
| FALL_SEMESTER_RAW | FALL_SEMESTER_ADJ | SPRING_SEMESTER_RAW | SPRING_SEMESTER_ADJ |
1 | 89 | 92.2 | 93 | 95.6 |
2 | 83 | 85.6 | 85 | 87.8 |
3 | 96 | 98.9 | 90 | 93.3 |
4 | 93 | 95.6 | 96 | 97.8 |
5 | 66 | 68.9 | 67 | 71.1 |