topic Re: Help with PROC Transpose in SAS Procedures

Help with PROC Transpose

pp2014 — Wed, 03 Jun 2015 16:58:22 GMT

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:

data have;

infile datalines missover;

input id $2. quest $43. ans $20.;

datalines;

12 HAVE YOU TAKEN THE DOSE IN LAST 2 MONTHS? NO

12 WHICH MEDICATION YOU ARE ON? XYZ

;

proc sort data=have;

by id ;

run;

proc transpose data=have out=want (drop=_name_ );

id quest;

var ans;

by id;

run;

Above Transpose procedure truncates values of quest variable.

Re: Help with PROC Transpose

Reeza — Wed, 03 Jun 2015 17:24:18 GMT

SAS variables have a limit of 32 characters for the name. I would highly recommend a different name ie quest1, quest2 and use IDLABEL to apply quest as the label.

Re: Help with PROC Transpose

Steelers_In_DC — Wed, 03 Jun 2015 17:26:40 GMT

SAS names can be 32 characters long. That's where this is being truncated.

Re: Help with PROC Transpose

pp2014 — Wed, 03 Jun 2015 18:04:17 GMT

Thanks Reeza. I used IDLABEL. It worked...