Thanks a lot! I tried your code and the dataset created contains a no. of duplicated values (all values are full filepath&filename) for those files with data. Then I create another dataset with distinct values and then loop through each value to execute proc import. Is there smarter way to do? Sorry I'm new to SAS... And is there any reason why the CheckCSV macro is not working? ... View more

All files have same structures except that they are generated on different days. ... View more

Thanks for checking. I searched that there is a macro which can be used to check whether the file has data or not (https://stackoverflow.com/questions/61742478/importing-empty-csv-file-in-sas) But then I modify it a bit and it returns error. It only works if I change CSVName to full path&filename, i.e. C:\testing\testing.csv.  If this macro works, then I can replace my call execute proc import statement by calling this macro: %macro CheckCSV(CSVName); data _null_; if _N_ > 2 or eof then do; call symputx('Flag', _n_ -1); stop; end; infile "C:\testing\&CSVName" end=eof; input; run; %if &Flag > 1 %then %do; proc import out = Work.Testing Datafile = "C:\testing\&CSVName" dbms = csv replace; run; %end; %mend; %CheckCSV("testing.csv") ... View more

Thanks for your idea! I have now imported the the files into dataset ... View more