Limit to number of libraries with Excel engine?
This is related to the problem I originally posted in "Use of Call
Execute in Proc SQL". I am trying to create 1,000 multisheet Excel
workbooks. All the data that must be exported to these workbooks is
contained in a single SAS data set. I attempted to create the 1,000
libraries (using the Excel engine), so I can subsequently use the hash
method of splitting a file into multiple data sets. I thought this would
be preferable to how I usually do things, which would be by splitting
the data set into 1,000 different data sets and then exporting them in
1,000 different data steps.
However, when I try to create 1,000 libraries through the following
method, only 64 are created. The remaining observations have a return
code of 7280001, i.e. "ERROR: Connect: Unspecified error".
rc = libname(cats('_', id)
, cats("&folder_output\", id, ".xls"));
msg = sysmsg();
I have not been able to turn up any information on the specific return
code or limits to the number of libraries that can simultaneously be
opened. Evidently there is limit of 64 libraries using the Excel engine
within a windows environments? Are there any options to get around this
limit? Is there any more elegant method to create the workbooks aside
from creating 64 libraries at a time, exporting the data, clearing the
libraries, then creating new libraries? I attempted to create and delete
the libraries one at a time within the same data step containing the
hash table, but it seems the libraries are not created until the data
step is finished executing.
|Thread||Thread Starter||Forum||Replies||Last Post|
|Re: Limit to number of libraries with Excel engine?||./ ADD NAME=Data _null_,||Newsgroup comp.soft-sys.sas||0||09-30-2008 08:02 PM|
|Re: Limit to number of libraries with Excel engine?||Bucher Scott||Newsgroup comp.soft-sys.sas||0||09-30-2008 07:31 PM|
|Re: Limit to number of libraries with Excel engine?||Alan Churchill||Newsgroup comp.soft-sys.sas||0||09-30-2008 07:31 PM|
|Re: Limit to number of libraries with Excel engine?||Mary||Newsgroup comp.soft-sys.sas||0||09-30-2008 07:26 PM|
|Re: Importing and exporting to Excel while Excel 2007 installed||Ed Heaton||Newsgroup comp.soft-sys.sas||1||09-17-2008 11:09 PM|