topic Re: Using multiple values in the borderstyle style attribute in ODS and Base Reporting

Using multiple values in the borderstyle style attribute

xxformat_com — Mon, 20 Dec 2021 12:38:53 GMT

Hi,

The SAS online documentation gave me the impression that it would be possible to use multiple values in the borderstyle attribute

https://documentation.sas.com/doc/en/pgmsascdc/v_017/odsug/p1pt77toue3iyun0z4l9gth5as9f.htm#p0kyb7yjtv6caen1euiv1zt5tvy1

However, the following code doesn't work:

ods excel file="&xxtest./reporting/test.xlsx"
          options(start_at='2,2');

proc print data=sashelp.class noobs
           style(header)=[borderstyle=none double solid none] 
           style(column)=[bordertopstyle   =none
                          borderrightstyle =double
                          borderbottomstyle=solid
                          borderleftstyle  =none];
run;

ods excel close;

Any idea about the right syntax?

Re: Using multiple values in the borderstyle style attribute

Ksharp — Mon, 20 Dec 2021 14:14:49 GMT

You want this ?

ods excel file="c:\temp\test.xlsx"
          options(start_at='2,2');

proc print data=sashelp.class noobs
           style(header)=[borderstyle=none ] 
           style(column)=[bordertopstyle   =none
                          borderrightstyle =double borderrightwidth =2
                          borderbottomstyle=solid  borderbottomwidth=2
                          borderleftstyle  =none];
run;

ods excel close;

Re: Using multiple values in the borderstyle style attribute

xxformat_com — Tue, 21 Dec 2021 14:54:33 GMT

Hi,

Here the question is: how to get more than one value for borderstyle as it seems possible according to the SAS online doc.

Re: Using multiple values in the borderstyle style attribute

Ksharp — Wed, 22 Dec 2021 12:10:10 GMT

I don't know . Maybe @Cynthia_sas knows .

Re: Using multiple values in the borderstyle style attribute

xxformat_com — Wed, 22 Dec 2021 15:47:14 GMT

@Ksharp

In the SAS online documentation they don't use border-style but borderstyle without hyphen.

But beside that I've managed to find a possible explaination: border-style followed by multiple values is possible in CSS.

ods excel file="&xxtext/test.xlsx"
          options(start_at='2,2') 
          cssstyle="&xxtext./test.css";*;

proc print data=sashelp.class noobs;
run;

ods excel close;

test.css

.header, .rowheader {background-color:yellow;border-style=none double solid none;}
.data {background-color:pink;border-style=none double solid none;}

Re: Using multiple values in the borderstyle style attribute

Cynthia_sas — Wed, 22 Dec 2021 16:22:38 GMT

Hi:
In my experience, borderstyle options are honored best in PDF and RTF destinations. Sometimes, HTML output will respect multiple borderstyles. I generally control using the left/right/top/bottom version of the style override instead of pumping them into one borderstyle attribute override. However, ODS EXCEL is difficult. Also, remember that bottom border for one cell "bumps into" or is adjacent to the top border for the cell underneath it. Same thing with left/right. The right side border for one cell is adjacent to the left border of the cell next to it. For example, 2 completely different "looks" for the same code:

So frequently, you do not get the look you want in any destination. Whether you can do what you want with multiple attributes in one override may turn out to need more investigation in the doc or with Tech Support.
Cynthia

Re: Using multiple values in the borderstyle style attribute

xxformat_com — Thu, 23 Dec 2021 19:08:19 GMT

It's really strange. The issue seems to come from the Excel destination only.
If you use a different borderstyle for the bottom and the top, then the colors are the same as in the HTML destination.

*ISSUE;
ods excel file="&xxtraining./reporting/ods_excel_test1.xlsx"
options(start_at='2,2' sheet_interval='none');

proc print data=sashelp.class noobs
style(column)=[bordertopstyle=solid bordertopcolor=blue
borderbottomstyle=solid borderbottomcolor=red];
run;

ods excel close;

*OK;
ods excel file="&xxtraining./reporting/ods_excel_test2.xlsx"
options(start_at='2,2' sheet_interval='none');

proc print data=sashelp.class noobs
style(column)=[bordertopstyle=solid bordertopcolor=blue
borderbottomstyle=double borderbottomcolor=red];
run;

ods excel close;

Re: Using multiple values in the borderstyle style attribute

Cynthia_sas — Thu, 23 Dec 2021 22:08:08 GMT

Hi:
I generally find that the Excel destination can be a little wonky with borders and styles, so I tend to avoid them because it takes too much fiddling and I'm never completely happy with what I get. So I've learned to change my expectations as far as ODS EXCEL output and the rendering that Microsoft does with the xlsx file created by ODS.
Cynthia