topic Generate month end dates (past/future) in SAS Programming

Generate month end dates (past/future)

jbear — Tue, 23 Jul 2013 17:45:57 GMT

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;

Re: Generate month end dates (past/future)

Linlin — Tue, 23 Jul 2013 18:23:46 GMT

%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;

Re: Generate month end dates (past/future)

jbear — Tue, 23 Jul 2013 18:46:29 GMT

It worked! thanks!