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
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");
create table `name with space`
(`dsmb date` varchar(8),
) by excel;
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