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" <firstname.lastname@example.org> wrote in message
> I need some help with how to output a "new" table to Excel. I am new to
> 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
> 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!
This example shows how to move html files into sheets of a workbook; the
html files are created using ODS and Proc TABULATE.
There are many other techniques.
Richard A. DeVenezia