data have;
infile cards truncover;
input ID QUESTN_CD QUESTN_TXT & $15. QUESTN_ANSWER_TXT $;
cards;
123 1 Gender M
123 2 Age 36
123 3 Fulltime Y
123 4 Hourly Pay N
;
proc transpose data=have out=want(drop=_:);
by id;
var QUESTN_ANSWER_TXT;
id QUESTN_TXT;
run;
... View more
