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
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
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.