|
Also: What version of Excel?
On Fri, 6 Jan 2006 17:17:23 -0800, David L Cassell <davidlcassell@MSN.COM>
wrote:
>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/
|