topic Re: Server Connection Not Reading xlsx file in SAS Procedures

Server Connection Not Reading xlsx file

omega1983 — Thu, 23 May 2013 21:32:26 GMT

%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??

Re: Server Connection Not Reading xlsx file

andreas_lds — Fri, 24 May 2013 13:12:50 GMT

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

Re: Server Connection Not Reading xlsx file

jwsquillace — Fri, 24 May 2013 18:39:48 GMT

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