Hi Kevin, that's maybe a memory error. If you have many libraries in a SET statement, SAS allocates a buffer for each. I don't know if that works, try it out:

data s; set sashelp.class open=defer sashelp.class open=defer; run;

that should close the first dataset before opening the second. Some things which require them to be opened at start do not work with that. For example if the second dataset has a variable which is not in the first. I'm not sure that it works with special libnames / datasets at all, but if the structure is the same for all, that might do it.

Gerhard

On Thu, 21 Oct 2010 11:31:45 -0500, Sudo Ku <crafty876@HOTMAIL.COM> wrote:

>Hello: > >I am importing a number of excel files using the libname statement and get the following error on the 66th library I try to create... > >ERROR: Connect: Unspecified error >ERROR: Error in the LIBNAME statement. > >The syntax for importing is good so I am assuming there is a limit of 65 excel files that can be opening in any given session. > >Any ideas for a work around and I am specifically looking for something that will allow me to close some libraries (read excel files) and then open others. When I importing and aggregating the infomation I need I wont need to create so many libnames. At present I am just (manually) exploring what I have in these excel files. I had thought the libname statement would have been a good way to open lot of excel files and gather metadata on the sheet names number of row/columns etc... > >Thanks for the help, > >Kevin