| Date: | Mon, 16 Feb 2009 06:36:53 -0600 |
|---|
| Reply-To: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM> |
|---|
| Subject: | Re: Exporting data into Multiple tabs usong OCS tagset ExcelXP |
|---|
|
| In-Reply-To: | <f1394862-9623-4325-a338-2c01f6819222@k8g2000yqn.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
I ran this...
ods tagsets.excelxp file='multitable.xml' style=sasweb
options(sheet_name='XXXXX');
proc print data=sashelp.class;
run;
ods tagsets.excelxp options(sheet_interval='none' sheet_name='YYYYYY');
proc print data=sashelp.shoes;
run;
ods tagsets.excelxp close;
on a SUN using SAS 9.1.3 with
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.28, 08/29/05). Add options
and
NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.86, 04/15/08). Add options
Versions of the tag set and both produce the multi sheet work book
when opened in XL. The newer version look better. Do you have any
more specific information regarding your problem as I cannot
replicate?
On 2/16/09, kishore.shyamala <kishorekumar.shyamala@gmail.com> wrote:
> Hi,
>
> I have a problem creating multiple tabs in a single workbook using ODS
> tagset excelxp.
>
> The sheet_name option seams not assigning the name provided, instead
> the sheets are created with default names like table1, table2....
>
> The code I used is
>
> ods tagsets.excelxp file='multitable.xml' style=sasweb options
> (sheet_name='XXXXX');
> /*****sas code********/
> ods tagsets.excelxp options(sheet_interval='none'
> sheet_name='YYYYYY');
> /*****sas code********/
> ods tagsets.excelxp close;
> ods listing;
>
> I am running SAS 9.1 on HP-UX server.
>
> Thanks in advance.
>
> Regards,
> Kishore Shyamala.
>
| 
