topic how to transpose selected data lines from row to column in SAS Programming

how to transpose selected data lines from row to column

tparvaiz — Thu, 15 Jun 2017 00:35:27 GMT

Hi,

I want to transpose some of the data lines from row to column... something like this

please advise how to achieve it

Thanks

Jagadishkatam — Thu, 15 Jun 2017 00:41:04 GMT

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;

Reeza — Thu, 15 Jun 2017 02:38:47 GMT

You said 'some' but your example shows all records being transposed.