LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2006, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 6 Jan 2006 21:38:57 -0500
Reply-To:   "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:   Re: ODS-EXCEL
Content-Type:   text/plain; charset=ISO-8859-1

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! >

Back to: Top of message | Previous page | Main SAS-L page