DATA Step, Macro, Functions and more

how do the macro define yesterday

Reply
N/A
Posts: 0

how do the macro define yesterday

hi,
i am trying to tail timestamp to the datasets' name, but when finishing the macro, i found it was difficult to define yesterday like 20090401.
Thank you in advance for your really appreciated help.
Super Contributor
Posts: 474

Re: how do the macro define yesterday

Not sure about what your trying to do, but I'll try to help...

Yesterday could be defined as TODAY()-1, or any other date value (var) minus 1 (day)

To fix the dataset name, you could do something like that.

* create macro var YESTERDAY with yesterday date yymmddn8. formated */
data _null_;

/* cats functions is just used for text trimming */
call symput('YESTERDAY',cats(put(TODAY()-1,yymmddn8.)));
run;

* print macro var value, just for checking;
%put &YESTERDAY;

Then you will be abble to us &YESTERDAY with your dataset naming, say:

data MYTABLE_&YESTERDAY;
...
run;

Hope it helps.

Greetings from Portugal.

Daniel Santos at www.cgd.pt
N/A
Posts: 0

Re: how do the macro define yesterday

done.
thank you very much.
Ask a Question
Discussion stats
  • 2 replies
  • 152 views
  • 0 likes
  • 2 in conversation