Transpose particular columns

[shubham_d]

Have - 

id	var1	var2	var3
1	101	102	103

data d1;

input id var1 var2 var3;

datalines;

1 101 102 103

;

run;

Want - 

id	codes
1	101
1	102
1	103

And in case var1,var2,var3 is null, then want dataset should not contain an entry for it. For example - If var3 is null then want dataset - 

id	codes
1	101
1	102

Thanks in advance for any kind of help 🙂

[Kathryn_SAS]

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;