You can use the following PROC TRANSPOSE to do this:
data have;
input id var1 var2 var3;
cards;
1 101 102 .
;
run;
proc transpose data=have out=want(drop=_name_ where=(col1 ne .));
by id;
var var1 var2 var3;
run;
proc print data=want;
run;
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.