topic Re: reading only last date of the month from the date variable in SAS Programming

reading only last date of the month from the date variable

sdixit — Thu, 13 Jul 2017 14:30:11 GMT

Hi All,

Could someone assist me how I can read only the last day of the month data from my table .

Example :

I have a sql to pull the data from netezza table to SAS Based on the period dates which has daily data But i need to pull only the data

of last day of each month. How can i accomlipsed that in the sql pass through?

Period date

01jul

02jul

30jul==> need this data

01aug

02aug

03aug

31aug ==> need this data

Thanks

Shuchi

Re: reading only last date of the month from the date variable

RW9 — Thu, 13 Jul 2017 14:49:22 GMT

Well, I don't know that database and its out o scope for this forum. From a SAS standpoint you can filter the recieved data in a datastep after the sql, or you can go and investigate the database's functions and guidance and build a working SQL clause there.

Edit: logically the process is to group the data by month(date) and output when date=max(date) by month. So first step would be to get month, maybe:

https://stackoverflow.com/questions/4500390/netezza-sql-extract-month-issue

Re: reading only last date of the month from the date variable

kiranv_ — Thu, 13 Jul 2017 14:54:19 GMT

there is last_day function in neteezza, which you can derive last day and then in your where clause you can say where last day = your day