topic Re: macros with proc sql in SAS Procedures

macros with proc sql

Tal — Mon, 28 Jan 2013 01:28:34 GMT

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

Re: macros with proc sql

Tom — Mon, 28 Jan 2013 02:18:08 GMT

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 ;

Re: macros with proc sql

Tal — Mon, 28 Jan 2013 04:46:24 GMT

Thanks so much Tom