SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Contributor
Posts: 68

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

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
Contributor
Posts: 68

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

[ Edited ]
Posted in reply to Ritesh_dellvostro
Hello All, In attachment, My query is there, Could you please help me on it.
sas.PNG
Super User
Super User
Posts: 7,942

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

Posted in reply to Ritesh_dellvostro

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.

Contributor
Posts: 68

transpose values many column data in to one vertical column

Posted in reply to Ritesh_dellvostro
Hello All, Could you please help me on it.
sas.PNG
PROC Star
Posts: 736

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

Posted in reply to Ritesh_dellvostro

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

Super User
Posts: 19,780

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

Posted in reply to Ritesh_dellvostro

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. 

Ask a Question
Discussion stats
  • 5 replies
  • 135 views
  • 0 likes
  • 4 in conversation