BookmarkSubscribeRSS Feed
DB_ECON
Calcite | Level 5
%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
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 965 views
  • 0 likes
  • 2 in conversation