Using multiple values in the borderstyle style attribute

[xxformat_com]

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#p0kyb7yj...

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?

[Ksharp]

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;

[xxformat_com]

Hi, 

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

[Ksharp]

I don't know . Maybe @Cynthia_sas  knows .

[xxformat_com · Accepted solution]

@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;}

[Cynthia_sas]

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

[xxformat_com]

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;

[Cynthia_sas]

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