how do the macro define yesterday

[deleted_user]

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.

[DanielSantos]

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

[deleted_user]

done.
thank you very much.