reading only last date of the month from the date variable

[sdixit]

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

[RW9]

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

[kiranv_]

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