Date: Thu, 2 Dec 2004 07:49:42 -0500
Reply-To: Ed Heaton <EdHeaton@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ed Heaton <EdHeaton@WESTAT.COM>
Subject: Re: how to read the excel sheet with blank space in the sheet nam
e
Content-Type: text/plain; charset="iso-8859-1"
rao,
The short answer is ...
Options validVarName=any ;
Of course, it depends on the version of SAS that you are using.
If you use this option, you will need need to use a name literal to refer to
the table. A name literal is in quotes and followed immediately by an en.
E.g.,
"Hospitalizations in period"n
How are you getting your data into SAS? There are quite a few ways. E.g.:
* A LIBNAME statement using one of these engines...
* EXCEL (v9 or above)
* OLEDB
* ODBC
* PROC IMPORT
* Dynamic Data Exchange (DDE)
* Output as delimited file and then read with a DATA step
Ed
Edward Heaton, SAS Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1600 Research Boulevard, RW-3541, Rockville, MD 20850-3195
Voice: (301) 610-4818 Fax: (301) 610-5128
mailto:EdHeaton@Westat.com http://www.Westat.com
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
nageswara punnani
Sent: Wednesday, December 01, 2004 12:12 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: how to read the excel sheet with blank space in the sheet name
hello all ,
I am trying to read in a excel file with multiple sheets into SAS.
everything seems to be okay except that the sheets have blank spaces in
their filenames. the log says "expecting a name" . for eg. I have a sheet
that has a name "Hospitalizations in period" . SAS is giving errors for that
blank character in the sheet name.can anyone tell me how to read in the
sheets with blankspaces in their names . any help is greatly appreciated.
rao.
