topic Re: character num. of proc report column in SAS Programming

character num. of proc report column

Bill3 — Mon, 04 Nov 2024 10:10:37 GMT

I want to achieve this effect in the image in RTF (the column width is set to 4 characters, and the line will wrap when it is reached). Please check whether my width is set incorrectly.

ods rtf file="xxx\test.rtf" style=rtf;

proc report data = sashelp.cars;
        column make model;
        define make / width=4;
        define model / width=4;
run;
ods rtf close;

Re: character num. of proc report column

Kurt_Bremser — Mon, 04 Nov 2024 11:00:28 GMT

From the documentation of the WIDTH= option of the DEFINE statement:

Restriction This option has no effect on ODS destinations other than LISTING output. For ODS destinations, use the STYLE= option with the WIDTH= style attribute or the CELLWIDTH= style attribute. Refer to Style Attributes Tables in SAS Output Delivery System: Advanced Topics for details. See how style attributes WIDTH= and CELLWIDTH= can be used with PROC REPORT in Using the CELLWIDTH= Style Attribute with PROC REPORT

Restriction	This option has no effect on ODS destinations other than LISTING output. For ODS destinations, use the STYLE= option with the WIDTH= style attribute or the CELLWIDTH= style attribute. Refer to Style Attributes Tables in SAS Output Delivery System: Advanced Topics for details. See how style attributes WIDTH= and CELLWIDTH= can be used with PROC REPORT in Using the CELLWIDTH= Style Attribute with PROC REPORT

Re: character num. of proc report column

ballardw — Mon, 04 Nov 2024 18:15:33 GMT

First, it may be time to describe what the real problem that this solution addresses as it sounds very awkward at best and possibly very ugly in reality.

Since your PICTURE shows 1) Text for Make that is a much larger font than for Model and 2) "wraps" text for Make without affecting the line alignment for Model the first thing would likely be that MAKE be defined as a GROUP variable and use the Proc option SPANROWS:

proc report data = sashelp.cars spanrows;
        column make model;
        define make / group  width=4;
        define model / width=4;
run;

If I really wanted that appearance I would never rely on a "width" setting, either number of characters or cellwidth measured widths because changes of style, fonts and such make it very hard to be consistent. I would instead be tempted to insert breaking space.

Also you need to consider what is the actual length of your longest value? I have to assume that you are using Sashelp.cars as an example for your data set. What if you have a long value, say up to 16 characters that would wrap to 4 lines but there are only two categories of the "Model" equivalent variable. Then you have an odd appearance.

Additionally the display width of the individual letters may become of interest. Almost all output these days uses proportional fonts and something that looks "reasonable" for some combinations of letters may not for other. Consider four wide characters compared with four skinny ones.

WWWW

iiii

note that the four letter i above take up less space than two letter W. So something with skinny characters may look funny displayed in the manner you suggest, wrapped at four characters, or the sequence of W might really want to be wrapped at three to maintain your appearance.