topic Cell Width in SAS Programming

Cell Width

sasuser_sk — Mon, 22 Mar 2021 22:22:47 GMT

PROC TABULATE DATA=RESULT ;
VAR SRVC_ID;
CLASS " Deal"n / ORDER=UNFORMATTED MISSING style=[ font_weight=medium];
CLASS Week/ ORDER=UNFORMATTED MISSING style=[ font_weight=medium cellwidth=175];
TABLE /* Row Dimension */
Week= ' ' all='Total',
/* Column Dimension */
'Deal'n = ' ' *(SRVC_ID=' '*N=' ') All= ' '* n = 'Total' ; RUN;

I want the cellwidth of Week as 175 but when I do Week= ' ' (in above code) then cellwidth=175 does not work. However cellwidth works when I put Week all = 'Total'.

Can someone help me adjust width of field Week? Thanks!

Re: Cell Width

ChrisNZ — Mon, 22 Mar 2021 23:17:17 GMT

Try adding a

classlev WEEK / style=[ font_weight=medium cellwidth=175 ];

statement.

Re: Cell Width

Cynthia_sas — Mon, 22 Mar 2021 23:41:43 GMT

Hi
175 what? 175 pixels? Probably not 175 CM or INCHES. Probably not 175 printer's points. I do not observe the same behavior that you describe. To impact the "row title area" (where you have WEEK and I have PRODUCT), all you need to do is either use a CLASSLEV statement or use a style override for the BOX area. My example below uses the BOX approach for the row title area with PRODUCT and the CLASSLEV approach for REGION.

I also made some font changes so you could see other ways to impact width (such as I show in the column dimension for Region).

Cynthia

Re: Cell Width

sasuser_sk — Tue, 23 Mar 2021 15:21:49 GMT

Thank you @ChrisNZ and @Cynthia_sas.

ChrisNZ, it works just fine.

Cynthia, you example improved the looks of my results.