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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.