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: 63

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: 63

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

[ Edited ]
Hello All, In attachment, My query is there, Could you please help me on it.
sas.PNG
Super User
Super User
Posts: 7,392

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

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: 63

transpose values many column data in to one vertical column

Hello All, Could you please help me on it.
sas.PNG
PROC Star
Posts: 549

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

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

Super User
Posts: 17,784

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

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
  • 130 views
  • 0 likes
  • 4 in conversation