|Date: ||Tue, 28 Jul 2009 09:34:32 -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: sheet name when using excelxp|
|Content-Type: ||text/plain; charset=ISO-8859-1|
Are you using v1.86 (the newest version, not the version that shipped with
9.1.3)? Available here:
The version that shipped with 9.1.3 didn't support sheet names properly, if
I remember correctly.
On Tue, Jul 28, 2009 at 8:31 AM, RAMS <firstname.lastname@example.org> wrote:
> Dear all,
> I am using ods excelxp to write my outputs in external file.
> I am using the dataset sashelp.class with the by variable sex.
> so this creates two sheets with the name "Table 1 - Data Set WORK.NEW"
> and "Table 2 - Data Set WORK.NEW".
> option sheet_name is not working here. how can i rename it in SAS.
> Thanks in advance.
> Ramsathish S