Converting columns to rows

[Gadde]

Hello,

I have a dataset which has 88 columns and 0 rows. I would like to convert all the columns into rows? Would you be so kind as to help with this?

I really appreciate your guidance!

[PaigeMiller]

If you have 0 rows, there is nothing to convert.

[Gadde]

I wanted to change variables into observations

[andreas_lds]

Example for sashelp.class:

proc sql;
  create table want as
    select Name
      from sashelp.vcolumn
      where libname = 'SASHELP' and memname = 'CLASS'
  ;
quit;

[Reeza]

Since you have no observations you just want the column names or list of variables. 

Query that from sashelp.vcolumn instead.

data varList;
set sashelp.vcolumn;
*values must be uppercase;
where libname='WORK' and memname='HAVE';
keep name;
run;

---

@Gadde wrote:

Hello,

I have a dataset which has 88 columns and 0 rows. I would like to convert all the columns into rows? Would you be so kind as to help with this?

I really appreciate your guidance!

---

[FreelanceReinh · Accepted solution]

Hello @Gadde,

You can do this with PROC TRANSPOSE:

proc transpose data=have out=want;
var _all_;
run;