topic Re: creating dummy variables using Proc Glmmod and macro variables as input in SAS Programming

creating dummy variables using Proc Glmmod and macro variables as input

d0021 — Tue, 11 Jun 2019 21:18:24 GMT

I'm trying to create dummy variables using proc glmmod. My inputs are two macro variables. Catvarlist has all the categorical variables. Varlist has all the variables.

proc glmmod data=test outdesign=want outparm=p noprint;
class &catvarlist;
model Predicted = &varlist;
run;



/*Create rename statement automatically
THIS WILL NOT WORK IF YOUR VARIABLE NAMES WILL END UP OVER 32 CHARS*/
data p;
set p;
if _n_=1 and effname='Intercept' then var='Col1=Intercept';
else var= catt("Col", _colnum_, "=", catx("_", effname, vvaluex(effname)));
run;

proc sql;
select var into :rename_list separated by " "
from p;
quit;


/*Rename variables*/
proc datasets library=work nodetails nolist;
modify want;
rename &rename_list;
run;quit;


proc print data=want;
run;

I am getting the following error with Proc GLMMOD.

ERROR: Variable name should be either numeric or specified in the CLASS statement.
ERROR: No MODEL statement.

Please advise.

Re: creating dummy variables using Proc Glmmod and macro variables as input

Reeza — Tue, 11 Jun 2019 21:27:31 GMT

Show your macro variable and the log as well, with the MPRINT and SYMBOLGEN code.

Re: creating dummy variables using Proc Glmmod and macro variables as input

ballardw — Tue, 11 Jun 2019 22:30:16 GMT

@d0021 wrote:

I'm trying to create dummy variables using proc glmmod. My inputs are two macro variables. Catvarlist has all the categorical variables. Varlist has all the variables.
proc glmmod data=test outdesign=want outparm=p noprint;
class &catvarlist;
model Predicted = &varlist;
run;



/*Create rename statement automatically
THIS WILL NOT WORK IF YOUR VARIABLE NAMES WILL END UP OVER 32 CHARS*/
data p;
set p;
if _n_=1 and effname='Intercept' then var='Col1=Intercept';
else var= catt("Col", _colnum_, "=", catx("_", effname, vvaluex(effname)));
run;

proc sql;
select var into :rename_list separated by " "
from p;
quit;


/*Rename variables*/
proc datasets library=work nodetails nolist;
modify want;
rename &rename_list;
run;quit;


proc print data=want;
run;
I am getting the following error with Proc GLMMOD.

ERROR: Variable name should be either numeric or specified in the CLASS statement.
ERROR: No MODEL statement.

Please advise.

Sounds like you have a Character variable in &varlist that is not in &catvarlist

Examine your variable characteristics.

Re: creating dummy variables using Proc Glmmod and macro variables as input

PaigeMiller — Wed, 12 Jun 2019 11:39:46 GMT

@d0021 wrote:

I'm trying to create dummy variables using proc glmmod. My inputs are two macro variables. Catvarlist has all the categorical variables. Varlist has all the variables.

I am getting the following error with Proc GLMMOD.

ERROR: Variable name should be either numeric or specified in the CLASS statement.
ERROR: No MODEL statement.

One (or more) of the variables in &VARLIST are character variables and so this one (or more) variable need to be also in &CATVARLIST.