LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2008, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 > >>> > > >


Back to: Top of message | Previous page | Main SAS-L page