| 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 |
|---|
|
| In-Reply-To: | <b5ecf09f-6164-4958-a0e2-7fc5f20eef92@12g2000pri.googlegroups.com> |
|---|
| 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:
http://support.sas.com/rnd/base/ods/odsmarkup/index.html
The version that shipped with 9.1.3 didn't support sheet names properly, if
I remember correctly.
-Joe
On Tue, Jul 28, 2009 at 8:31 AM, RAMS <ramsathish@gmail.com> 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.
>
> Regards,
>
> Ramsathish S
>
|
