BookmarkSubscribeRSS Feed
omega1983
Calcite | Level 5

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

2 REPLIES 2
andreas_lds
Jade | Level 19

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

jwsquillace
SAS Employee

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 678 views
  • 0 likes
  • 3 in conversation