topic Re: Procedure to run SAS macro in SAS Programming https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103781#M21661 <HTML><HEAD></HEAD><BODY><P>Your code looks fine other than that the data step is missing a RUN; statement to tell SAS that you are done typing the code.</P><P>Add a run statement after the last of the macro calls.</P></BODY></HTML> Fri, 04 May 2012 13:01:52 GMT Tom 2012-05-04T13:01:52Z Procedure to run SAS macro https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103780#M21660 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I'm new to SAS macro. </P><P></P><P>What is the correct way to run a SAS macro? </P><P></P><P>Do I first of all run the macro definition first?(highlight from %MACRO all the way to %MEND), then I go to the main program to call it?</P><P></P><P>OR</P><P></P><P>just call from the main program?</P><P></P><P>below is the code: (this is after an Excel file importation). Attached file is the Enterprise Guide file.</P><P></P><P><PRE></PRE></P><P></P><P>Thank you</P></BODY></HTML> Fri, 04 May 2012 12:47:22 GMT https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103780#M21660 SeekYourWay 2012-05-04T12:47:22Z Re: Procedure to run SAS macro https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103781#M21661 <HTML><HEAD></HEAD><BODY><P>Your code looks fine other than that the data step is missing a RUN; statement to tell SAS that you are done typing the code.</P><P>Add a run statement after the last of the macro calls.</P></BODY></HTML> Fri, 04 May 2012 13:01:52 GMT https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103781#M21661 Tom 2012-05-04T13:01:52Z Re: Procedure to run SAS macro https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103782#M21662 <HTML><HEAD></HEAD><BODY><P>The macro defnition does need to be "compiled" before use. This is typically done by executing the definition code. However if a macro is not changing and is used frequently you may want to investigate a macro AUTOCALL LIBRARY. This is basically a folder or directory that SAS will look iin if you attempt to execute an unknown macro call to find a macro by that name an then compile as needed.</P></BODY></HTML> Fri, 04 May 2012 14:36:11 GMT https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103782#M21662 ballardw 2012-05-04T14:36:11Z Re: Procedure to run SAS macro https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103783#M21663 <HTML><HEAD></HEAD><BODY><P>thanks. I'm moving on</P></BODY></HTML> Fri, 04 May 2012 14:58:53 GMT https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103783#M21663 SeekYourWay 2012-05-04T14:58:53Z Re: Procedure to run SAS macro https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103784#M21664 <HTML><HEAD></HEAD><BODY><P>thanks. I'm moving on. Will look into the autocall sometimes.</P></BODY></HTML> Fri, 04 May 2012 14:59:10 GMT https://communities.sas.com/t5/SAS-Programming/Procedure-to-run-SAS-macro/m-p/103784#M21664 SeekYourWay 2012-05-04T14:59:10Z