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
... View more