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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.