| Date: | Tue, 28 Jul 2009 06:31:10 -0700 |
| Reply-To: | RAMS <ramsathish@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | RAMS <ramsathish@GMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | sheet name when using excelxp |
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
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
|