Suppress Borders in ODS Tagsets ExceXP?
in [SAS]
|
From: Joe Matise on 3 Mar 2010 11:05 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 On Wed, Mar 3, 2010 at 9:58 AM, Vandenbroucke, David A < David.A.Vandenbroucke(a)hud.gov> wrote: > I would like to output some tables to Excel using ODS TAGSETS EXCELXP. I > prefer not to have borders around all the cells (nb: not the same thing as > gridlines). Does anyone know how to suppress borders when using a defined > style? I'm using JOURNAL2, if it matters. Is there perhaps an option() > keyword for this? > > In general, what is the best way to find all the options available for > EXCELXP? > > Thanks. > > Dav Vandenbroucke > Senior Economist > U.S. Dept. HUD > david.a.vandenbroucke(a)hud.gov > 202-402-5890 > > I disclaim any disclaimers. >
From: Joe Matise on 3 Mar 2010 11:17 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 11:27 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 11:32 Thank you. I am using PROC TABULATE, but I will see if I can try something similar. --Dav david.a.vandenbroucke(a)hud.gov -----Original Message----- From: Mary [mailto:mlhoward(a)avalon.net] Sent: Wednesday, March 03, 2010 11:28 AM To: Vandenbroucke, David A Cc: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: Suppress Borders in ODS Tagsets ExceXP? 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
From: Mary on 3 Mar 2010 11:45
And I'd love to see the code if you get it working in Tabulate- I haven't tried to get that to run yet! Or maybe the list might want to try it from using the code below.... -Mary --- David.A.Vandenbroucke(a)hud.gov wrote: From: "Vandenbroucke, David A" <David.A.Vandenbroucke(a)hud.gov> To: "'mlhoward(a)avalon.net'" <mlhoward(a)avalon.net> CC: "'SAS-L(a)LISTSERV.UGA.EDU'" <SAS-L(a)LISTSERV.UGA.EDU> Subject: RE: Suppress Borders in ODS Tagsets ExceXP? Date: Wed, 3 Mar 2010 11:32:00 -0500 Thank you. I am using PROC TABULATE, but I will see if I can try something similar. --Dav david.a.vandenbroucke(a)hud.gov -----Original Message----- From: Mary [mailto:mlhoward(a)avalon.net] Sent: Wednesday, March 03, 2010 11:28 AM To: Vandenbroucke, David A Cc: SAS-L(a)LISTSERV.UGA.EDU Subject: Re: Suppress Borders in ODS Tagsets ExceXP? 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 |