topic Macro to run the same code multiple times in SAS Programming https://communities.sas.com/t5/SAS-Programming/Macro-to-run-the-same-code-multiple-times/m-p/114742#M23622 <HTML><HEAD></HEAD><BODY><P>I'm hoping I can write a macro to run the same piece of code a number of times.</P><P></P><P>I want to run it once per month on the last day of the month beginning June 30, 2012 to June 30<SPAN style="font-size: 10pt; line-height: 1.5em;">, 2013.</SPAN></P><P></P><P>Dates always trip me up when I want to have the date update each time through.</P><P></P><P>I will have a prompt for the user to enter the start date and the end date (in case they want to change the date ranges).</P><P></P><P>Any help structuring the macro so the month end date changes each pass through would be so welcomed!</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 17 Oct 2013 16:14:46 GMT Shara 2013-10-17T16:14:46Z Macro to run the same code multiple times https://communities.sas.com/t5/SAS-Programming/Macro-to-run-the-same-code-multiple-times/m-p/114742#M23622 <HTML><HEAD></HEAD><BODY><P>I'm hoping I can write a macro to run the same piece of code a number of times.</P><P></P><P>I want to run it once per month on the last day of the month beginning June 30, 2012 to June 30<SPAN style="font-size: 10pt; line-height: 1.5em;">, 2013.</SPAN></P><P></P><P>Dates always trip me up when I want to have the date update each time through.</P><P></P><P>I will have a prompt for the user to enter the start date and the end date (in case they want to change the date ranges).</P><P></P><P>Any help structuring the macro so the month end date changes each pass through would be so welcomed!</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 17 Oct 2013 16:14:46 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-run-the-same-code-multiple-times/m-p/114742#M23622 Shara 2013-10-17T16:14:46Z Re: Macro to run the same code multiple times https://communities.sas.com/t5/SAS-Programming/Macro-to-run-the-same-code-multiple-times/m-p/114743#M23623 <HTML><HEAD></HEAD><BODY><P>I think you would want to use the INTNX function, with the alignment parameter set to E.</P><P></P><P>You could also include this calculation in the %SYSFUNC macro function, and put it in a macro loop to increment to the last day of the next month each iteration of the macro.</P></BODY></HTML> Thu, 17 Oct 2013 16:25:18 GMT https://communities.sas.com/t5/SAS-Programming/Macro-to-run-the-same-code-multiple-times/m-p/114743#M23623 PaigeMiller 2013-10-17T16:25:18Z