Date:         Tue, 18 Jan 2011 14:51:13 -0800
Reply-To:     Sterling Paramore <gnilrets@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sterling Paramore <gnilrets@GMAIL.COM>
Subject:      Re: SAS Stored Process in AMO (Excel) - Sending Data To Multiple
              Worksheets
In-Reply-To:  <009501cbb761$4d9e1eb0$e8da5c10$@savian.net>
Content-Type: text/plain; charset=ISO-8859-1

I would then have to distribute and install that add-in to all of the
clients, correct?

On Tue, Jan 18, 2011 at 2:44 PM, Alan Churchill
<alan.churchill@savian.net>wrote:

> You could write a custom AMO add-in and do it that way. An add-in can do
> pretty much anything needed but it is more complex. A thought in case the
> other avenues don't pan out.
>
> Alan
>
> Alan Churchill
> Savian
> Work:   719-687-5954
> Cell:  719-310-4870
>
> -----Original Message-----
> From: Sterling Paramore [mailto:gnilrets@GMAIL.COM]
> Sent: Tuesday, January 18, 2011 1:51 PM
> Subject: SAS Stored Process in AMO (Excel) - Sending Data To Multiple
> Worksheets
>
> Dear SAS-L,
>
> I have a stored process that I need to run in Excel (via AMO) and create
> multiple tabs of formatted data.  This seems possible, because when I run a
> stored process on the logical workspace server through AMO Excel and
> produce
> both ODS output and write a dataset to SASUSER, the ODS output gets put on
> one worksheet, and the dataset gets output to another worksheet.  Is there
> anyway to send ODS output to multiple sheets?
>
> For example,
>
> ods html (id=ws1) <what goes here?>;
> proc print data = SASHELP.Class;
> run;
> ods html(id=ws1) close;
>
>
> ods html (id=ws2) <what goes here?>;
> proc print data = SASHELP.Cars;
> run;
> ods html(id=ws2) close;
>