LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 23 Mar 2009 13:33:18 -0500
Reply-To:     "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: delete tabs from excel
Comments: To: Gerhard Hellriegel <gerhard.hellriegel@t-online.de>
In-Reply-To:  <200903231803.n2NG05CD017240@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

'excel|system'

On 3/23/09, Gerhard Hellriegel <gerhard.hellriegel@t-online.de> wrote: > On Mon, 23 Mar 2009 09:29:28 -0700, CaliGal <leslie.rios@PHS.COM> wrote: > > >On Mar 23, 8:48 am, snoopy...@GMAIL.COM (Joe Matise) wrote: > >> You need to refer to the sheet as > >> 'Sheet1$'n > >> (or whatever it's named) to get SAS to recognize it. > >> > >> That said, I'm not 100% sure SAS will let you delete a tab in a > worksheet, > >> but perhaps only because I've never tried. > >> -Joe > >> > >> > >> > >> On Mon, Mar 23, 2009 at 10:41 AM, d-dubs <m.denniswilli...@gmail.com> > wrote: > >> > Hi > >> > I am trying to delete a few tabs from a excel workbook which has the > >> > special character '$' appended at the end. > >> > I am not able to delete it using a proc sql - delete statement or a > >> > proc datasets. > >> > Please let me know if I can delete these tabs through sas steps. > >> > thanks- Hide quoted text - > >> > >> - Show quoted text - > > > >DDE can be used to delete a worksheet: > > > > data _null_; > > file cmds; > > put '[error(false)]'; > > put '[WORKBOOK.SELECT("Summary")]'; > > put '[WORKBOOK.DELETE("Summary")]'; > > put '[error(false)]'; > > run; > > > That's interesting! I had something in mind with DDE, but I don't know the > syntax. Also I miss the definition of the file CMDS. > > I'm not firm with DDE to EXCEL... > Must be something like: > > filename cmds DDE "what_here? no DDE triplet, I think..."; > > Could you please add this? Ok, maybe in the documentation, but if you have > it already... > > Thanks, > > Gerhard >


Back to: Top of message | Previous page | Main SAS-L page