06-03-2015 12:58 PM
I am trying to transpose the questions/answers for each ID.
But some how the values of ID Variable question gets truncated. How it can be fixed?
Any help will be highly appreciated.
Below is my sas code:
infile datalines missover;
input id $2. quest $43. ans $20.;
12 HAVE YOU TAKEN THE DOSE IN LAST 2 MONTHS? NO
12 WHICH MEDICATION YOU ARE ON? XYZ
proc sort data=have;
by id ;
proc transpose data=have out=want (drop=_name_ );
Above Transpose procedure truncates values of quest variable.
Need further help from the community? Please ask a new question.