macro date format for automation

chennupriya — Fri, 21 Nov 2014 04:58:42 GMT

automate date in oracle pass through query using intnx instead of hard code

Re: macro date format for automation

AbhiD — Wed, 25 Nov 2015 08:58:41 GMT

Hi,

Please could you elobrate ur issue with an example

Rgds,
Abhi

Re: macro date format for automation

dcruik — Wed, 25 Nov 2015 15:21:05 GMT

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;

topic Re: macro date format for automation in SAS Programming

macro date format for automation

Re: macro date format for automation

Re: macro date format for automation