Thank you for your reply! Noted, but my company is using SAS server 9.2, so EG 7.1 will not support it. Hopefully it will be upgraded soon. Also, can I check whether this is the correct code to export? /* Data to export */
%let lib = work;
%let datafile = data1;
/* Local folder to download to */
%let download_to = C:\folder;
/* detect proper delim for UNIX vs. Windows */
%let delim=%sysfunc(ifc(%eval(&sysscp. = WIN),\,/));
%let download_from =
%sysfunc(getoption(work))&delim.&datafile..xlsx;
filename src "&download_from.";
proc export data=&lib..&datafile.
dbms=Excel replace
file=src
replace;
run;
filename src clear; Then I will use the add-on to export out the files since the data can be a macro. Do let me know if this will work. Thank you!
... View more
