Hi,
I want to transpose some of the data lines from row to column... something like this
please advise how to achieve it
Thanks
Please use transpose , you may need to sort the dataset before on city_id and city
proc transpose data=have out=want;
by city_id city;
id category;
var count;
run;
Please use transpose , you may need to sort the dataset before on city_id and city
proc transpose data=have out=want;
by city_id city;
id category;
var count;
run;
You said 'some' but your example shows all records being transposed.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.