Hi All, I have a macro that imports multiple csv files in different SAS data tables. If I wish to have only one large data table instead of different tables, what should I change in my code? I tried a few things but didnt work. Please advise. %let path=D:\My_SAS_Projects; filename folder "&path\Data."; libname c 'C:\Temp'; options validmemname=extend; data FilesInFolder; length Line 8 File $300; List = dopen('folder'); do Line = 1 to dnum(List); File = trim(dread(List,Line)); output; end; drop list line; run; data _NULL_; set FilesInFolder end=final; call symput(cats('File', _N_), trim(File)); call symput(cats('Name', _N_), trim(nliteral(substr(File,1,min(32, length(File)-4))))); if final then call symputx(trim('Total'), _N_); run; %macro Iteration; %do i = 1 %to &Total; proc import datafile="&path\Data\&&File&i" out= c.&&name&i dbms=csv replace; getnames=yes; run; %end; %mend Iteration; %Iteration
... View more