Generate month end dates (past/future)

[jbear]

Hi,

I am trying to write SAS code that can generate month end dates backward and forward. The goal is that the user enters a start date in a macro variable and specifies the periods (-1 going back one month and 1 going forward one month).

This is my initial idea... The generated dates would be assigned a variable name and stored so they can be called throughout the code (e.g. date1=7/31/2013 , date2=8/31/2013...daten=m/dd/yy)

%Let StrtDt = 6/30/2013;

%Let ProjLen = 10;

data DateGen (keep=y);

do i=1 to &ProjLen;;

     x=intnx('month',&StrtDt,0,'end');

     y=x;

output;

end;

run;

[Linlin · Accepted solution]

%Let StrtDt=06/30/2013;

%Let ProjLen = 10;

data DateGen (keep=y);
do i=1 to &ProjLen;
     x=intnx('month',input("&StrtDt",mmddyy10.),i,'end');
     y=x;
  format y mmddyy10.;
output;
end;
run;
proc print;run;

[jbear]

It worked! thanks!