%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??
Which SAS version is installed on the server? Have you tried omitting the type-option?
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.