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
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
>
| 
