topic Re: Regarding Error in SAS Macros in SAS Data Science

topic Re: Regarding Error in SAS Macros in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185098#M2223 <HTML><HEAD></HEAD><BODY><P>If you're trying to call a macro from within a data step and use values from the data step then you need to use call execute instead of %.</P><P></P><P>See the second example. </P><P></P><P>In general, create a text string that has the %_cuts(...) and then pass that to call execute. </P></BODY></HTML> Fri, 27 Feb 2015 04:33:23 GMT Reeza 2015-02-27T04:33:23Z Regarding Error in SAS Macros https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185097#M2222 <HTML><HEAD></HEAD><BODY><P>Dear All ,</P><P>I'm getting the error in the following macros please can anyone  able to give any solution for this?</P><P></P><P>i attached screen shot also for your reference.</P><P></P><P>Thanks a lot..</P><P></P><P></P><P>Regards,</P><P>ANil</P><P></P><P>data finfage; merge _cinage (in=a) crefage (in=b); by sex _agecat;  if a;</P><P>326      ageint = _agemos2-_agemos1; dage=agemos- _agemos1;</P><P>327</P><P>328  array l0  _llg  _mlg  _slg  _lht  _mht  _sht  _lwt  _mwt  _swt _lhc  _mhc  _shc  _lbmi</P><P>328! _mbmi  _sbmi;</P><P>329  array l1 _llg1 _mlg1 _slg1 _lht1 _mht1 _sht1 _lwt1 _mwt1 _swt1 _lhc1 _mhc1 _shc1 _lbmi1</P><P>329! _mbmi1 _sbmi1;</P><P>330  array l2 _llg2 _mlg2 _slg2 _lht2 _mht2 _sht2 _lwt2 _mwt2 _swt2 _lhc2 _mhc2 _shc2 _lbmi2</P><P>330! _mbmi2 _sbmi2;</P><P>331  do over l0; l0= l1 + (dage * (l2 - l1)) / ageint; end;</P><P>332</P><P>333  if agemos < 24 then _mbmi=.; *theres a valid value for 23.5 months! ;</P><P>334</P><P>335  %_zscore(length, _llg, _mlg, _slg, lgz, lgpct, _Flenz);</P><P>    -</P><P>    180</P><P>WARNING: Apparent invocation of macro _ZSCORE not resolved.</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P></P><P></P><P>336      %_cuts(_flenz, _bivlg, -5, 3);</P><P>337  %_zscore(height, _lht, _mht, _sht, stz, stpct, _Fstatz);</P><P>    -</P><P>    180</P><P>WARNING: Apparent invocation of macro _ZSCORE not resolved.</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P></P><P></P><P>338      %_cuts(_fstatz, _bivst, -5, 3);</P><P>339  %_zscore(weight, _lwt, _mwt, _swt, waz, wapct, _Fwaz);</P><P>    -</P><P>    180</P><P>WARNING: Apparent invocation of macro _ZSCORE not resolved.</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P></P><P></P><P>340      %_cuts(_fwaz, _bivwt, -5, 5);</P><P>341  %_zscore(headcir, _lhc, _mhc, _shc, headcz, headcpct, _Fheadcz);</P><P>    -</P><P>    180</P><P>WARNING: Apparent invocation of macro _ZSCORE not resolved.</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P></P><P></P><P>342      %_cuts(_fheadcz, _bivhc, -5, 5);</P><P>343  %_zscore(bmi, _lbmi, _mbmi, _sbmi, bmiz, bmipct, _Fbmiz);</P><P>    -</P><P>    180</P><P>WARNING: Apparent invocation of macro _ZSCORE not resolved.</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P></BODY></HTML> Fri, 27 Feb 2015 04:06:21 GMT https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185097#M2222 anilgvdbm 2015-02-27T04:06:21Z Re: Regarding Error in SAS Macros https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185098#M2223 <HTML><HEAD></HEAD><BODY><P>If you're trying to call a macro from within a data step and use values from the data step then you need to use call execute instead of %.</P><P></P><P>See the second example. </P><P></P><P>In general, create a text string that has the %_cuts(...) and then pass that to call execute. </P></BODY></HTML> Fri, 27 Feb 2015 04:33:23 GMT https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185098#M2223 Reeza 2015-02-27T04:33:23Z Re: Regarding Error in SAS Macros https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185099#M2224 <HTML><HEAD></HEAD><BODY><P>The error message is saying that the macro that is being called is not defined.</P><P>Is this code you wrote yourself?  Where is the code that defines the macro?</P></BODY></HTML> Fri, 27 Feb 2015 04:40:41 GMT https://communities.sas.com/t5/SAS-Data-Science/Regarding-Error-in-SAS-Macros/m-p/185099#M2224 Tom 2015-02-27T04:40:41Z