last_day (ADD_MONTHS(sysdate, -1)) in proc sql?

Reply
Contributor
Posts: 22

last_day (ADD_MONTHS(sysdate, -1)) in proc sql?

used "last_day (ADD_MONTHS(sysdate, -1))" in sql developer and it worked.

What do i use in SAS for the same?

Esteemed Advisor
Posts: 5,523

Re: last_day (ADD_MONTHS(sysdate, -1)) in proc sql?

A description of what ADD-MONTHS() does in whatever environment your code comes from would be useful.

 

If you want to get the last day of last month, use

 

INTNX("MONTH", today(), -1, "END")

PG
Contributor
Posts: 22

Re: last_day (ADD_MONTHS(sysdate, -1)) in proc sql?

I am trying to filter data between a static date (may be 01/012014) and previous month of when we are running the report (if i am running the report today, i want it to be last day of last month ).  The code ran in oracle. I was trying to see if i can just use a pass through query and import to sas

 

 

Super User
Posts: 5,876

Re: last_day (ADD_MONTHS(sysdate, -1)) in proc sql?

Try the code @PGStats provided but first with an implicit pass thru (libname access).
Options sastrace =',,,d' SASTRACELOC =saslog nostsuffix msglevel =i;
will let you whether the functions are passed to Oracle or not.
Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 2751 views
  • 3 likes
  • 3 in conversation