topic Re: switch rows to column while keeping the values in SAS Programming

switch rows to column while keeping the values

Takdir — Wed, 22 Jan 2025 03:09:02 GMT

HI,

I am a bit stick with transposing data. would really appreciate your help with codes

this is what I have:

TICKER	DATE	PRC
A	2021-05-18	128.75
A	2021-05-19	130.21
A	2021-05-20	132.15
AAPL	2021-05-18	124.85
AAPL	2021-05-19	124.69
AAPL	2021-05-20	127.31

this is what I want:

TICKER	2021-05-18	2021-05-19	2021-05-20
A	128.75	130.21001	132.14999
AAPL	124.85	124.69	127.31

Re: switch rows to column while keeping the values

andreas_lds — Wed, 22 Jan 2025 06:40:15 GMT

Having data in variable names is almost always a bad idea and leads to unnecessary complex code in further steps. "2021-05-18" is not a valid variable name. If you want a report as result using proc report with across-option for date you should get the layout.

Re: switch rows to column while keeping the values

Kurt_Bremser — Wed, 22 Jan 2025 10:07:57 GMT

For reporting purposes, use PROC REPORT:

data have;
input ticker $ date :yymmdd10. prc;
format date yymmdd10.;
datalines;
A 2021-05-18 128.75
A 2021-05-19 130.21
A 2021-05-20 132.15
AAPL 2021-05-18 124.85
AAPL 2021-05-19 124.69
AAPL 2021-05-20 127.31
;

proc report data=have;
column ticker prc,date;
define ticker / group;
define prc / "" analysis;
define date / "" across;
run;