BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jbencina
Calcite | Level 5

I'm new to the SAS world and have been trying to figure this problem out. I have a list of variables in my data tables that could change (# included, or the names). I've been trying to make a dynamic code that runs the following code for any number of Variables (A, B, C, etc.)

 

   proc transreg data=WORK.'MY_DATA'n;
      model boxcox(Var_A Var_B ...) = identity(DEP_VAR);
   run;

 

I've been researching and found something along these lines. But I can't seem to figure out how to take the variable output below and use it in the function above. Any help would be appreciated!

 

PROC CONTENTS DATA = WORK.'MY_DATA'n
OUT=VAR_NAMES(KEEP = NAME) NOPRINT;
RUN; 

DATA PARSE;
SET VAR_NAMES;
WHERE (NAME NOT IN ('DEP_VAR','ID_VAR'));
RUN; 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

You need to create a macro variable and then pass that to the code.

 

http://support.sas.com/documentation/cdl/en/mcrolref/67912/HTML/default/viewer.htm#n1y2jszlvs4hugn14...

 

PROC CONTENTS DATA = WORK.'MY_DATA'n
OUT=VAR_NAMES(KEEP = NAME) NOPRINT;
RUN; 


Proc SQL;
select name into :var_list separated  by " "
from var_names
WHERE (NAME NOT IN ('DEP_VAR','ID_VAR'));
quit;

*Display the variable list in the log for verification;
%put &var_list;

Then apply that to your data:

   proc transreg data=WORK.'MY_DATA'n;
      model boxcox( &var_list. ) = identity(DEP_VAR);
   run;

View solution in original post

1 REPLY 1
Reeza
Super User

You need to create a macro variable and then pass that to the code.

 

http://support.sas.com/documentation/cdl/en/mcrolref/67912/HTML/default/viewer.htm#n1y2jszlvs4hugn14...

 

PROC CONTENTS DATA = WORK.'MY_DATA'n
OUT=VAR_NAMES(KEEP = NAME) NOPRINT;
RUN; 


Proc SQL;
select name into :var_list separated  by " "
from var_names
WHERE (NAME NOT IN ('DEP_VAR','ID_VAR'));
quit;

*Display the variable list in the log for verification;
%put &var_list;

Then apply that to your data:

   proc transreg data=WORK.'MY_DATA'n;
      model boxcox( &var_list. ) = identity(DEP_VAR);
   run;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 2401 views
  • 0 likes
  • 2 in conversation