Help using Base SAS procedures

Server Connection Not Reading xlsx file

Reply
Contributor
Posts: 59

Server Connection Not Reading xlsx file

%let wind_dir = %str(\\La016x902\Comp1Share\Corporate\);

%let inputxls = %str(Complaints_Input_File_FAAAT_Request.xlsx);

%let xlspth = &wind_dir&inputxls;

libname FAAATXLS pcfiles type = excel server=LA016X902 port=8621 path="&xlspth";

data loans;

  set FAAATXLS.'FNMA$'n;/*Must match the tab name in excel spreadsheet*/

run;

libname FAAATXLS clear;

I keep getting

 

ERROR: File FAAATXLS.'FAAAT$'n.DATA does not exist.

The xlsx file name is correct and the tab does say FAAAT.  Is there any special rules on naming the libnames, in this case FAAATXLS??

Super Contributor
Posts: 259

Re: Server Connection Not Reading xlsx file

Which SAS version is installed on the server? Have you tried omitting the type-option?

SAS Employee
Posts: 26

Re: Server Connection Not Reading xlsx file

The libref has to be 8 or fewer characters, but that is what you have....

Do you get any messages about the success/failure of the LIBNAME statement?

Try putting RUN; after the LIBNAME, run PROC CONTENTS and see if the library connection is working.

Another possibility -- is there a macro-populated range in the workbook?  If yes, you may have to open the file in Excel first and force the pointers to resolve to actual values, save the value, then read it in SAS.

Good luck!

Jan

Ask a Question
Discussion stats
  • 2 replies
  • 154 views
  • 0 likes
  • 3 in conversation