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

Reply
Occasional Contributor
Posts: 19

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?

Respected Advisor
Posts: 4,641

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
Occasional Contributor
Posts: 19

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,254

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
  • 1234 views
  • 3 likes
  • 3 in conversation