Try PROC TRANSPOSE for twice. For example: proc transpose data=aa out=bb; by studentid academicyear; var cumgpa edlevel major aidamout; run; proc transpose data=bb out=cc(drop=_name_); by studentid; var col1; id academicyear _name_; run;
... View more