Upon further testing, I found that PROC IMPORT with DBMS=XLSX will also work importing from a multi-sheet EXCEL workbook file IF the sheet I want to import is the first sheet in the file. So, I would still need to get PC Files Server running correctly to import more than one sheet from the same EXCEL file. ... View more

So, I tried using PROC IMPORT with DBMS=XLSX and no RANGE statement, and it works IF I pull the sheet that I want to import out and save it in its own EXCEL workbook file. So, I have a workable temporary solution, but it won't work large scale because what I want to import are all EXCEL sheets that are derived from data in other sheets in the workbook. I guess the only long-term solution is to get PC Files Server to work again. ... View more

I tried using the libname statement you suggested - no errors running it. Looking in the library, I don't see any sheets. The library looks empty even though the Excel workbook has 3 sheets in it. ... View more

And I am running a local version of SAS 9.4 under Windows 10 (x64). It's Windows 10.0.1863 to be exact. ... View more

I tried that, but SAS doesn't seem to be finding the sheet that I want to import in the Excel workbook. The revised code looks like: PROC IMPORT OUT= city_DBH DATAFILE= "D:\Laptop_UFORE_Output\Street tree reports\State\City.xlsx" DBMS=XLSX REPLACE; RANGE="sheet$"; RUN;   ... View more

PROC IMPORT OUT= City_trees_DBH DATAFILE= "D:\Laptop_UFORE_Output\Street tree reports\California\City\treedata.xlsx" DBMS=EXCELCS REPLACE; RANGE="DBH"; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Error Message: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. ERROR: Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.98 seconds cpu time 0.31 seconds   ... View more