Program can't read EXCEL files.. and error msg shows up

Reply
New Contributor
Posts: 4

Program can't read EXCEL files.. and error msg shows up

I am trying to reference an excel workbook files by using LIBNAME statement.. and i get an error message saying that libname statement has error

below is what i have typed in and error message i have received.

libname custfm 'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';

ERROR: CONNECT: ???? ???? ?????.

ERROR: ERROR in the LIBNAME statement.

Can anyone please help..? Smiley Sad

Super User
Posts: 19,860

Re: Program can't read EXCEL files.. and error msg shows up

1. can you import via program import?

2. Try a few other variations

libname custfm excel 'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';

libname custfm excelcs 'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';

libname custfm pcfiles path= 'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';

libname custfm xlsx  'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';

New Contributor
Posts: 4

Re: Program can't read EXCEL files.. and error msg shows up

I have installed 'pcfiles' driver but it still doesn't work...

and also import wizard gives same error message as before.. Smiley Sad

Super User
Posts: 19,860

Re: Program can't read EXCEL files.. and error msg shows up

Do you have the license to import Excel file?

Run the following and check to see if you have SAS/CONNECT and/or SAS/ACCESS ( I can never remember which one you need)

proc setinit; run;

New Contributor
Posts: 4

Re: Program can't read EXCEL files.. and error msg shows up

I have just checked and it says that i do have both SAS/CONNECT and SAS/ACCESS...

should i delete and reinstall practice files maybe..?

Super User
Posts: 19,860

Re: Program can't read EXCEL files.. and error msg shows up

Are you using the SAS web edition? or Tech Support first. 

Is your SAS 64 bit? What bit is Excel?

Post the exact code/log error?

New Contributor
Posts: 4

Re: Program can't read EXCEL files.. and error msg shows up

I don't really know SAS i am using is either web edition or Tech support first.

I am a university student and purchased SAS license along with program through my school (it is valid till June 2014)

SAS i am using now is SAS 9.4 (64 bit) and Microsoft Excel i have is 64 bit as well and its excel 2010

below is the code i have put and error msg i have received.

libname custfm 'C:/Users/steven/Documents/coursedata/My SAS Files/ECPRG1/custfm.xls';


Log message follows.


ERROR: CONNECT: ???? ???? ?????.     =>(i don't know why it shows number of question marks.. )

ERROR: ERROR in the LIBNAME statement.


Thank you Smiley Happy

Super User
Posts: 19,860

Re: Program can't read EXCEL files.. and error msg shows up

That should have read contact Tech Support first Smiley Happy. They're extremely helpful. 

Ask a Question
Discussion stats
  • 7 replies
  • 410 views
  • 0 likes
  • 2 in conversation