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;
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.
ok. So what I thought was a PROC TABULATE issue is an ExcelXP issue.
Hi:
Can you try ODS EXCEL instead of TAGSETS.EXCELXP? This is what I got using ODS EXCEL:
cynthia
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.