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 (October 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 5 Oct 2009 07:50:19 -0500
Reply-To:     Joe Matise <snoopy369@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joe Matise <snoopy369@GMAIL.COM>
Subject:      Re: Bare Bones Excel Tagset?
Comments: To: "Vandenbroucke, David A" <David.A.Vandenbroucke@hud.gov>
In-Reply-To:  <C52C73B4FBA57D4BAE1830EE9CB032F3022463A566@EXMAIL05A.exh.prod.hud.gov>
Content-Type: text/plain; charset=ISO-8859-1

The style template that is used will apply (or not apply) formatting. You can override nearly all of the formatting elements that way. Look at the documentation for PROC TEMPLATE for more details.

-Joe

On Mon, Oct 5, 2009 at 6:48 AM, Vandenbroucke, David A < David.A.Vandenbroucke@hud.gov> wrote:

> Is there an Excel tagset that doesn't do any formatting? All of the ones > I've tried do a lot with shading, borders, special fonts, etc. I certainly > understand how those things can be useful. However, most of the time what I > want to do is just put, say, PROC REPORT output into an Excel file, where I > or others might well want to manipulate the data and presentation further. > At present, my first task is usually to remove all the formatting that ODS > puts into the spreadsheet. Is there some kind of vanilla tagset that will > save me this work? > > Dav Vandenbroucke > Senior Economist > U.S. Dept. HUD > david.a.vandenbroucke@hud.gov > 202-402-5890 > > I disclaim any disclaimers. >


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