Date:         Fri, 15 Sep 2006 15:59:49 -0700
Reply-To:     toby989@HOTPOP.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby989@HOTPOP.COM
Subject:      Re: wizard sees sheet of an excel but does not import it
Comments: To: sas-l@uga.edu
In-Reply-To:  <A4F0DBF1F84D4F46A0E6D56405D3511989E4E4@HHAEXMB03.rf01.itservices.ca.gov>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi Paul

Ichecked for leading and trailing blanks before already. So that seems not to be
the cause.

Thanks Toby



Choate, Paul@DDS wrote:
> Hi Toby -
>
> The most likely candidate is that there is a leading space in the sheet
> name in Excel.  his would cause this in you wizard log:
>
> ERROR: Prepare: Invalid bracketing of name ' All hospitals$'.
> SQL statement: SELECT * FROM ` All hospitals$`
> ERROR: Import unsuccessful.  See SAS Log for details.
>
> And then the error you give if you left the leading blank off the import
> procedure sheet statement.
>
> Try this fix: select the Excel sheet name tab and use ctrl-v to copy the
> name and then paste it into your import procedure sheet statement like
> this (including the trailing $):
>
>      SHEET="'copied name here$'";
>
> (The $ indicates that you want a sheet and not a named range.)
>
> hth
>
> Paul Choate
> DDS Data Extraction
> (916) 654-2160
> -----Original Message-----
> On Wed, 13 Sep 2006 16:49:58 -0700, toby989@HOTPOP.COM wrote:
>
>
>>Hi All
>>
>>The wizard (file > import . standard data source: microsoft excel 97,
>
> 2000 or
>
>>2002 workbook) in its next screen lets me allow to select 'All
>
> hositals$'
> as the
>
>>sheet to import it, but then running it does not work. proc import
>
> doesnt work
>
>>either.
>>
>>ERROR: File _IMEX_.'All hospitals$'n.DATA does not exist.
>>ERROR: Import unsuccessful.  See SAS Log for details.
>>
>>proc import datafile="c:\PSC Pipeline.xls" out=v dbms=excel replace;
>>sheet='All hospitals'; getnames=no; dbsaslabel=none;
>>run;
>>
>>Toby
>>
>>
>>sas9.1.3sp4 win2000