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

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

jayakumarmm — Mon, 29 Aug 2016 16:06:42 GMT

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;

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

Shmuel — Mon, 29 Aug 2016 19:58:51 GMT

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.