Hi,
I need to transpose the multiple columns. The below table is my source
and i need the data like the below
I'm pretty sure the %TRANSPOSE macro will do this
http://support.sas.com/resources/papers/proceedings13/538-2013.pdf
Hi @anand5466 Welcome to SAS communities. If you could paste your data as plain text rather than pics, that would help copy paste and test.
Btw, The solution is a straight forward array parking i.e N*2.
IMHO, also looks like some kinda report with header Annual. You need to clarify whether you want a dataset or a report?
@anand5466 wrote:
Hi,
I need to transpose the multiple columns. The below table is my source
and i need the data like the below
Do you need data that will be processed by other programs or a report (people read these).
You want does not appear to be a data set but a report and Proc report can get the values pretty close with the Type and Num variables as Across variables with code and name as Group variables.
But without an actual data set I am not going to try to dummy data to match.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: