Date:         Wed, 4 Feb 2004 20:55:45 -0500
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: Outputting a table to Excel

"Peter" <peter.papas@sympatico.ca> wrote in message
news:nbgUb.8715$bp1.469657@news20.bellglobal.com...
> Hi,
>
> I need some help with how to output a "new" table to Excel.  I am new to
SAS
> and only try and post on the newsgroup if I cannot find the answer myself.
> In this case I just cannot seem to find it...:(
>
> I input some data using the data step and then manipulate it into a format
I
> want using "proc transpose" or "proc tabulate".  The problem is the "new"
> table I have created is displayed in the output window.  I need to export
> the table to excel.  I know where the data is stored that I read into sas
> using the data step, but it is not in the format I want.
>
> How do I output the "new" table?
>
> Thank you in advance for your help!
>
> Peter

This example shows how to move html files into sheets of a workbook; the
html files are created using ODS and Proc TABULATE.
www.devenezia.com/downloads/sas/samples#excelmultisheet

There are many other techniques.

--
Richard A. DeVenezia