Suppress Borders in ODS Tagsets ExceXP?
in [SAS]
|
From: Joe Matise on 3 Mar 2010 11:48 Doesn't that override whatever style you're currently using, though? Or did they fix that? Also never had luck with bordercolor=white actually removing borders [as opposed to creating a white border, which is not the same]... -Joe On Wed, Mar 3, 2010 at 10:27 AM, Mary <mlhoward(a)avalon.net> wrote: > David, > > No, you don't have to create a style. I put this in as a SAS ticket and it > was figured out just a few weeks ago. In Proc Report, you can do this: > > proc report data=coversheet nowindows > style(report)={background=white foreground} > style(header column)={borderrightcolor=white borderleftcolor=white > borderleftwidth=1 bordertopcolor=white borderbottomcolor=white > borderrightwidth=1 bordertopwidth=1 borderbottomwidth=1}; > > > The advantage of this with Excel Tagsets is that you can override the > borders on some sheets and not on others (I was attempting to create a cover > sheet without borders when the rest of the sheets had tables in them that I > wanted borders on). > > -Mary > > > --- snoopy369(a)GMAIL.COM wrote: > > From: Joe Matise <snoopy369(a)GMAIL.COM> > To: SAS-L(a)LISTSERV.UGA.EDU > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > Date: Wed, 3 Mar 2010 10:17:19 -0600 > > Something like this: > > proc template; > > define style <name>; > parent=<parent name>; > replace <style element> from <style category> / > borderleftwidth=undef > bordertopwidth=undef > borderbottomwidth=undef > borderrightwidth=undef > ; > end; > > quit; > > Give or take. Not an expert in this myself but it seems to work. Only > problem I have is that excelxp tagset doesn't always play well with newly > created styles... some bugs in it still I think. > > -Joe > On Wed, Mar 3, 2010 at 10:10 AM, Vandenbroucke, David A < > David.A.Vandenbroucke(a)hud.gov> wrote: > > > Thank you. Now I have to learn how to define a style. > > > > --Dav > > david.a.vandenbroucke(a)hud.gov > > > > > > > > From: Joe Matise [mailto:snoopy369(a)gmail.com] > > Sent: Wednesday, March 03, 2010 11:06 AM > > To: Vandenbroucke, David A > > Cc: SAS-L(a)listserv.uga.edu > > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > > > > From my experience, typically you have to do it by defining your own > style > > in PROC TEMPLATE and using borderwidth=UNDEF. I don't think you can > > override specific elements of a style at PROC REPORT time (although I > > thought I saw something about this being possible in 9.2, I haven't seen > > evidence of that working myself). > > > > That said, you can always produce your own style based off of JOURNAL2 > > fairly trivially, just use it as the Parent style. > > > > -Joe > > > > >
From: Mary on 3 Mar 2010 13:31 Yes, the point that I wanted was to override whatever style I was working on, as in my case I wanted a different look to the cover sheet than for the rest of the reports, but the style in Excel Tagsets is at the tagset level rather than at the sheet level. -Mary --- snoopy369(a)gmail.com wrote: From: Joe Matise <snoopy369(a)gmail.com> To: mlhoward(a)avalon.net Cc: SAS-L(a)listserv.uga.edu Subject: Re: Suppress Borders in ODS Tagsets ExceXP? Date: Wed, 3 Mar 2010 10:48:24 -0600 Doesn't that override whatever style you're currently using, though? Or did they fix that? Also never had luck with bordercolor=white actually removing borders [as opposed to creating a white border, which is not the same]... -Joe On Wed, Mar 3, 2010 at 10:27 AM, Mary <mlhoward(a)avalon.net> wrote: > David, > > No, you don't have to create a style. I put this in as a SAS ticket and it > was figured out just a few weeks ago. In Proc Report, you can do this: > > proc report data=coversheet nowindows > style(report)={background=white foreground} > style(header column)={borderrightcolor=white borderleftcolor=white > borderleftwidth=1 bordertopcolor=white borderbottomcolor=white > borderrightwidth=1 bordertopwidth=1 borderbottomwidth=1}; > > > The advantage of this with Excel Tagsets is that you can override the > borders on some sheets and not on others (I was attempting to create a cover > sheet without borders when the rest of the sheets had tables in them that I > wanted borders on). > > -Mary > > > --- snoopy369(a)GMAIL.COM wrote: > > From: Joe Matise <snoopy369(a)GMAIL.COM> > To: SAS-L(a)LISTSERV.UGA.EDU > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > Date: Wed, 3 Mar 2010 10:17:19 -0600 > > Something like this: > > proc template; > > define style <name>; > parent=<parent name>; > replace <style element> from <style category> / > borderleftwidth=undef > bordertopwidth=undef > borderbottomwidth=undef > borderrightwidth=undef > ; > end; > > quit; > > Give or take. Not an expert in this myself but it seems to work. Only > problem I have is that excelxp tagset doesn't always play well with newly > created styles... some bugs in it still I think. > > -Joe > On Wed, Mar 3, 2010 at 10:10 AM, Vandenbroucke, David A < > David.A.Vandenbroucke(a)hud.gov> wrote: > > > Thank you. Now I have to learn how to define a style. > > > > --Dav > > david.a.vandenbroucke(a)hud.gov > > > > > > > > From: Joe Matise [mailto:snoopy369(a)gmail.com] > > Sent: Wednesday, March 03, 2010 11:06 AM > > To: Vandenbroucke, David A > > Cc: SAS-L(a)listserv.uga.edu > > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > > > > From my experience, typically you have to do it by defining your own > style > > in PROC TEMPLATE and using borderwidth=UNDEF. I don't think you can > > override specific elements of a style at PROC REPORT time (although I > > thought I saw something about this being possible in 9.2, I haven't seen > > evidence of that working myself). > > > > That said, you can always produce your own style based off of JOURNAL2 > > fairly trivially, just use it as the Parent style. > > > > -Joe > > > > >
From: Joe Matise on 3 Mar 2010 13:33 At least in PROC REPORT and excelxp, you can assign named styles at any level - just like you did with element styles. You could just as easily have put style=stylename there. I do that in a lot of my work. It doesn't always work perfectly, but neither does tagset level styles ... In any event, from my understanding the OP wanted to use a currently existing style just adjust it to have no borders, no? -Joe On Wed, Mar 3, 2010 at 12:31 PM, Mary <mlhoward(a)avalon.net> wrote: > Yes, the point that I wanted was to override whatever style I was working > on, as in my case I wanted a different look to the cover sheet than for the > rest of the reports, but the style in Excel Tagsets is at the tagset level > rather than at the sheet level. > > -Mary > > --- snoopy369(a)gmail.com wrote: > > From: Joe Matise <snoopy369(a)gmail.com> > To: mlhoward(a)avalon.net > Cc: SAS-L(a)listserv.uga.edu > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > Date: Wed, 3 Mar 2010 10:48:24 -0600 > > Doesn't that override whatever style you're currently using, though? Or > did > they fix that? > > Also never had luck with bordercolor=white actually removing borders [as > opposed to creating a white border, which is not the same]... > > -Joe > > On Wed, Mar 3, 2010 at 10:27 AM, Mary <mlhoward(a)avalon.net> wrote: > > > David, > > > > No, you don't have to create a style. I put this in as a SAS ticket and > it > > was figured out just a few weeks ago. In Proc Report, you can do this: > > > > proc report data=coversheet nowindows > > style(report)={background=white foreground} > > style(header column)={borderrightcolor=white borderleftcolor=white > > borderleftwidth=1 bordertopcolor=white borderbottomcolor=white > > borderrightwidth=1 bordertopwidth=1 borderbottomwidth=1}; > > > > > > The advantage of this with Excel Tagsets is that you can override the > > borders on some sheets and not on others (I was attempting to create a > cover > > sheet without borders when the rest of the sheets had tables in them that > I > > wanted borders on). > > > > -Mary > > > > > > --- snoopy369(a)GMAIL.COM wrote: > > > > From: Joe Matise <snoopy369(a)GMAIL.COM> > > To: SAS-L(a)LISTSERV.UGA.EDU > > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > > Date: Wed, 3 Mar 2010 10:17:19 -0600 > > > > Something like this: > > > > proc template; > > > > define style <name>; > > parent=<parent name>; > > replace <style element> from <style category> / > > borderleftwidth=undef > > bordertopwidth=undef > > borderbottomwidth=undef > > borderrightwidth=undef > > ; > > end; > > > > quit; > > > > Give or take. Not an expert in this myself but it seems to work. Only > > problem I have is that excelxp tagset doesn't always play well with newly > > created styles... some bugs in it still I think. > > > > -Joe > > On Wed, Mar 3, 2010 at 10:10 AM, Vandenbroucke, David A < > > David.A.Vandenbroucke(a)hud.gov> wrote: > > > > > Thank you. Now I have to learn how to define a style. > > > > > > --Dav > > > david.a.vandenbroucke(a)hud.gov > > > > > > > > > > > > From: Joe Matise [mailto:snoopy369(a)gmail.com] > > > Sent: Wednesday, March 03, 2010 11:06 AM > > > To: Vandenbroucke, David A > > > Cc: SAS-L(a)listserv.uga.edu > > > Subject: Re: Suppress Borders in ODS Tagsets ExceXP? > > > > > > From my experience, typically you have to do it by defining your own > > style > > > in PROC TEMPLATE and using borderwidth=UNDEF. I don't think you can > > > override specific elements of a style at PROC REPORT time (although I > > > thought I saw something about this being possible in 9.2, I haven't > seen > > > evidence of that working myself). > > > > > > That said, you can always produce your own style based off of JOURNAL2 > > > fairly trivially, just use it as the Parent style. > > > > > > -Joe > > > > > > > > > > >
From: "Vandenbroucke, David A" on 3 Mar 2010 15:04 From: Joe Matise <snoopy369(a)GMAIL.COM> Subject: Re: Suppress Borders in ODS Tagsets ExceXP? >>In any event, from my understanding the OP wanted to use a currently existing style just adjust it to have no borders, no?<< That's what I asked about, yes. However, to tell the truth, what I'd really like is a style that didn't do any kind of formatting. All the ones I've seen go hog-wild with bold, italics, underline, shading, borders, etc., etc. I can understand how all that would be useful for someone who does regular reports and want sto go from SAS straight to the finished product. However, I work in a research shop, and normally all we want is to get specific custom tabulations into Excel. I usually spend a lot of time unformatting ODS output. Dav Vandenbroucke Senior Economist U.S. Dept. HUD david.a.vandenbroucke(a)hud.gov 202-402-5890 I disclaim any disclaimers.
From: "Vandenbroucke, David A" on 3 Mar 2010 15:15
From: Joe Matise [mailto:snoopy369(a)gmail.com] Sent: Wednesday, March 03, 2010 3:08 PM To: Vandenbroucke, David A Cc: SAS-L(a)listserv.uga.edu Subject: Re: Suppress Borders in ODS Tagsets ExceXP? >>You can try style=minimal, though from what i've seen that can cause some interesting bugs in the output.<< Thanks. That's an improvement, although one thing it still leave in are the borders! --Dav david.a.vandenbroucke(a)hud.gov |