Date:         Thu, 21 Oct 2010 12:47:35 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Max number of Libraries?

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