automatically name transposed columns

ilikesas — Mon, 07 Nov 2016 03:30:25 GMT

Hi,

suppose that I have the following table:

when I do the following code:

proc sort data=have;
by date;
run;
proc transpose data=have out=want ;
by date;
run;

I ge the result:

But the names of the stocks (A and B) appear as COL1 and COL2 - is it possible to have the real names of the stocks?

Thank you!

Re: automatically name transposed columns

Astounding — Mon, 07 Nov 2016 03:33:56 GMT

Try adding to your current PROC TRANSPOSE:

id stock;

That's probably exactly what you are asking for.