Date:         Mon, 3 Mar 2008 13:58:24 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: System Resource Exceeded Error Using Excel Engine
Comments: To: "Gerstle, John (CDC/CCID/NCHHSTP) (CTR)" <yzg9@cdc.gov>
In-Reply-To:  <C2E5415029572742B0C9964EF2EB5ACA04984538@LTA3VS003.ees.hhs.gov>
Content-Type: text/plain; charset=ISO-8859-1

Sorry, obviously this hillbilly is not paying attention.

On Mon, Mar 3, 2008 at 1:52 PM, Gerstle, John (CDC/CCID/NCHHSTP) (CTR)
<yzg9@cdc.gov> wrote:
> That's a good idea, but the libname is not being assigned so I can't get
> that far.
>
> John Gerstle
> MS Applied Neuroscience, MS Applied Statistics
> Biostatistician
> Northrop Grumman
> CDC Information Technological Support Contract (CITS)
> NCHSTP \DHAP \HICSB \Research and Dissemination Team
> Centers for Disease Control and Prevention
> Phone: 404-639-3980
> Fax: 404-639-2980
> yzg9 at cdc dot gov
>
> >>-----Original Message-----
> >>From: data _null_, [mailto:datanull@gmail.com]
> >>Sent: Monday, March 03, 2008 1:43 PM
> >>To: Gerstle, John (CDC/CCID/NCHHSTP) (CTR)
> >>Cc: SAS-L@listserv.uga.edu
> >>Subject: Re: System Resource Exceeded Error Using Excel Engine
> >>
> >>Try using open=defer;
> >>
> >>data cc_alldata; set %loop_states open=defer; run;
> >>
> >>I don't know if it works for EXCEL engine.
> >>
> >>On Mon, Mar 3, 2008 at 1:38 PM, Gerstle, John (CDC/CCID/NCHHSTP) (CTR)
> >><yzg9@cdc.gov> wrote:
> >>> I hadn't thought there was a limit to the Excel engine when using it
> in
> >>> a LIBNAME statement.  But apparently there is...
> >>>
> >>> Has anyone run into this error:
> >>>
> >>> Log:
> >>> 1372  libname metro excel "c:\somefolder\US Demographic by County
> Sex
> >>> Race Age Group &year..xls" ver=2002 header=yes
> >>> 1372! mixed=yes/**/;
> >>> ERROR: Connect: System resource exceeded.
> >>> ERROR: Error in the LIBNAME statement.
> >>>
> >>> 1373  libname metro clear;
> >>> WARNING: Libname METRO is not assigned.
> >>>
> >>> Background: I've downloaded and imported 51 datasets (Census data,
> by
> >>> county, sex, race, age) into one Excel file. The file size is
> ~250Mb.  I
> >>> thought I could loop through and read all 51 tabs via this code:
> >>>
> >>> %macro loop_states;
> >>> %let states= AL AK AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY
> LA MA
> >>> MD ME MI MN MO
> >>>              MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TN
> TX
> >>> UT VA VT WA WI WV WY ;
> >>> %do i=1 %to 51;       %let st=%scan(&states,&i); metro."&st..$"n
> %end;
> >>> %mend;
> >>>
> >>> /**Creates datasets from the Excel spreadsheet of HARS to NDPI
> Variable
> >>> Mapping***/
> >>> libname metro excel "&datapath.\US Demographic by County Sex Race
> Age
> >>> Group &year..xls" ver=2002 header=yes mixed=yes/**/;
> >>> data cc_alldata; set %loop_states ; run;
> >>> libname metro clear;
> >>>
> >>>
> >>> I know I could do this via a pipe or loop through the original
> files,
> >>> but I like using Excel to standardize fields (for example, during
> >>> import, I can be sure that Excel and subsequently SAS will see the
> FIPS
> >>> code fields as Text and not General, thereby keeping the leading
> >>> zeroes).
> >>>
> >>> Any suggestions?  Thanks
> >>>
> >>> John Gerstle
> >>> MS Applied Neuroscience, MS Applied Statistics
> >>> Biostatistician
> >>> Northrop Grumman
> >>> CDC Information Technological Support Contract (CITS)
> >>> NCHSTP \DHAP \HICSB \Research and Dissemination Team
> >>> Centers for Disease Control and Prevention
> >>> Phone: 404-639-3980
> >>> Fax: 404-639-2980
> >>> yzg9 at cdc dot gov
> >>>
>
>
>