Search code examples
sastransposeproc-sql

Transpose a table with one row and many columns using SAS SQL

My table has only 1 row and many columns. I need to return only 1 column and many rows. It is possible to do a transpose via SAS SQL?

Before:

column1 column2 column3 column4
   1       2       3       4

After:

column
   1
   2
   3
   4
Solution

  • Why not use PROC TRANSPOSE you don't have to know how many columns or even the names PROC TRANSPOSE will transpose all numeric columns by default.

    proc transpose data= out= ;
   run;