as with dates that are 'special': '2010-05-06'd
add the n==name suffix to the string which says: "don't mess w/this!"
'sheet name with space'n
not sure this will work in sql, tho
Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov
> -----Original Message-----
> From: firstname.lastname@example.org [mailto:owner-sas-
> email@example.com] On Behalf Of Yu Zhang
> Sent: Thursday, May 06, 2010 4:13 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: create a WORKSHEET with a space in the sheet name
> I am trying to write a code to update an EXCEL worksheet in place. the
> step is to create an empty worksheet and use the name client provided.
> I need to do this within from SAS. I googled around and found the
> passthrogh facility can be used for my task.
> here is the code
> proc sql dquote=ansi feedback;
> CONNECT TO EXCEL (PATH="d:\test.xls");
> execute (
> create table `name with space`
> (`dsmb date` varchar(8),
> pulldate date,
> `all` long,
> CLP long,
> Placebo long
> ) by excel;
> the worksheet was created successfully expcept the space in the
> changed to '_' by SAS.
> Is there any way to prevent this happen? Note the back tick was used
> the sheetname [name with space]. it is not the single quote.
> what surprise me was the column name [DSMB DATE] was created as
> intended? no
> underscore substitution.