Transpose multiple variable columns

[anand5466]

Hi,

I need to transpose the multiple columns. The below table is my source

and i need the data like the below

[PaigeMiller]

I'm pretty sure the %TRANSPOSE macro will do this

http://support.sas.com/resources/papers/proceedings13/538-2013.pdf

https://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/Tabachneck-FlipTranspose...

[novinosrin]

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?

[Ksharp]

And MERGE Skill.

http://support.sas.com/resources/papers/proceedings15/2785-2015.pdf

[ballardw]

---

@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.