Hello, I installed a DLL file to facilitate the importing/exporting of any files from SAS EG to my local machine and vice versa. Specifically, I'm trying to export mutliple CSV files from a desginated SAS library to different folders on one of my local drives. I developed a macro that successfully builds each of the CSV files needed for the Export Task (I created my own task template...see attached). However, the problem I am encountering is that when I go to run the Export Task, instead of processing all the files, it processes only the last file built from the macro, thereby rendering the macro useless. Is there a way for me to export all files (in this case 4) from the library using the Export Task in one go? I appreciate any help or insight on this. Below is my macro code and I've attached a screen shot of my custom Task Template. Thank you %macro csv_export (st,aco,datafile); /* Data to export */ %let lib = TEST; proc sql noprint; select memname into : datafile1 - : datafile4 from sashelp.vmember where libname = "TEST"; quit; /* Local folder to download to */ %let download_to = E:\AA_AU_Monthly_Runs\AA_AU 2017\AA_AU_2017_03_Mar\Step_100_Roster_Prep\&st\&aco ; /* detect proper delim for UNIX vs. Windows */ %let delim=%sysfunc(ifc(%eval(&sysscp. = WIN),\,/)); %let download_from = %sysfunc(getoption(work))&delim.&datafile...csv; filename src "&download_from."; proc export data=&lib..&datafile. dbms=csv file=src replace; run; filename src clear; %mend csv_export; %csv_export(TX,ADV,&datafile1); %csv_export(TX,ADV,&datafile2); %csv_export(IL,LURIE,&datafile3); %csv_export(IL,LURIE,&datafile4);
... View more