topic Re: Varlist List for Repeating Procedure in SAS Programming

Varlist List for Repeating Procedure

Wed, 09 Nov 2016 21:09:37 GMT

Admittedly, I always forget the answer to this question and have to search through old code.

Question: How do I create a list of variables to run one at a time through a procedure.

I want to run the below piece of code once for each individual variable. So it will run 23 models.

Y= Dependent Variable

X1-X23: Independent Variables

PROC LOGISTIC DATA = Dataset_Name ALPHA=0.002;
	CLASS Y;
	MODEL Y (EVENT="1") = X1 / LACKFIT FIRTH;
RUN;

Re: Varlist List for Repeating Procedure

Shmuel — Wed, 09 Nov 2016 21:39:56 GMT

Do it with a macro:

%macro run_model;

%do i=1 %to 23;

PROC LOGISTIC DATA = Dataset_Name ALPHA=0.002;
	CLASS Y;
	MODEL Y (EVENT="1") = X&i / LACKFIT FIRTH;
RUN;

%end;

%mend run_model;

%run_model;

Re: Varlist List for Repeating Procedure

Reeza — Wed, 09 Nov 2016 21:52:26 GMT

Or transpose data and use a BY statement.

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-run-multiple-regressions/ta-p/223663

https://communities.sas.com/t5/SAS-Procedures/Macro-for-multiple-GARCH-Regressions/m-p/184280

Re: Varlist List for Repeating Procedure

Astounding — Wed, 09 Nov 2016 21:57:06 GMT

This works very well when your variable names are actually X1 - X23. However, you have to code it differently if you have other names and would call a macro using:

%do_them_all (varlist=a long list of many variable names)

Here's a way to approach that problem:

http://blogs.sas.com/content/sastraining/2015/01/30/sas-authors-tip-getting-the-macro-language-to-perform-a-do-loop-over-a-list-of-values/