https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957136#M11372 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/397947">@heatherml20</a>, I noticed that you're missing semicolons after some of your %PUT statements.&nbsp;&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">%put &amp;=First</CODE></PRE> <P>That can cause the errors you're encountering. Try going through your code, add all of the required semicolons to end each statement and rerun.&nbsp;</P> Fri, 24 Jan 2025 15:50:42 GMT antonbcristina 2025-01-24T15:50:42Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957132#M11371 <DIV class="">* Macro Functions: Practice #1 *</DIV><DIV class="">75 *******************************/</DIV><DIV class="">76</DIV><DIV class="">77 %let Fullname=AnTHoNY MilLeR;</DIV><DIV class="">78 %Let First=%scan(&amp;fullname, 1);</DIV><DIV class="">79 %Let Last=%scan(&amp;fullname, 2);</DIV><DIV class="">80</DIV><DIV class="">81 %put &amp;=First</DIV><DIV class="">82</DIV><DIV class="">83 %put %sysfunc(propcase(&amp;First));</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">84</DIV><DIV class="">85 %put &amp;=Last</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">86</DIV><DIV class="">87 %put %sysfunc(propcase(&amp;Last));</DIV><DIV class="">88</DIV><DIV class="">89 %put Fullname=&amp;Fullname First=%sysfunc(propcase(&amp;First)) Last=%sysfunc(propcase(&amp;Last));</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">90</DIV><DIV class="">91 %put &amp;Fullname;</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">92</DIV><DIV class="">93 %put %upcase(&amp;fullname);</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">94</DIV><DIV class="">95 %put The current form of the name is &amp;Fullname and the Propercase is</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">96 %sysfunc(propcase(&amp;Fullname));</DIV><DIV class="">97</DIV><DIV class="">98 %put _user_;</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">99</DIV><DIV class="">100 %symdel Fullname ;</DIV><DIV class="">ERROR: Open code statement recursion detected.</DIV><DIV class="">101</DIV> Fri, 24 Jan 2025 15:40:35 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957132#M11371 heatherml20 2025-01-24T15:40:35Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957136#M11372 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/397947">@heatherml20</a>, I noticed that you're missing semicolons after some of your %PUT statements.&nbsp;&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">%put &amp;=First</CODE></PRE> <P>That can cause the errors you're encountering. Try going through your code, add all of the required semicolons to end each statement and rerun.&nbsp;</P> Fri, 24 Jan 2025 15:50:42 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957136#M11372 antonbcristina 2025-01-24T15:50:42Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957143#M11373 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/84234">@antonbcristina</a>&nbsp;wrote:<BR /> <P>Try going through your code, add all of the required semicolons to end each statement and rerun.&nbsp;</P> <HR /></BLOCKQUOTE> <P>... and before you rerun the statements which failed, <EM>submit the two missing semicolons alone</EM>. This should get the macro processor out of that "statement recursion" mode.</P> <PRE><STRONG><FONT size="4">;;</FONT></STRONG></PRE> Fri, 24 Jan 2025 16:06:15 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957143#M11373 FreelanceReinh 2025-01-24T16:06:15Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957144#M11374 I did that but I also did not use a %mend statement. I think that is the<BR />error.<BR /> Fri, 24 Jan 2025 16:12:21 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957144#M11374 heatherml20 2025-01-24T16:12:21Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957145#M11375 <P>A %MEND statement would end the definition of a <EM>SAS macro</EM> (starting with a %MACRO statement -- which is neither shown in your log, nor required for the %LET, %PUT and %SYMDEL statements to work).</P> Fri, 24 Jan 2025 16:16:32 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957145#M11375 FreelanceReinh 2025-01-24T16:16:32Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957146#M11376 Hi,<BR /><BR />Yes, I found that I missed a couple of semicolons. I appreciate your<BR />help. The main problem is that I did not use a %Mend statement at the end<BR />of the Macro definition.<BR /><BR />How do I use a %symdel statement to delete variables from the global symbol<BR />table? How do I show the variables in the table itself?<BR /> Fri, 24 Jan 2025 16:19:21 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957146#M11376 heatherml20 2025-01-24T16:19:21Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957147#M11377 <P>Usually you don't need to delete macro variables.&nbsp; They will disappear when your current SAS session ends.&nbsp; But to delete macro variable just list its name in the %SYMDEL statement.</P> <PRE><CODE class=" language-sas">%symdel x;</CODE></PRE> <P>To see what is in the GLOBAL symbol table you can use special keyword _GLOBAL_ with the %PUT statement.</P> <PRE><CODE class=" language-sas">%put _global_;</CODE></PRE> <P>Example::</P> <PRE>1 %let x=101; 2 %let y=102; 3 %put _global_; GLOBAL X 101 GLOBAL Y 102 4 %symdel x ; 5 %put _global_; GLOBAL Y 102 </PRE> Fri, 24 Jan 2025 16:27:36 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957147#M11377 Tom 2025-01-24T16:27:36Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957148#M11378 <P>To display in the LOG all macro variables stored, you can use a %PUT statement with the keyword _ALL_ to display all macro variables or _USER_ to display user defined macro variables.&nbsp;</P> <PRE><CODE class=" language-sas">%put _all_;<BR /><BR />%put&nbsp;_user_;</CODE></PRE> <P>&nbsp;</P> <P>To delete macro variables created, you can use the %SYMDEL statement with the name of the macro variable:</P> <PRE><CODE class=" language-sas">%symdel &lt;macro_var_name&gt;; </CODE></PRE> <P>&nbsp;</P> Fri, 24 Jan 2025 16:29:46 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957148#M11378 antonbcristina 2025-01-24T16:29:46Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957151#M11379 <P>This is how your log would have looked like, had you submitted your code as part of a macro definition (using the macro name <FONT face="courier new,courier">test</FONT> for demonstration)<FONT face="arial,helvetica,sans-serif">:</FONT></P> <PRE>76 %macro test; 77 %let Fullname=AnTHoNY MilLeR; 78 %Let First=%scan(&amp;fullname, 1); 79 %Let Last=%scan(&amp;fullname, 2); 80 81 %put &amp;=First 82 83 %put %sysfunc(propcase(&amp;First)); <FONT color="#FF0000">ERROR: Macro keyword PUT appears as text. ERROR: A dummy macro will be compiled.</FONT> 84 85 %put &amp;=Last 86 87 %put %sysfunc(propcase(&amp;Last)); <FONT color="#FF0000">ERROR: Macro keyword PUT appears as text.</FONT> ...</PRE> <P>But you did not show any of the above error messages, which indicates that you did <EM>not</EM> submit a macro definition and hence don't need a %MEND statement.</P> Fri, 24 Jan 2025 16:46:34 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957151#M11379 FreelanceReinh 2025-01-24T16:46:34Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957180#M11380 The mend statement did get rid of the ERROR: Open code state recursion<BR />detected in this case.<BR /> Fri, 24 Jan 2025 20:39:21 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957180#M11380 heatherml20 2025-01-24T20:39:21Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957196#M11381 <P>Oh yes, you're right. The %MEND statement helps at least in this particular example (as does submitting the two forgotten semicolons) -- but not because it was missing in the first place.</P> <P>&nbsp;</P> <P>A %MEND statement is also part of the "magic" string that is recommended as a remedy in situations where the reason of the "open code statement recursion" is less obvious. The usage of this string</P> <PRE><CODE class=" language-sas">*'; *"; *); */; %mend; run;</CODE></PRE> <P>is documented in the section "<A href="https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/n1rvuiao0okk6cn1afs9ckt2unh9.htm#n126moikd9s334n1p4nz2h3e17l9" target="_blank" rel="noopener">Solving Open Code Statement Recursion Problems</A>" of the Macro Language Reference, together with other recommendations.</P> Fri, 24 Jan 2025 22:26:02 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957196#M11381 FreelanceReinh 2025-01-24T22:26:02Z https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957219#M11382 Thank you Jade! I appreciate your help\\\ More to come as I am studying<BR />for the Adv 9.4 programming now.<BR /> Sat, 25 Jan 2025 08:05:21 GMT https://communities.sas.com/t5/SAS-Studio/Practice-Macro-Essentials-What-does-this-mean-ERROR-Open-code/m-p/957219#M11382 heatherml20 2025-01-25T08:05:21Z