Date:         Fri, 6 Jan 2006 17:17:23 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: ODS-EXCEL
In-Reply-To:  <200601070101.k06LxxAV008537@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

hongzl@OPTONLINE.NET wrote:
>Does anybody know that can SAS generate EXCEL output by ODS? And the
>background, color of words, bold can be set up in the EXCEL sheet? Any
>advise is appreciated!

Sure!  There are lots of ways.  ODS is probably what you're looking for, but
the
exact route would be a lot clearer if you could be more specific.  If you
have
SAS 9, there are extra options.  If you have SAS/ACCESS for PC File Formats,
you have even more options available.  And if you have SAS BI Server, then
you
have additional ways.

So... what do you want to do?  What output from what proc are you trying
to create?  Which of the above SAS modules do you have available?  Are you
trying to do this in a DATA _NULL_ step?  In one of PROC PRINT, PROC
TABULATE,
or PROC REPORT?  In another proc?  Write back to SAS-L and let us know.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/