https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647931#M193947 <P>Hello SAS community!</P><P>&nbsp;</P><P>I ran into an error that I cannot solve.&nbsp;</P><P>I am trying to run proc phreg within a macro. The portion of the code is presented below...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="_MooMoo_0-1589492821955.png" style="width: 679px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/39462i662988D2E64B6165/image-dimensions/679x219?v=v2" width="679" height="219" role="button" title="_MooMoo_0-1589492821955.png" alt="_MooMoo_0-1589492821955.png" /></span></P><P>For some reason, I am having a following error message.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="_MooMoo_1-1589493014898.png" style="width: 707px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/39463iA14B2735DAFB5E7C/image-dimensions/707x419?v=v2" width="707" height="419" role="button" title="_MooMoo_1-1589493014898.png" alt="_MooMoo_1-1589493014898.png" /></span></P><P>Any advises are welcome! Thank you.</P> Thu, 14 May 2020 21:51:55 GMT _MooMoo 2020-05-14T21:51:55Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647931#M193947 <P>Hello SAS community!</P><P>&nbsp;</P><P>I ran into an error that I cannot solve.&nbsp;</P><P>I am trying to run proc phreg within a macro. The portion of the code is presented below...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="_MooMoo_0-1589492821955.png" style="width: 679px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/39462i662988D2E64B6165/image-dimensions/679x219?v=v2" width="679" height="219" role="button" title="_MooMoo_0-1589492821955.png" alt="_MooMoo_0-1589492821955.png" /></span></P><P>For some reason, I am having a following error message.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="_MooMoo_1-1589493014898.png" style="width: 707px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/39463iA14B2735DAFB5E7C/image-dimensions/707x419?v=v2" width="707" height="419" role="button" title="_MooMoo_1-1589493014898.png" alt="_MooMoo_1-1589493014898.png" /></span></P><P>Any advises are welcome! Thank you.</P> Thu, 14 May 2020 21:51:55 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647931#M193947 _MooMoo 2020-05-14T21:51:55Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647932#M193948 <P>What is the R1 option supposed to do? I don't find that as an option on the model statement in the documentation.</P> <P>&nbsp;</P> <P>If you borrow options from other procedures they don't always exist in others or may need other steps to accomplish similar tasks.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 14 May 2020 22:41:20 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647932#M193948 ballardw 2020-05-14T22:41:20Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647938#M193953 Test your code outside of a macro first, with hardcoded values. If you get the same error then your issue is with code not your macro logic or variable resolution. Otherwise the issue is your macro logic. Thu, 14 May 2020 23:19:49 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647938#M193953 Reeza 2020-05-14T23:19:49Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647940#M193955 It is RL option used in PROC PHREG. It adds confidence interval to the output. Thu, 14 May 2020 23:28:04 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647940#M193955 _MooMoo 2020-05-14T23:28:04Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647941#M193956 Thanks for your suggestion. I did test outside of a macro and it worked. It is bizarre that it only does not work when it is inside of the macro... Thu, 14 May 2020 23:29:08 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647941#M193956 _MooMoo 2020-05-14T23:29:08Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647976#M193981 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/289227">@_MooMoo</a>,</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="semicolon.png" style="width: 999px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/39465i6D00FD656F755068/image-size/large?v=v2&amp;px=999" role="button" title="semicolon.png" alt="semicolon.png" /></span></P> <P>Correct the definition of macro variable ADJ_STRAT. Apparently, it contains a semicolon, which ends the MODEL statement so that "<FONT face="courier new,courier">/rl ...</FONT>" appears as the beginning of a new, of course invalid statement.</P> Fri, 15 May 2020 08:30:51 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/647976#M193981 FreelanceReinh 2020-05-15T08:30:51Z https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/648057#M194039 <P>Thanks! This was it!</P> Fri, 15 May 2020 14:51:11 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Error-PROC-PHREG-Statement-is-not-valid-or-it-is-used-out/m-p/648057#M194039 _MooMoo 2020-05-15T14:51:11Z