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

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

ashwini2 — Tue, 05 Apr 2016 18:28:25 GMT

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

What do i use in SAS for the same?

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

PGStats — Tue, 05 Apr 2016 18:47:42 GMT

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

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

ashwini2 — Tue, 05 Apr 2016 18:55:40 GMT

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

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

LinusH — Wed, 06 Apr 2016 06:19:54 GMT

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.