t**********h
发帖数: 100 | 1 How to create macro variable in xls file? I mean it automatically update xls
file to today’s date or this current such as:
proc export data = files
outfile = "c\filename&week.xls" dbms = xls replace ;
run;
thanks. | c****g
发帖数: 156 | 2 DATA _NULL_;
call symput ('today', compbl(put(today(), date9.)));
run;
proc export data = files
outfile = "c:\filename&today." dbms = xls replace ;
run; | t**********h
发帖数: 100 | | P****D
发帖数: 11146 | 4 proc export data = files
outfile = "c:\filename&sysdate9." dbms = xls replace ;
run;
Don't need any DATA step before it. |
|
