| Date: | Mon, 23 Mar 2009 10:48:11 -0500 |
|---|
| Reply-To: | Joe Matise <snoopy369@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Joe Matise <snoopy369@GMAIL.COM> |
|---|
| Subject: | Re: delete tabs from excel |
|---|
|
| In-Reply-To: | <c31ac83d-e15f-43fb-b0e2-2435bbf6b16e@k2g2000yql.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
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.denniswilliams@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
>
| 
