Help using Base SAS procedures

macros with proc sql

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 440
Accepted Solution

macros with proc sql

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 Smiley Happy. I have attached my code here hoping that some of you will help me Smiley Happy

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

Attachment

Accepted Solutions
Solution
‎01-27-2013 09:18 PM
Super User
Super User
Posts: 6,500

Re: macros with proc sql

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 ;

View solution in original post


All Replies
Solution
‎01-27-2013 09:18 PM
Super User
Super User
Posts: 6,500

Re: macros with proc sql

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 ;

Super Contributor
Super Contributor
Posts: 440

Re: macros with proc sql

Thanks so much Tom

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 172 views
  • 2 likes
  • 2 in conversation