06-18-2012 03:40 AM
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 ?
06-18-2012 12:01 PM
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)) ;
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;
06-18-2012 12:48 PM
Transpose is a good idea. However, if you want a single column of data, you must use a BY statement.
data myView / view=myView;
obs = _n_;
proc transpose data=myView out=want (rename=(col1=value)) ;