topic Macro Name Resolution - ERROR 180-322 in SAS Programming

topic Macro Name Resolution - ERROR 180-322 in SAS Programming https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21381#M3441 <HTML><HEAD></HEAD><BODY><P>Well, if <STRONG>edateset </STRONG>is a macro variable, do this:</P><P></P><P>%let edateset=18871;<BR />%macro exclude(count);<BR />     %local x;<BR />     %do x=1 %to &count;<BR />        %global e&x.monthago;<BR />        %let e&x.monthago = %sysfunc(intnx(month,&edateset,-&x.));<BR />     %end;<BR />%mend exclude;</P><P></P><P>%exclude(6);</P><P></P><P>%put e1monthago=&e1monthago;<BR />%put e2monthago=&e2monthago;<BR />%put e3monthago=&e3monthago;<BR />%put e4monthago=&e4monthago;<BR />%put e5monthago=&e5monthago;<BR />%put e6monthago=&e6monthago;</P></BODY></HTML> Fri, 30 Sep 2011 20:03:19 GMT BobD 2011-09-30T20:03:19Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21368#M3428 <HTML><HEAD></HEAD><BODY><P>Assuming that the <STRONG>edateset</STRONG> variable is a SAS date (18871), I'm looping through 6 times and my desired result is decrease by one month so:</P><P></P><P>e1monthago should = 18840</P><P>e2monthago should = 18809 </P><P>e3monthago should = 18778 </P><P>etc...</P><P></P><P>Instead, I'm getting e1monthago, e2monthago, e3monthago, etc...</P><P></P><P>How can I resolve e&x.monthago to be a SAS Date instead of "e1monthago"?  </P><P></P><P></P><P><STRONG>%macro exclude(count);</STRONG><BR /><STRONG>     %local x;</STRONG><BR /><STRONG>     %do x=1 %to &count;</STRONG><BR /><STRONG>          e&x.monthago = intnx('month',edateset,-&x.); </STRONG><BR /><STRONG>     %end;</STRONG></P><P><STRONG>%mend exclude;</STRONG></P><P></P><P><STRONG>%exclude(6);</STRONG></P><P></P><P></P><P></P><P>Works but produces we following error and need help resolving it.</P><P></P><P><STRONG>15933      %macro exclude(count);</STRONG><BR /><STRONG>15934         %local x;</STRONG><BR /><STRONG>15935         %do x=1 %to &count;</STRONG><BR /><STRONG>15936            e&x.monthago = intnx('month',edateset,-&x.);</STRONG><BR /><STRONG>15937         %end;</STRONG><BR /><STRONG>15938      %mend exclude;</STRONG><BR /><STRONG>15939</STRONG><BR /><STRONG>15940      %exclude(6);</STRONG><BR /><STRONG>MLOGIC(EXCLUDE):  Beginning execution.</STRONG><BR /><STRONG>MLOGIC(EXCLUDE):  Parameter COUNT has value 6</STRONG><BR /><STRONG>MLOGIC(EXCLUDE):  %LOCAL  X</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable COUNT resolves to 6</STRONG><BR /><STRONG>MLOGIC(EXCLUDE):  %DO loop beginning; index variable X; start value is 1; stop</STRONG><BR /><STRONG>      value is 6; by value is 1.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 1</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1            e1monthago</STRONG><BR /><STRONG>             <SPAN style="color: #993300;">----------</SPAN></STRONG><BR /><SPAN style="color: #993300;"><STRONG>             180</STRONG></SPAN><BR /><SPAN style="color: #993300;"><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></SPAN></P><P><STRONG>SYMBOLGEN:  Macro variable X resolves to 1</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e1monthago = intnx('month',edateset,-1);</STRONG></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 2; loop will iterate again.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 2</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 2</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e2monthago = intnx('month',edateset,-2);</STRONG></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 3; loop will iterate again.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 3</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1                 e2monthago</STRONG><BR /><STRONG>  <SPAN style="color: #993300;">                ----------</SPAN></STRONG><BR /><SPAN style="color: #993300;"><STRONG>                  180</STRONG></SPAN><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 3</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e3monthago = intnx('month',edateset,-3);</STRONG></P><P><SPAN style="color: #993300;"><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></SPAN></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 4; loop will iterate again.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 4</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1                 e3monthago</STRONG><BR /><SPAN style="color: #993300;"><STRONG>                  ----------</STRONG></SPAN><BR /><SPAN style="color: #993300;"><STRONG>                  180</STRONG></SPAN><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 4</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e4monthago = intnx('month',edateset,-4);</STRONG></P><P><SPAN style="color: #993300;"><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></SPAN></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 5; loop will iterate again.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 5</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1                 e4monthago</STRONG><BR /><SPAN style="color: #993300;"><STRONG>                  ----------</STRONG></SPAN><BR /><SPAN style="color: #993300;"><STRONG>                  180</STRONG></SPAN><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 5</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e5monthago = intnx('month',edateset,-5);</STRONG></P><P><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 6; loop will iterate again.</STRONG><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 6</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1                 e5monthago</STRONG><BR /><SPAN style="color: #993300;"><STRONG>                  ----------</STRONG></SPAN><BR /><SPAN style="color: #993300;"><STRONG>                  180</STRONG></SPAN><BR /><STRONG>SYMBOLGEN:  Macro variable X resolves to 6</STRONG><BR /><STRONG>MPRINT(EXCLUDE):   e6monthago = intnx('month',edateset,-6);</STRONG></P><P><SPAN style="color: #993300;"><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></SPAN></P><P><STRONG>MLOGIC(EXCLUDE):  %DO loop index variable X is now 7; loop will not iterate</STRONG><BR /><STRONG>      again.</STRONG><BR /><STRONG>MLOGIC(EXCLUDE):  Ending execution.</STRONG><BR /><STRONG>NOTE: Line generated by the macro variable "X".</STRONG><BR /><STRONG>1                 e6monthago</STRONG><BR /><SPAN style="color: #993300;"><STRONG>                  ----------</STRONG></SPAN><BR /><SPAN style="color: #993300;"><STRONG>                  180</STRONG></SPAN></P><P><SPAN style="color: #993300;"><STRONG>ERROR 180-322: Statement is not valid or it is used out of proper order.</STRONG></SPAN></P><P></P><P></P><P>Thanks,</P><P>Robby</P></BODY></HTML> Fri, 30 Sep 2011 14:40:24 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21368#M3428 robby_beum 2011-09-30T14:40:24Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21369#M3429 <HTML><HEAD></HEAD><BODY><P>You appear to be trying to create a dataset variable, but not within a datastep.  Where do you expect those six variables to reside?</P></BODY></HTML> Fri, 30 Sep 2011 14:46:15 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21369#M3429 art297 2011-09-30T14:46:15Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21370#M3430 <HTML><HEAD></HEAD><BODY><P>Good Morning Art,</P><P>I've cut down the code...the next statement would be something like "call symput('e3monthago',e3monthago);" to make it a macro variable to be called any where in the program.   </P><P></P><P>I think the %let statement takes care of the error  "%let e&x.monthago = intnx('month',edateset,-&x.);"</P><P></P><P>Robby</P><P><SPAN style="font-family: Courier New; font-size: 10pt;">    </SPAN></P></BODY></HTML> Fri, 30 Sep 2011 14:52:52 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21370#M3430 robby_beum 2011-09-30T14:52:52Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21371#M3431 <HTML><HEAD></HEAD><BODY><P>Yes, a %let statement would work.  Call symput would give you an error as, again, it isn't wrapped within a datastep.  You may have to declare the macro variables as global if you need to access them throughout your program.</P></BODY></HTML> Fri, 30 Sep 2011 14:58:12 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21371#M3431 art297 2011-09-30T14:58:12Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21372#M3432 <HTML><HEAD></HEAD><BODY><P>Try </P><P>   %put %exclude(6);</P></BODY></HTML> Fri, 30 Sep 2011 17:24:28 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21372#M3432 Peter_C 2011-09-30T17:24:28Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21373#M3433 <HTML><HEAD></HEAD><BODY><P>I guess I should piont out that my desired needed result is to resolve "e&x.monthago" to have a SAS Date 18840, 18809, 18879, etc... and not e1monthago, e2monthago, e3monthago, etc...if that makes sense.</P><P></P><P>Unfortunately, I've only been able to get the "e1monthago, e2monthago, e3monthago, etc..." and not the "18840, 18809, 18879, etc..."</P><P></P><P>Robby</P></BODY></HTML> Fri, 30 Sep 2011 17:32:06 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21373#M3433 robby_beum 2011-09-30T17:32:06Z Re: Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21374#M3434 <HTML><HEAD></HEAD><BODY><P>I am confused.  Let me try to re-state the task.</P><P>You have a MACRO variable EDATESET that contains a SAS date value.</P><P>You want to generate COUNT new MACRO variables that contain SAS date values for the previous COUNT months.</P><P></P><P>Anyway try:</P><P></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>%macro exclude(count,sdate);</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>%local i var;</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>%do i=1 %to &count ;</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>   %let var=e&i.monthago;</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>   %global &var;</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG>   %let &var=%sysfunc(<STRONG style="font-size: 13px;">intnx(month,&sdate,-&i)) ;</STRONG></STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG style="font-size: 13px;">%end;</STRONG></SPAN></P><P><SPAN style="font-family: 'courier new', courier;"><STRONG style="font-size: 13px;">%mend exclude;</STRONG></SPAN></P><P></P><P>Why would you call such a macro EXCLUDE?</P><P>Perhaps if you explain the larger task there is a much easier way to do what you want?</P><P><STRONG style="font-size: 13px;"><BR /></STRONG></P><P><STRONG style="font-size: 13px;"><BR /></STRONG></P></BODY></HTML> Fri, 30 Sep 2011 17:49:24 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21374#M3434 Tom 2011-09-30T17:49:24Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21375#M3435 <HTML><HEAD></HEAD><BODY><P>%macro exclude(count);</P><P> %local x;</P><P> %do x=1 %to &count;</P><P>  e&x.monthago=intnx('month',edateset,-&x);</P><P> %end;</P><P>%mend;</P><P></P><P></P><P>%macro mexclude(count);</P><P> %local x;</P><P> %do x=1 %to &count;</P><P>  %let e&x.monthago=%sysfunc(intnx(month,"&edateset"d,-&x),date9.);</P><P>  %put &&e&x.monthago;</P><P> %end;</P><P>%mend;</P><P></P><P></P><P>data want;</P><P> input edateset yymmdd8.;</P><P> call symput('edateset',put(edateset,date9.));</P><P> %exclude(6)</P><P> format e: date9.;</P><P> put _all_;</P><P> cards;</P><P>110930</P><P>;</P><P>run;</P><P></P><P></P><P>%mexclude(6)</P></BODY></HTML> Fri, 30 Sep 2011 17:57:56 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21375#M3435 FriedEgg 2011-09-30T17:57:56Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21376#M3436 <HTML><HEAD></HEAD><BODY><P>Is the problem how to resolve a macro variable name when you want to use another macro variable's value as part of the name?</P><P>If so then use extra &'s.</P><P>Try this little bit of code:</P><P></P><P>%let e1monthago='01AUG2011'd;</P><P>%let N=1;</P><P>%put e&n.monthago=&&e&n.monthago;</P></BODY></HTML> Fri, 30 Sep 2011 17:58:44 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21376#M3436 Tom 2011-09-30T17:58:44Z Re: Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21377#M3437 <HTML><HEAD></HEAD><BODY><P>I'm sorry, but are you trying to create six macro variables or six data step variables?  And where does <STRONG>edateset</STRONG> come from?  Is it a variable in some data set?</P><P></P><P>If <STRONG>edateset </STRONG>comes from a SAS data set and you want macro variables, change your macro to use call symput (not %let):</P><P></P><P>%macro Mexclude(count);</P><P>     %local x;</P><P>     %do x=1 %to &count;</P><P>          call symput("e&x.monthago",intnx('month',edateset,-&x.)); </P><P>     %end;</P><P>%mend Mexclude;</P><P></P><P>Note you must run this inside a data step.  Your original macro will create six SAS variables; the "new" macro will create six macro variables.</P><P></P><P>data want;</P><P>   set have;</P><P>   %exclude(6);</P><P>   %Mexclude(6);</P><P>run;</P><P></P><P>Also note that the macros will run for each observation in your data set "have"; new SAS variables will be created for each observation, but only the six macro variables will exist at the end.</P></BODY></HTML> Fri, 30 Sep 2011 18:04:45 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21377#M3437 BobD 2011-09-30T18:04:45Z Re: Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21378#M3438 <HTML><HEAD></HEAD><BODY><P>Robby,</P><P></P><P>Since everyone appears to be equally confused I have to ask: are you ONLY trying to accomplish something like the following?:</P><P></P><P>data have;</P><P>  format edateset date9.;</P><P>  input edateset date9.;</P><P>  cards;</P><P>9JAN2005</P><P>15APR2010</P><P>;</P><P></P><P>data want (drop=i);</P><P>  set have;</P><P>  array monthsago(6);</P><P>  format monthsago: date9.;</P><P>  do i=1 to 6;</P><P>    monthsago(i)=intnx('month',edateset,-i);</P><P>  end;</P><P>run;</P></BODY></HTML> Fri, 30 Sep 2011 18:53:24 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21378#M3438 art297 2011-09-30T18:53:24Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21379#M3439 <HTML><HEAD></HEAD><BODY><P>Art,</P><P>Basically yes - but I need them in local (or global) macro variables (instead of a table) so I can plug them into SQL where statements many places down the line.</P><P></P><P>I was looking for:</P><P>macro variable named &e1monthago that resolves to sas date 18840.</P><P>macro variable named &e2monthago that resolves to sas date 18809.</P><P>macro variable named &e3monthago that resolves to sas date 18778.</P><P></P><P>I can easily make the following but was trying to do in a loop</P><P></P><P>%LET  edateset=18871;</P><P></P><P><SPAN style="font-size: 10pt; font-family: Courier New;"></SPAN></P><P>data _null_;<BR />   e1monthago = intnx('month',edateset,-1); <BR />   call symput('e1monthago',e1monthago);<BR />   e1dateago=put(e1monthago, mmddyy10.);<BR />   call symput('e1dateago',e1dateago);</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>   e2monthago = intnx('month',edateset,-2); <BR />   call symput('e2monthago',e2monthago);<BR />   e2dateago=put(e2monthago, mmddyy10.);<BR />   call symput('e2dateago',e2dateago);</P><P></P><P></P><P></P><P>   ...6 times...</P><P></P><P>run;</P><P><SPAN style="color: #008080; font-size: 10pt; font-family: Courier New;"> </SPAN></P><P><SPAN style="color: #008080; font-size: 10pt; font-family: Courier New;"></SPAN>Thanks four your help - pretty much bagged it since the effort is more time than I can afford.</P><P><SPAN style="font-size: 10pt; font-family: Courier New;"></SPAN></P><P><SPAN style="font-size: 10pt; font-family: Courier New;"></SPAN>Robby</P><P><SPAN style="font-size: 10pt; font-family: Courier New;"></SPAN></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 30 Sep 2011 19:10:04 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21379#M3439 robby_beum 2011-09-30T19:10:04Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21380#M3440 <HTML><HEAD></HEAD><BODY><P>data _null_;</P><P> input edateset yymmdd8.;</P><P> call symput('edateset',put(edateset,date9.));</P><P> do i=1 to 6;</P><P>  call symput('e' || strip(i) || 'monthago',put(intnx('month',edateset,-i),date9.));</P><P> end;</P><P> cards;</P><P>110930</P><P>;</P><P>run;</P><P></P><P></P><P>%put &edateset &e1monthago &e2monthago &e3monthago &e4monthago &e5monthago &e6monthago;</P><P>30SEP2011 01AUG2011 01JUL2011 01JUN2011 01MAY2011 01APR2011 01MAR2011</P></BODY></HTML> Fri, 30 Sep 2011 19:25:36 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21380#M3440 FriedEgg 2011-09-30T19:25:36Z Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21381#M3441 <HTML><HEAD></HEAD><BODY><P>Well, if <STRONG>edateset </STRONG>is a macro variable, do this:</P><P></P><P>%let edateset=18871;<BR />%macro exclude(count);<BR />     %local x;<BR />     %do x=1 %to &count;<BR />        %global e&x.monthago;<BR />        %let e&x.monthago = %sysfunc(intnx(month,&edateset,-&x.));<BR />     %end;<BR />%mend exclude;</P><P></P><P>%exclude(6);</P><P></P><P>%put e1monthago=&e1monthago;<BR />%put e2monthago=&e2monthago;<BR />%put e3monthago=&e3monthago;<BR />%put e4monthago=&e4monthago;<BR />%put e5monthago=&e5monthago;<BR />%put e6monthago=&e6monthago;</P></BODY></HTML> Fri, 30 Sep 2011 20:03:19 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21381#M3441 BobD 2011-09-30T20:03:19Z Re: Macro Name Resolution - ERROR 180-322 https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21382#M3442 <HTML><HEAD></HEAD><BODY><P>Hi Robby,</P><P></P><P>Some usefull answers provided, here is something alse as well:</P><P></P><P>*You could use the actual date;</P><P>%let edateset=%sysfunc(putn("01Sep2011"d, 8.));</P><P>*Or the SAS data you provided;</P><P>%let edateset=18871;</P><P>%macro exclude(count);</P><P>     %local x;</P><P>     %do x=1 %to &count;</P><P>          %let e&x.monthago = %sysfunc(intnx(month,&edateset.,-&x.));</P><P>             *you need to use && to resolve the macro name after the numeric has been resolved.</P><P>             *the macro processor will first resolve all values with a single &, e.g. &x. and double &'s will resove to a single &, </P><P>             *thus the first resolution will give &e1monthago. This is the actual variable name that you are looking for finally; </P><P>             %put &&e&x.monthago;</P><P>     %end;</P><P>%mend exclude;</P><P> %exclude(6);</P><P></P><P></P><P> *COMPLETE SOLUTION;</P><P></P><P> *For the where clause you could use;</P><P>%macro exclude(count);</P><P>     %local x;</P><P>      *this will initialise the vairable and global it, but we want to clear it in case we run it more than once;</P><P>      %global whrein;</P><P>      *clear the variable;</P><P>      %let whrein=;</P><P>     %do x=1 %to &count.;</P><P>          %let e&x.monthago = %sysfunc(intnx(month,&edateset.,-&x.));</P><P>             *add the assigned variable to the string;</P><P>             %let whrein=&whrein &&e&x.monthago;</P><P>             *add a comma for the where clause if it is not the final value;</P><P>             %if %eval(&x. ne &count.) %then %let whrein=&whrein,;</P><P>     %end;</P><P>      *you can also add the baarckets here, or later in the where clause;</P><P>      %let whrein=(&whrein.);</P><P>      %put &whrein.;</P><P>%mend exclude;</P><P> %exclude(6);</P></BODY></HTML> Mon, 15 Jul 2013 06:05:45 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Name-Resolution-ERROR-180-322/m-p/21382#M3442 Koos 2013-07-15T06:05:45Z