topic Re: macro for looping through variables in SAS Programming

macro for looping through variables

magladde — Mon, 24 Aug 2020 17:48:01 GMT

Hello everyone, I would like to write a bit of code to run a simple proc logistic for every binary variable I have in a data set. I have a %let statement where I have named all of my binary variables, but how would I go about looping through each variable and calling proc logistic?

my current code currently runs all binary variables at the same time.

%let binary = var1 var2 var4 var6 var8 var 1;

proc logistic data=work.dataset;
    model outcome = &binary/ clodds=pl clparm=pl;
    title "Model single binary variable against outcome";
run;

Re: macro for looping through variables

Reeza — Mon, 24 Aug 2020 18:03:39 GMT

My recommended option:

https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html

Another option, very similar example except for PROC REG instead.

https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

Skeleton example for you to modify your code:

https://gist.github.com/statgeek/9603186

@magladde wrote:

Hello everyone, I would like to write a bit of code to run a simple proc logistic for every binary variable I have in a data set. I have a %let statement where I have named all of my binary variables, but how would I go about looping through each variable and calling proc logistic?

my current code currently runs all binary variables at the same time.
%let binary = var1 var2 var4 var6 var8 var 1;

proc logistic data=work.dataset;
    model outcome = &binary/ clodds=pl clparm=pl;
    title "Model single binary variable against outcome";
run;

Re: macro for looping through variables

PaigeMiller — Mon, 24 Aug 2020 19:55:41 GMT

A non-macro solution is given here, which probably runs faster than a macro solution

https://blogs.sas.com/content/iml/2017/02/13/run-1000-regressions.html

Re: macro for looping through variables

ghosh — Tue, 25 Aug 2020 03:02:20 GMT

Lots of good suggestions however, if you have along list of variables, they might not fit in a single macro variable. In that case I would suggest put the list in a dataset and use a call Execute construct to loop through the list.

/* Untested code  */
data varlist;
  input binvar $;
cards;
var1
var2
var4
var6
var8
var9
;

data _null_;
  set varlist;
  call symput('binary',trim(binvar));
  call execute('
	  proc logistic data=work.dataset;
	    model outcome = &binary/ clodds=pl clparm=pl;
	    title "Model single binary variable against outcome";
		run;
  ');
run;