Date:         Thu, 6 May 2010 16:13:28 -0400
Reply-To:     Yu Zhang <zhangyu05@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Yu Zhang <zhangyu05@GMAIL.COM>
Subject:      create a WORKSHEET with a space in the sheet name

Hello,

I am trying to write a code to update an EXCEL worksheet in place. the first
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 SAS/ACCESS
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;
quit;

the worksheet was created successfully expcept the space in the sheetname
changed to '_' by SAS.

Is there any way to prevent this happen? Note the back tick was used to for
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.


TIA.

Yu