Date:         Mon, 28 Jun 1999 11:07:31 -0500
Reply-To:     Peterson Christopher L MSgt AFPC/DPSARA
              <Christopher.Peterson@AFPC.RANDOLPH.AF.MIL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     To: "SDHIMAN@SEARS.COM" <SDHIMAN@SEARS.COM>
From:         Peterson Christopher L MSgt AFPC/DPSARA
              <Christopher.Peterson@AFPC.RANDOLPH.AF.MIL>
Subject:      Re: Proc Tabulate output to Excel
Comments: To: SAS-L@LISTSERV.VT.EDU

Try using the HTML formatting tool tab2htm.  You can then cut and
paste(special) straight to EXCEL. It formats very nicely.

-----Original Message-----
From: SDHIMAN@SEARS.COM [mailto:SDHIMAN@SEARS.COM]
Sent: Monday, June 28, 1999 7:54 AM
To: SAS-L@VM.MARIST.EDU
Subject: Proc Tabulate output to Excel


Is there a clean way to take Proc Tabulate output and directly move it into
a
Microsoft Excel spreadsheet?  Currently, we create the Tabulate output on
Unix
and ftp the .lst file to the PC.  On the PC side we use products like
Monarch to
clean-up the Tabulate boxes before importing into Excel.
Environment: SAS on Dec-Unix, PC running NT4.0 and Excel 97

TIA

Shailesh Dhiman