Date:         Mon, 9 Apr 2012 16:46:04 -0400
Reply-To:     KarlK <karlstudboy@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         KarlK <karlstudboy@HOTMAIL.COM>
Subject:      Re: Tweaking XML code from SAS

Does this paper help at all?

http://www.nesug.org/Proceedings/nesug10/bb/bb07.pdf

Karl


On Mon, 9 Apr 2012 13:14:20 -0600, Alan Churchill <savian.net@GMAIL.COM>
wrote:

>Jeff,
>
>You could also take the easy way out and find the value using regex and
make
>the change that way.
>
>Thanks,
>
>Alan
>
>Alan Churchill
>O: 719-687-5954
>C: 719-310-4870
>
>
>-----Original Message-----
>From: Jeff Kroll [mailto:jeffrey.kroll@US.ING.COM]
>Sent: Monday, April 09, 2012 9:09 AM
>Subject: Tweaking XML code from SAS
>
>Ive been playing around with creating Excel spreadsheets from SAS datasets
>using tagsets.excelxp.  Im generally having luck doing what I want to do.
>One thing I notice is that if I have dataset with only a few rows, then
when
>opened in Excel those rows are shown but the remainder of the worksheet
is a
>single solid color(white) with no gridlines showing.  In examining the XML
>code generated by SAS I found that if were to change a piece of code from
>ss:Pattern="Solid" to ss:Pattern="None" the field of white goes away and
the
>gridlines return. This is what I would rather have.  The question is, how
do
>I get SAS to change Solid to None?  I dont see any way in the ExcepXP
tagset
>or in the Default style that Im using.  Is it possible to change this
value?
>
><Style ss:ID="_body">
> <Interior ss:Pattern="Solid" />
> <Protection ss:Protected="1" />
></Style>
>
>I running SAS 9.2 on Windows XP