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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Register now!
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.