Not sure if you need to see all the code but the first big chunk gets a list of all the Excel files in the directory. Then, the import: %macro import_file(path, file_name, dataset_name ); proc import datafile="&path.\&file_name." dbms=xlsx out=&dataset_name; run; %mend; %*Call macro once for each entry in the list table created from the %list_files() macro; data _null_; set list; string = catt('%import_file(', dir, ', ', name,', ', compress(substr(the_name,1,15)), ');'); call execute (string); run; Not sure where to put it in the above. Honestly, it was taking a lot of google code until I got something to work and this is the last piece. I honestly don't need the stop have the file named the same, I just need to fine name in a column. I found some come that named each file Test01, Test02 on import which is ok but it didn't put the file name in the file.
... View more