auto fetching of dates

[anirudhs]

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

[PGStats]

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;

[anirudhs]

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

[PGStats · Accepted solution]

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;

[anirudhs]

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