Date:         Mon, 31 Mar 2003 07:38:18 -0800
Reply-To:     Richard <richard@VARIA.NU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard <richard@VARIA.NU>
Organization: http://groups.google.com/
Subject:      SAS to different worksheets in excel
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I have a small problem regarding creating tables in excel. I have a
sas program where I use a lot of proc tabulate to create tables from a
dataset. I want to export the tables to excel. I know that I can use
ods to save the table with the extension ".xls" to get a file that I
can open in Excel, but using that method I get one Excel file for
every proc tabulate. Is there some way to save the different tables as
different worksheets in one Excel file?

Thanks,

Richard