topic Re: Help with Transpose in SAS Procedures

Help with Transpose

pp2014 — Fri, 20 Nov 2015 16:55:31 GMT

data have;

input start_dt mmddyy10. calls 3.;

datalines;

10/26/2015 10

11/02/2015 12

11/09/2015 10

11/16/2015 8

;

proc sort data=have;

by start_dt;

run;

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

id start_dt;

var Calls;

run;

It gives me output as below:

_10_26_2015 _11_02_2015 _11_09_2015 _11_16_2015

10 12 10 8

But I want the Output as follows:

10/26/2015 11/02/2015 11/09/2015 11/16/2015

10 12 10 8

Re: Help with Transpose

slchen — Fri, 20 Nov 2015 17:06:10 GMT

After transposed, date became variable name, in SAS, variable name is not allowed with digit at the first letter, and '/' is not allowed, but '_ ' is Ok. You could use label in transpose, such as:

proc transpose data =have out=want (drop=_name_);
id start_dt;
var Calls;
label _10_26_2015='10/26/2015';
run;

Re: Help with Transpose

Reeza — Fri, 20 Nov 2015 17:07:02 GMT

Those wouldn't be valid SAS variable names.

You can apply them as labels though by adding the IDLABEL line to your proc transpose code.

idlabel start_dt;

Re: Help with Transpose

ballardw — Fri, 20 Nov 2015 17:25:50 GMT

That approach generates a real ugly dataset for much use. What will you do with the transposed data?

You you are looking for a pretty table appearance then use a report procedure such as Proc Report or tabulate.

Re: Help with Transpose

PGStats — Fri, 20 Nov 2015 18:18:12 GMT

"10/26/2015" is not a valid SAS variable name. Anyway, that's not what you get with the code you posted. You can use IDLABEL=

data have;
input start_dt mmddyy10. calls 3.;
format start_dt mmddyy10.;
datalines;
10/26/2015 10
11/02/2015 12
11/09/2015 10
11/16/2015 8
;
proc sort data=have;
by start_dt;
run;
 
proc transpose data =have out=want (drop=_name_);
id start_dt;
idlabel start_dt;
var Calls;
run;