01-05-2017 03:02 PM
I have an urgent situation. I am trying to export excel file into current date and current time.
Will be generating two files each day and final output needs to be like below.
File should be named as such [mmddyyyyhhmmss]_ABC
Please help urgently. Thank you.
01-05-2017 03:55 PM
marco variable is created but proc export part is not working
data _null_ ;
format dt mmddyy10. tm time. ;
dt = today() ;
tm = timepart(datetime()) ;
charval = compress(put(dt,mmddyy10.)||put(tm,time.), ":/") ;
call symput("dateval",charval) ;
%put &dateval ;
proc export data= abc
dbms = xlsx replace ; putnames=no;
final output is generated with name as "&dateval.xlsx"
no error in log.
Need further help from the community? Please ask a new question.