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;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.