topic Transpose multiple variable columns in SAS Enterprise Guide

Transpose multiple variable columns

anand5466 — Mon, 13 May 2019 11:29:45 GMT

Hi,

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

and i need the data like the below

Re: Transpose multiple variable columns

PaigeMiller — Mon, 13 May 2019 12:27:37 GMT

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

Re: Transpose multiple variable columns

novinosrin — Mon, 13 May 2019 13:02:15 GMT

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?

Re: Transpose multiple variable columns

Ksharp — Mon, 13 May 2019 13:19:09 GMT

And MERGE Skill.

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

Re: Transpose multiple variable columns

ballardw — Mon, 13 May 2019 23:29:27 GMT

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