|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|
|Content-Type: ||text/plain; charset=ISO-8859-1|
You need to refer to the sheet as
(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.
On Mon, Mar 23, 2009 at 10:41 AM, d-dubs <firstname.lastname@example.org> wrote:
> 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.