topic auto fetching of dates in SAS Programming

auto fetching of dates

anirudhs — Mon, 26 Feb 2018 05:11:13 GMT

Hi ,

I am looking for auto date fetching;

e.g start date='05feb2018'd

i want to fetch auto date for every next month i.e. 5th day of every month should be the start date.

.eg. for next month when the program is auto run it should fetch the start date as 5th day of next month.

Similarly end date should be last day of every current month.

e.g end_date='28thfeb2018'd for feb ...for march it should fetch the last date e.g. end_date='31March2018'.

Also let me know how can we code it in EG using the query builder.

Thanks

Re: auto fetching of dates

PGStats — Mon, 26 Feb 2018 05:57:57 GMT

Use the date interval function intnx:

data want;
format startDate endDate yymmdd10.;
startDate = intnx("day",intnx("month", today(),0),4);
endDate = intnx("month", today(),0,"end");
run;

proc print data=want; run;

Re: auto fetching of dates

anirudhs — Mon, 26 Feb 2018 06:18:02 GMT

Sorry for start date the month should be the next month.i.e. if end date=28feb2018 then start date should be 5march2018

Re: auto fetching of dates

PGStats — Mon, 26 Feb 2018 06:20:50 GMT

intnx gives you all the flexibility. You should really look into it.

data want;
format startDate endDate yymmdd10.;
startDate = intnx("day",intnx("month", today(),1),4);
endDate = intnx("month", today(),0,"end");
run;

proc print data=want; run;

Re: auto fetching of dates

anirudhs — Mon, 26 Feb 2018 06:32:23 GMT

Thanks a lot for the code,
missed the simple understanding in hurry.