08-29-2016 12:06 PM - edited 08-29-2016 12:06 PM
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;
08-29-2016 03:58 PM
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.