@gabriellep38 wrote:
How would I transpose to the wide format?
See this, using your example data:
data drugs;
infile datalines dlm="|";
input NPI $ drugtype :$20.;
datalines;
1|Drug 1
1|Drug 2
1|Drug 3
1|Drug 4
1|Drug 5
;
data procedures;
infile datalines dlm="|";
input NPI $ proctype :$20.;
datalines;
1|Procedure 1
1|Procedure 2
1|Procedure 3
1|Procedure 4
1|Procedure 5
1|Procedure 6
1|Procedure 7
1|Procedure 8
1|Procedure 9
1|Procedure 10
;
data all;
set
drugs (rename=(drugtype=value))
procedures (rename=(proctype=value))
;
run;
proc transpose
data=all
out=want (drop=_name_)
;
by npi;
var value;
run;
... View more
