automation - Dynamically register tables in SAS (DI) -
tables transaction data generated daily, date in name e.g. data_01_12_2014
. clear why method undesirable, presumably reason daily tables enormous , space management mechanism. whatever reason, task grab data these tables, transformations, , drop results result table.
my problem want automate process, , not want manually register new daily table each day. there way automate process in sas/sas di?
much gratitude.
what do, create macro variable, , give value "01_12_2014". can register table in di studio physical name name "libref.data_&datevar." logical name can anything. same job work on new names, changing value of "datevar" macrovariable.
in autoexec, program can written sets macrovariable dynamically. example, set value todays date:
data _null_; call symputx("datevar",translate(put(today(),ddmmyyd10.),"_","-")); run; %put &datevar;
hope helps!
Comments
Post a Comment