topic linear regression macro - proc glm class statement - unused variables in Statistical Procedures

linear regression macro - proc glm class statement - unused variables

pamplemouse22 — Sat, 05 Nov 2016 18:45:50 GMT

Hi,

I have a model I would like to run with with a series of independent and dependent variables. I have written a macro to do this. Some of the independent variables are categorical, thus, I included these variables in the class statement. However, I realized that putting unused variables in class statement limits sample for each analysis because the observations used in the regression are limited to those with values for all class statement variables. How can i fix this? Also, any suggestions to make code more efficient would be helpful. My list after %mend is VERY long. Thanks.

code sample:

%macro model(dep, indep);
proc glm data=data1 ;
class var2 (ref=first) indep1 (ref=first) indep2 (ref=first)indep3 (ref=first) indep4 (ref=first) indep5 (ref=first);

model &dep= &indep var2 var3 var4/solution;
run;

%mend;
%model(dep1, indep1);
%model(dep1, indep2);
%model(dep1, indep3);
%model(dep1, indep4);
%model(dep1, indep5);
%model(dep2, indep1);
%model(dep2, indep2);
.....

Thanks in advance!

Re: linear regression macro - proc glm class statement - unused variables

PGStats — Sat, 05 Nov 2016 20:27:36 GMT

How about :

%macro model(dep, indepc, indep);

proc glm data = data1 ;
class var2 &indepc / ref = first;
model &dep = &indep &indepc var2 var3 var4 / solution;
run;

%mend;

you would specify one of indepc or indep in your macro call, depending if your variable is categorical or not.

%model(dep1, indep4, );

%model(dep2, , indep99);

Re: linear regression macro - proc glm class statement - unused variables

Reeza — Sat, 05 Nov 2016 21:31:46 GMT

The CLASS statement doesn't require a variable, it can be empty.

ie the following won't affect your output, where the macro variable is blank.

%let indepn=;

proc glm data=...;

CLASS &indepn;
...
run;quit;

Re: linear regression macro - proc glm class statement - unused variables

pamplemouse22 — Tue, 08 Nov 2016 00:06:19 GMT

Oh, good idea. This works! Thank you.

Re: linear regression macro - proc glm class statement - unused variables

pamplemouse22 — Tue, 08 Nov 2016 00:07:42 GMT

Oh I see. Didn't think of calling up the macro variable in the Class statement. Will try. Thanks.