05-23-2013 05:32 PM
%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";
set FAAATXLS.'FNMA$'n;/*Must match the tab name in excel spreadsheet*/
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??
05-24-2013 02:39 PM
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.