Dynamic output name

[SASNE]

Hi Gurus,

I would like to ask if anyone know how to dynamically assign the output file name with current system datetime ?

I have attached the sample.

Thank you for your help

[Kurt_Bremser]

You might try to use one of the automatic macro variables that contain time information. Although I'm not sure if it breaks EG's dataset tracking (making creating process flows harder).

[Ksharp]

data x_%sysfunc(translate(%sysfunc(datetime(),datetime20.),_,:));
input col1 $ col2 $ col3 $;
x=catx(',',of col1-col3);
cards;
s y x
;
run;

[SASNE]

Hi KSharp,

Thank you for your help, do you know how to do that in proc sql?

thanks

[Kurt_Bremser]

---

@SASNE wrote:

Hi KSharp,

Thank you for your help, do you know how to do that in proc sql?

thanks

---

proc sql;
create table x_%sysfunc(translate(%sysfunc(datetime(),datetime20.),_,:)) as
select ....
from ....
;
quit;