Help using Base SAS procedures

Error when creating the libname for an Excel file

Reply
Contributor
Posts: 58

Error when creating the libname for an Excel file

Hi to all,
I don't know why, but since today I cannot import anymore the metadata for a file Excel. I've tried to make a new libname, and what happens is that it tries to generate the libname, adding as options my username and my password.
But I'm using the SAS Access for Excel, so this options are (naturally) found as invalid!
I've tried to understand why this happens, but still I cannot find any idea Smiley Sad
Super User
Posts: 5,424

Re: Error when creating the libname for an Excel file

Posted in reply to DanieleTiles
By saying "import anymore the metadata" i presume that you are in DI Studio or management Console, or...? In this case, the following note could be of interest:http://support.sas.com/kb/16/676.html
Even if the note states that there is no workaround for Excel files, I believe there is: you need to specify a new authentication domain, which has no logins attached to it, and attach it to your Excel libnames.

/Linus
Data never sleeps
Contributor
Posts: 58

Re: Error when creating the libname for an Excel file

Linus, thanks! It works as it should be! Smiley Very Happy
Ask a Question
Discussion stats
  • 2 replies
  • 108 views
  • 0 likes
  • 2 in conversation