automate date in oracle pass through query using intnx instead of hard code
Hi,
Please could you elobrate ur issue with an example
Rgds,
Abhi
You may want to be more specific as far as what you want the macro variable to do or be equal to, but here's a brief example using 10 days ago from the current date (this is assuming your Date Variable in the Oracle Table is Date and not DateTime):
%let today=%sysfunc(today(),date9.);
%let date=%sysfunc(intnx(DAY,"&today"d,-10),date9.);
%put *** Today Macro = &today AND Date Macro = &date ***;
proc sql;
connect to oracle (/*database options*/);
create table want as select * from connection to oracle
(select *
from /*name of table*/
where /*name of date variable*/>="&date"d);
quit;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.