topic Re: Pull date range with datetime20. in ODS and Base Reporting

Pull date range with datetime20.

Gil_ — Tue, 22 Jan 2019 21:58:01 GMT

I have a macro that should filter start and end date ..it suppose to bring yesterday but it brings everything its an oracle platform

Data _null_;
Format c date7. E date7.;
C=datepart (datetime()));
E=c-1;
Call symput ('cdate2', "'"||vvalue(e)||"'d'");
Run;

%put &cdate2.;

Where datepart (created)>&cdate2

Re: Pull date range with datetime20.

ballardw — Tue, 22 Jan 2019 22:14:23 GMT

Are you sure that the Oracle side will understand a SAS MACRO variable of form '21JAN19'd?

I don't use Oracle but have seen a number of questions here about passing macro values to Oracle that make me believe this may not be appropriate.

It would likely help those who know more about Oracle than I do to include your connection info and the code using this macro variable. XXXX out anything like user or password in the connection.

Re: Pull date range with datetime20.

Kurt_Bremser — Wed, 23 Jan 2019 11:44:32 GMT

Oracle (and any other DBMS I know of) does not have the concept of macro variables. If you use explicit pass-through, you have to convert the code to Oracle standards first, and have macro variables resolved to Oracle-compatible formats.