topic Re: month end date extraction in SAS Programming

month end date extraction

anirudhs — Fri, 10 Aug 2018 04:22:58 GMT

Hi ,

I am looking for code to extract only the data with last day of the month.

eg. if a dataset contains incremental data of every day and from that data i need to filter only the data for last day of every month.

linke if my data is having 6 months of data like from Jan to June the i want to have data as per only last day of every month, i.e 31stjan, 28th feb,31march,30april,31may,30june,31july etc.

Re: month end date extraction

shahparth260 — Fri, 10 Aug 2018 04:32:17 GMT

so , I am telling you what my understanding is based on your requirement that you want to have data only for those dates ?

if you can explain by putting example would be more clear.

Thanks

Re: month end date extraction

PGStats — Fri, 10 Aug 2018 04:45:40 GMT

Assuming that your dates are SAS dates, you can select dates that are the last day of the month with the condition

if date = intnx("MONTH", date, 0, "END");