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

[ashwini2]

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

What do i use in SAS for the same?

[PGStats]

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")

[ashwini2]

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

[LinusH]

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.