DATA Step, Macro, Functions and more

reading only last date of the month from the date variable

Reply
Contributor
Posts: 26

reading only last date of the month from the date variable

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

 

Super User
Super User
Posts: 7,401

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

[ Edited ]

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

PROC Star
Posts: 252

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

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

Ask a Question
Discussion stats
  • 2 replies
  • 71 views
  • 0 likes
  • 3 in conversation