DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 55

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

[ Edited ]

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;

 

Trusted Advisor
Posts: 1,554

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

Posted in reply to jayakumarmm

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.

Ask a Question
Discussion stats
  • 1 reply
  • 317 views
  • 0 likes
  • 2 in conversation