topic Re: PROC TABULATE, font weight and page element in ODS and Base Reporting

ExcelXP, PROC TABULATE, font weight and page element

PhilC — Thu, 11 Jan 2018 13:35:27 GMT

So this is a ExcelXP issue, not a PROC TABULATE issue, as I see it. Can someone show me how to format the fontweight for the page-wise table title, using tagsets.ExcelXP, in the example represented by the variable ORIGIN.

ods tagsets.excelXP
  file="ex1.xls"
  style=SASdocPrinter;
PROC TABULATE DATA=SASHELP.CARS;
  
  CLASS Make /  ORDER=UNFORMATTED MISSING;
  CLASS Type /  ORDER=UNFORMATTED MISSING;
  CLASS Origin /  ORDER=UNFORMATTED MISSING style=[fontweight=bold ];
  TABLE /* Page Dimension */
    Origin,
    /* Row Dimension */
    Make,
    /* Column Dimension */
    Type*
      N     ;
RUN;
ods tagsets.excelXP close;

Re: PROC TABULATE, font weight and page element

ballardw — Thu, 11 Jan 2018 00:50:17 GMT

The style information goes on the CLASS statement.

PROC TABULATE DATA=SASHELP.CARS;
  
  CLASS Make /  ORDER=UNFORMATTED MISSING;
  CLASS Type /  ORDER=UNFORMATTED MISSING;
  CLASS Origin /  ORDER=UNFORMATTED MISSING style=[fontweight=light fontsize=25pt];
  TABLE /* Page Dimension */
    Origin,
    /* Row Dimension */
    Make,
    /* Column Dimension */
    Type*
      N     ;
RUN;

BIG size just to show it is taking effect. With that large it looks kind of "bold" but isn't.

Re: PROC TABULATE, font weight and page element

Cynthia_sas — Thu, 11 Jan 2018 13:05:40 GMT

Hi:
I only find BOLD and NORMAL the values that work best for fontweight. I would not expect LIGHT to have much of an impact -- if you want the value to appear lighter, I suggest gray something like color=CXDDDDDD or color=CX999999.
cynthia

Re: PROC TABULATE, font weight and page element

PhilC — Thu, 11 Jan 2018 13:36:33 GMT

ok. So what I thought was a PROC TABULATE issue is an ExcelXP issue.

Re: PROC TABULATE, font weight and page element

Cynthia_sas — Thu, 11 Jan 2018 19:23:26 GMT

Hi:

Can you try ODS EXCEL instead of TAGSETS.EXCELXP? This is what I got using ODS EXCEL:

cynthia

Re: PROC TABULATE, font weight and page element

PhilC — Thu, 11 Jan 2018 21:13:23 GMT

yes. We've yet to install SAS4M5 here, and I'm hoping the "FLOW" option works then for me, first, until then I'm going to use ExcelXP. ExcelXP has been so great, and its surprising when any of these great SAS products don't do that one thing. thanks

Re: PROC TABULATE, font weight and page element

Cynthia_sas — Thu, 11 Jan 2018 21:44:16 GMT

ODS Excel is production and has been for a while. I am still running 9.4 M3 and that's what I used for this screen shot.
Cynthia

Re: PROC TABULATE, font weight and page element

PhilC — Wed, 17 Jan 2018 15:31:34 GMT

ODS Excel adds those **bleep** line feeds (oops) in to your strings. My pet peeve, SAS isn't supposed to change your data, just dress it up. It's my own hang up.