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. ... View more

I have files on a server in the following naming convention. prefixtest.123.YYYYMM  prefixtest.223.YYYYMM ... There are many files on the server, so I would like to read them in by sample. I am using SAS 9.4. Macro runparallel:  loops through SampleCodeLst and SampleLst to get the number of samples we have. This macro then calls macro load_data. Macro load_data: tries to set data to "&prefixtest.&samplecode.." It uses a semi colon to generalize all the monthly file suffixes. It also specifies the variable via macro variable vlist.      %let iLoc =InputFileLocation; %let oLoc =OutputFileLocation; %let SampleCodeLst = 123 223; %let SampleLst = Sample1 Sample2; %let vLst = AccountIdentifier Period ImportantVar; %let fileprefix = prefixtest; %syslput iLoc=%bquote(&iLoc.); %syslput oLoc=%bquote(&oLoc.); %syslput vLst=%bquote(&vLst.); %syslput fileprefix=%bquote(&fileprefix.); %macro load_data(SampleCode=, Sample=,gsession=); %syslput SampleCode=%bquote(&SampleCode.); %syslput Sample=%bquote(&Sample.); signon &gsession.; %put SESSION &gsession. STARTING; rsubmit gsession connectwait=no connectpersist=no sysrputsync=yes; libname iLoc "&iLoc." access=readonly; run; libname oLoc "&oLoc." compress=binary; run; data oLoc.&Sample.; set &fileprefix.&SampleCode.:(keep= &vLst.) run; endrsubmit; %mend load_data; %macro runparallel; waitfor _all_ %do Loop=1 %to %sysfunc(countw(&SampleLst, ' ')); %Let SampleCode = %sysfunc(scan(&SampleCodeLst,&Loop.,' ')); %Let Sample = %sysfunc(scan(&SampleLst,&Loop.,' ')); %load_data(SampleCode=&SampleCode., Sample=&Sample.,gsession=g1_&Loop.); %end; ; %mend runparallel; %runparallel; Two Issues occurs: 1) Run parallel  macro: Looping may or may not be an issue. I'm not sure why load_data is not called twice in my scenario. It might be the way I am passing macro variables.  2) load data macro: The "set" data line does not appear to be working at all. See below.  NOTE: Line generated by the macro variable "SAMPLECODE". prefixtest_123 ERROR: File prefixtest.DATA does not exist.... ... View more