|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|
|Content-Type: ||text/plain; format=flowed|
>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
exact route would be a lot clearer if you could be more specific. If you
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
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
or PROC REPORT? In another proc? Write back to SAS-L and let us know.
David L. Cassell
3115 NW Norwood Pl.
Corvallis OR 97330
Donít just search. Find. Check out the new MSN Search!