topic Re: Converting columns to rows in SAS Programming

Converting columns to rows

Gadde — Thu, 25 Aug 2022 20:48:46 GMT

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!

Re: Converting columns to rows

PaigeMiller — Thu, 25 Aug 2022 20:55:35 GMT

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

Re: Converting columns to rows

Gadde — Thu, 25 Aug 2022 20:56:59 GMT

I wanted to change variables into observations

Re: Converting columns to rows

Reeza — Thu, 25 Aug 2022 21:18:50 GMT

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!

Re: Converting columns to rows

andreas_lds — Fri, 26 Aug 2022 06:51:41 GMT

Example for sashelp.class:

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

Re: Converting columns to rows

FreelanceReinh — Fri, 26 Aug 2022 07:23:55 GMT

Hello @Gadde,

You can do this with PROC TRANSPOSE:

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