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
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 ;
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 ;
Thanks so much Tom
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.