Transpose particular columns

shubham_d — Wed, 14 Jun 2023 09:22:57 GMT

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 🙂

Re: Transpose particular columns

Kathryn_SAS — Wed, 14 Jun 2023 15:56:54 GMT

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;

topic Re: Transpose particular columns in SAS Enterprise Guide

Transpose particular columns

Re: Transpose particular columns