topic Re: transpose values column data in to one column data using SAS DI in SAS Data Management

transpose values column data in to one column data using SAS DI

Riteshdell — Thu, 27 Apr 2017 10:40:34 GMT

Hello ALL, Can any one help me to solve below query by using SAS DI studio. Col1 to col12 Row1- A 10 20 30 B 20 30 40 C 60 70 80 Output should be like below : Col1 Col2 A 10 A 20 A 30 B 20 B 30 B 40 C 60 C 70 C 80

transpose values column data in to one column data using SAS DI

Riteshdell — Thu, 27 Apr 2017 10:43:31 GMT

Hello All, In attachment, My query is there, Could you please help me on it.

transpose values many column data in to one vertical column

Riteshdell — Thu, 27 Apr 2017 10:44:48 GMT

Hello All, Could you please help me on it.

Re: transpose values many column data in to one vertical column

PeterClemmensen — Thu, 27 Apr 2017 10:46:27 GMT

Please post your data in the form of a datastep, much easier to help that way.

Re: transpose values column data in to one column data using SAS DI

RW9 — Thu, 27 Apr 2017 11:13:44 GMT

Examining the help guidance under the Post on a new post will help you to post a good question, and hence get a good answer. Please post test data - in the form of a datastep in a code block in the post. Then post what the output should look like. And finally clearly explain the steps between the two.

Re: transpose values column data in to one column data using SAS DI

Reeza — Thu, 27 Apr 2017 13:24:11 GMT

Is your input a text file or a SAS dataset?

I suspect this data is being loaded incorrectly to start with and you may be able to fix it before this step.