hi ,
I have a dataset in format below:
ID Vi PRocedure
1 1 ABC
1 1 DEF
1 1 FCG
1 2 FCG
1 2 KKR
when I transpose this using proc transpose prefix=proc; by id vi;var procedure;run;
I get
ID Vi Proc1 Proc2 Proc3
1 1 ABC DEF FCG
1 2 FCG KKR .
actually what I need is something like this..
ID Vi ABC DEF FCG KKR
1 1 yes yes yes no
1 2 no no yes yes
I'm not sure how to get to here in my final dataset..
Appreciate for you help.
Eddie