macros with proc sql

[Tal]

hi all

i have imported  a raw file into sas and then ran several queries against the created dataset.Those queries have the current day,that same day from previous week and the week to date.I will be running the same queries every day so i think it is smart to use macro here but dont know how,i am so new to all this . I have attached my code here hoping that some of you will help me

The date will be the only variable changing daily in my queries.So if current date is x then my queries will have x,x-7 and week_to date (x-6 to x)

I would appreciate it if any of you give me some  hint on this

Thanks

[Tom · Accepted solution]

You seem to have attached a dataset instead of code.

You can do what you say using macro variables.  You probably do not need to create a macro.

You can use the TODAY() function to get today's date.

%let today = %sysfunc(today());

Then in your queries you can reference this variable

...

where date between &today-6 and &today

If you want to value of the macro variable to be human readable you can make it a date literal.

%let today="%sysfunc(today(),date9.)"d ;

[Tal]

Thanks so much Tom