Beginning in SAS 9.4, the metrics that are used to calculate cellxN values are based on cascading style sheet (CSS) standards. In the ODS RTF destination, these differences might cause columns that rely on tight measurements to be paneled and no longer fit on one page in PROC REPORT output. Also, columns that did not wrap in previous SAS releases might wrap in SAS 9.4.
User-supplied cell width values can be specified in a style such as STYLE=[CELLWIDTH=1in]. However, when opened in Notepad, the final cellx value in the RTF file might be different from the expected value that can be derived from an inches to twips conversion. This is because the final cellx value considers text width, the accumulated border widths, and accumulated padding. An additional 2% font padding is added to the text measurement when an explicit dimension has not been provided. A short example follows for purposes of clarification.
options nocenter orientation=landscape;
ods rtf file="cellwidthEx.txt";
proc report data=sashelp.class(obs=1) nowd style(column)=[cellwidth=8.9in];
run;
ods rtf close;
The different cellx values between SAS versions are shown below:
SAS® 9.3
SAS 9.4