Create a dataset of variables generated sequentially in a %until loop

DB_ECON — Fri, 16 Jul 2010 14:48:26 GMT

%do %until (&Max_V1. le 5);

a few more lines of code goes here........then ......

proc sql;
Select Variable INTO: Drop_Var
from Spdework.varlist where VarianceInflation = (select max(Varia) as MV
from varlist);
quit;
Question
*At each iteration &Drop_Var contains a new variable. How can I create a new Dataset at this stage to hold all variables generated by &Drop_Var as observations.

proc sql;
Select Variable INTO: L_F_Vars SEPARATED by ' '
From Varlist
Where Variable "&Drop_Var.";
quit;

%END;

%mend auto_vif;

Message was edited by: DB_ECON Message was edited by: DB_ECON

Re: Create a dataset of variables generated sequentially in a %until loop

sbb — Fri, 16 Jul 2010 17:10:47 GMT

You will need to generate the SAS code and use CREATE TABLE, or consider a DATA step approach where you can create more than one SAS member/table with a single pass of an input file, again with your SAS macro code needing to generate the DATA statement parameters and associated OUTPUT statements.

Scott Barry
SBBWorks, Inc.

topic Re: Create a dataset of variables generated sequentially in a %until loop in SAS Programming

Create a dataset of variables generated sequentially in a %until loop

Re: Create a dataset of variables generated sequentially in a %until loop