Pull date range with datetime20.

[Gil_]

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

[ballardw]

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.

[Kurt_Bremser · Accepted solution]

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.