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: owner-sas-l@listserv.uga.edu [mailto:owner-sas- > l@listserv.uga.edu] 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 > > 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