Import multiple Linux excel workbooks(.xlsx) with same worksheets into a SAS dataset

[jayakumarmm]

Hi,

Can help me to write a code to Import multiple Linux  excel workbooks(.xlsx) with same worksheets into a SAS dataset. I have tried PROC IMPORT but it works only for a workbook.

PROC IMPORT DATAFILE= "/path/*.xlsx" 
OUT= KL_FILES_CONSOLIDATED
DBMS=XLSX
REPLACE;
SHEET="Sheet1"; 
GETNAMES=YES;
DATAROW= 2;
RUN;

[Shmuel]

If you have a satifying code to import one excel file than you can use a macro to read multiple of them.

The structure of the macro depends on the way you prefer define the list of excel files: a whole directory

or specific files from one directory or from different directories, etc.