Generate month end dates (past/future)

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

Generate month end dates (past/future)

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;


Accepted Solutions
Solution
‎07-23-2013 02:23 PM
Super Contributor
Posts: 1,636

Re: Generate month end dates (past/future)

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

View solution in original post


All Replies
Solution
‎07-23-2013 02:23 PM
Super Contributor
Posts: 1,636

Re: Generate month end dates (past/future)

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

Contributor
Posts: 29

Re: Generate month end dates (past/future)

It worked! thanks!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 183 views
  • 0 likes
  • 2 in conversation