topic Re: How to create a loop to iterate through columns ? in SAS Enterprise Guide

How to create a loop to iterate through columns ?

cody_q — Mon, 18 Jun 2012 07:40:27 GMT

Hi all,

Anyone knows how to write codes for base SAS or SAS EG to do a looping through to iterate all the columns inside the table and then append it into 1 column with many rows ?

Thanks.

Re: How to create a loop to iterate through columns ?

Tom — Mon, 18 Jun 2012 16:01:09 GMT

How about proc transpose?

Suppose you want to shove everything into a variable (column) call MYVAR.

proc transpose data=have out=want (rename=(col1=myvar)) ;

var _all_;

run;

If your variables (columns) are all of the same type then you could use a data step with an array;

data want ;

set have ;

array old _all_;

do over old; myvar=old; output; end;

keep myvar;

run;

Re: How to create a loop to iterate through columns ?

PGStats — Mon, 18 Jun 2012 16:48:46 GMT

Transpose is a good idea. However, if you want a single column of data, you must use a BY statement.

data myView / view=myView;

set have;

obs = _n_;

run;

proc transpose data=myView out=want (rename=(col1=value)) ;

by obs;

var _all_;

run;