topic Re: Need Help with Macro Variables Used in File Name in SAS Programming

topic Re: Need Help with Macro Variables Used in File Name in SAS Programming https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163831#M31703 <HTML><HEAD></HEAD><BODY><P>If you have a solution that works for you please mark the question answered.</P></BODY></HTML> Wed, 11 Feb 2015 18:30:38 GMT Reeza 2015-02-11T18:30:38Z Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163823#M31695 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm having trouble getting the following code to work.  The SAS code is numbered, with the SYMBOLGEN and MLOGIC used to show that the macro itself appears to be evaluating properly.  However, there is an error with calling the file using the macro variables created in the code, specifically YY6 and QQ6.  Please note that the same error occurs whether the file name (DAT1.POL&YY6&QQ6) is in double quotes or not.</P><P></P><P><SPAN style="font-family: courier new,courier;">1          OPTIONS SYMBOLGEN MLOGIC;</SPAN></P><P><SPAN style="font-family: courier new,courier;">2          %LET YYC = 14; *CURRENT REPORTING PERIOD YEAR*;</SPAN></P><P><SPAN style="font-family: courier new,courier;">3          %LET QQC = 06; *CURRENT REPORTING PERIOD QUARTER*;</SPAN></P><P><SPAN style="font-family: courier new,courier;">4          %MACRO LIFDATES;</SPAN></P><P><SPAN style="font-family: courier new,courier;">5          %IF &QQC = 06 %THEN <SPAN style="color: #ff0000;">%LET QQ6 = 12;</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">6          %IF &QQC = 12 %THEN <SPAN style="color: #ff0000;">%LET QQ6 = 06;</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">7          %IF &QQC = 06 %THEN <SPAN style="color: #ff0000;">%LET YY6 = %EVAL(&YYC-1);</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">8          %IF &QQC = 12 %THEN <SPAN style="color: #ff0000;">%LET YY6 = %EVAL(&YYC);</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">9          %LET QQP = %EVAL(&QQC);   *PREV QUARTER FOR YEAR-OVER-YEAR COMPS;</SPAN></P><P><SPAN style="font-family: courier new,courier;">10         %LET YYP = %EVAL(&YYC-1); *PREV YEAR FOR YEAR-OVER-YEAR COMPS;</SPAN></P><P><SPAN style="font-family: courier new,courier;">11         %LET QQP6= %EVAL(&QQ6);  *PREV QTR FOR PREV PERIOD (6 MO BEF QQP);</SPAN></P><P><SPAN style="font-family: courier new,courier;">12         %LET YYP6= %EVAL(&YY6-1);*PREV YEAR FOR PREV PERIOD (6 MO BEF QQP);</SPAN></P><P><SPAN style="font-family: courier new,courier;">13         %LET PYE = %EVAL((&YYP*100)+12);</SPAN></P><P><SPAN style="font-family: courier new,courier;">14         %LET PYE12 = %EVAL(((&YYP-1)*100)+12);</SPAN></P><P><SPAN style="font-family: courier new,courier;">15         %MEND LIFDATES;</SPAN></P><P><SPAN style="font-family: courier new,courier;">16         %LIFDATES; </SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  Beginning execution.</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable QQC resolves to 06</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %IF condition &QQC = 06 is TRUE</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is QQ6)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable QQC resolves to 06</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %IF condition &QQC = 12 is FALSE</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable QQC resolves to 06</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %IF condition &QQC = 06 is TRUE</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is YY6)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable YYC resolves to 14</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable QQC resolves to 06</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %IF condition &QQC = 12 is FALSE</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is QQP)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable QQC resolves to 06</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is YYP)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable YYC resolves to 14</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is QQP6)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  <SPAN style="color: #ff0000;">Macro variable QQ6 resolves to 12</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is YYP6)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  <SPAN style="color: #ff0000;">Macro variable YY6 resolves to 13</SPAN></SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is PYE)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable YYP resolves to 13</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  %LET (variable name is PYE12)</SPAN></P><P><SPAN style="font-family: courier new,courier;">SYMBOLGEN:  Macro variable YYP resolves to 13</SPAN></P><P><SPAN style="font-family: courier new,courier;">MLOGIC(LIFDATES):  Ending execution.</SPAN></P><P><SPAN style="font-family: courier new,courier;">17         </SPAN></P><P><SPAN style="font-family: courier new,courier;">18             LIBNAME DAT1 'MRKTCR2.SAS.P4158D1';</SPAN></P><P></P><P><SPAN style="font-family: courier new,courier;">24         DATA POLPC; /*PRIOR SIX MONTHS*/ SET DAT1.POL&YY6&QQ6;</SPAN></P><P><SPAN style="font-family: courier new,courier;">                                                         _   _</SPAN></P><P><SPAN style="font-family: courier new,courier;">                                                         22  22</SPAN></P><P><SPAN style="font-family: courier new,courier;">                                                         200 200</SPAN></P><P><SPAN style="color: #ff0000; font-family: courier new,courier;">WARNING: Apparent symbolic reference YY6 not resolved.</SPAN></P><P><SPAN style="font-family: courier new,courier; color: #ff0000;">WARNING: Apparent symbolic reference QQ6 not resolved.</SPAN></P><P><SPAN style="font-family: courier new,courier;">ERROR: File WORK.YY6.DATA does not exist.</SPAN></P><P><SPAN style="font-family: courier new,courier;">ERROR: File WORK.QQ6.DATA does not exist.</SPAN></P><P><SPAN style="font-family: courier new,courier;">ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.  </SPAN></P><P></P><P><SPAN style="font-family: courier new,courier;">ERROR 200-322: The symbol is not recognized and will be ignored.</SPAN></P></BODY></HTML> Wed, 11 Feb 2015 17:18:00 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163823#M31695 BryanMarks 2015-02-11T17:18:00Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163824#M31696 <HTML><HEAD></HEAD><BODY><P>Macro variable scope, Local vs Global</P><P></P><P>The macro variables exist in the macro but don't exist once the macro has finished executing. </P><P>Add the following line to the top of your code to create Global.<SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P><P></P><P>%global yy6 qq6; </P></BODY></HTML> Wed, 11 Feb 2015 17:26:01 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163824#M31696 Reeza 2015-02-11T17:26:01Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163825#M31697 <HTML><HEAD></HEAD><BODY><P>Hi, Reeza!  Thanks for replying so quickly!  Does the %GLOBAL command need to be inside or outside the %MACRO LIFDATES; code?  I assume also that all of the other created variables in that section (between %MACRO-%MEND) also need to be referenced in the %GLOBAL command, correct?</P></BODY></HTML> Wed, 11 Feb 2015 17:29:43 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163825#M31697 BryanMarks 2015-02-11T17:29:43Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163826#M31698 <HTML><HEAD></HEAD><BODY><P>Since your %LET was inside of macro it probably defined a local macro variable that disappeared once the macro ended.</P><P>So your reference to YY6 in line 24 is not finding any macro variable with that name.</P><P>You could use %GLOBAL to define the macro as global, or just make sure it already exists before calling the macro.  Then the %LET will change the existing macro variable's value instead of making a new local macro variable.</P><P>Why not just add </P><P>%LET YY6=;</P><P>%LET QQ6=;</P><P>in between lines 3 and 4.</P><P></P><P></P><P>What is the purpose of all that macro?  Perhaps you could do it easier using INTNX function calls?</P></BODY></HTML> Wed, 11 Feb 2015 17:29:50 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163826#M31698 Tom 2015-02-11T17:29:50Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163827#M31699 <HTML><HEAD></HEAD><BODY><P>Either location. Any macro variable you want to reference outside of the macro needs to be in the global statement. </P><P></P><P>OR</P><P></P><P>You can use @Tom recommendation and rewrite the code into a data step using the intnx function, combined with call symputx function that has a third argument to set a macro variable to Global/Local</P><P></P><P>I'd go with option 2.</P></BODY></HTML> Wed, 11 Feb 2015 17:33:30 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163827#M31699 Reeza 2015-02-11T17:33:30Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163828#M31700 <HTML><HEAD></HEAD><BODY><P>Hi, Tom & Reeza,</P><P></P><P>I wasn't aware that creating variables within the macro (between %MACRO-%MEND) would limit their existence to only that part of the program.  I'm not familiar with the intnx function at all and have only a small amount of knowledge about the symputx function, so I think I'd better stick to the %GLOBAL code or create the variables outside of the %MACRO-%MEND code. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>All of that other code in the %MACRO LIFDATES will be used to reference files from multiple points in time for comparisons (e.g., year over year, last six months of current year, last six months of previous year).</P><P></P><P>Thanks for all of your help!</P><P><BR />Bryan</P></BODY></HTML> Wed, 11 Feb 2015 17:43:26 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163828#M31700 BryanMarks 2015-02-11T17:43:26Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163829#M31701 <HTML><HEAD></HEAD><BODY><P>No need for a macro or a data step.</P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%let</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> date='01JUN2014'd ;</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%let</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> pre6m = </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%sysfunc</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">(intnx(month,&date,-6),YYMMDD4);</SPAN></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%let</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> preyr = </SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%sysfunc</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;">(intnx(month,&date,-12),YYMMDD4);</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: blue; background: white;">%put</SPAN><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"> &=pre6m &=preyr ;</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New'; color: black; background: white;"><BR /></SPAN></P><P><SPAN style="font-size: 12.0pt; font-family: 'Courier New';">PRE6M=1312 PREYR=1306</SPAN></P></BODY></HTML> Wed, 11 Feb 2015 17:53:23 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163829#M31701 Tom 2015-02-11T17:53:23Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163830#M31702 <HTML><HEAD></HEAD><BODY><P>Hi, Tom!  That suggestion looks promising!  I'll consider rewriting the macro to use it! <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>Bryan</P></BODY></HTML> Wed, 11 Feb 2015 18:01:16 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163830#M31702 BryanMarks 2015-02-11T18:01:16Z Re: Need Help with Macro Variables Used in File Name https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163831#M31703 <HTML><HEAD></HEAD><BODY><P>If you have a solution that works for you please mark the question answered.</P></BODY></HTML> Wed, 11 Feb 2015 18:30:38 GMT https://communities.sas.com/t5/SAS-Programming/Need-Help-with-Macro-Variables-Used-in-File-Name/m-p/163831#M31703 Reeza 2015-02-11T18:30:38Z