topic Re: different in proc report between width statement and cellwidth statement in SAS Programming

different in proc report between width statement and cellwidth statement

Ronein — Wed, 05 Sep 2018 08:39:00 GMT

Hello

What is the different in proc report between width statement and cellwidth statement?

Are both adjust column width?

Re: different in proc report between width statement and cellwidth statement

Jagadishkatam — Wed, 05 Sep 2018 08:43:47 GMT

There is a response from @Cynthia_sas on the same. Please refer to the page below

https://communities.sas.com/t5/ODS-and-Base-Reporting/Defining-Column-widths-with-Proc-Report-and-ODS/td-p/28280

Re: different in proc report between width statement and cellwidth statement

Ksharp — Wed, 05 Sep 2018 13:01:57 GMT

'width' is obsolete, it is just suited for LISTING destination . use 'cellwidth' just fine.

Re: different in proc report between width statement and cellwidth statement

Cynthia_sas — Wed, 05 Sep 2018 13:09:54 GMT

Hi: To clarify the use of WIDTH -- There are actually 2 ways to specify WIDTH in PROC REPORT. LISTING destination uses the WIDTH option, not in any special syntax:
define varname / display 'label' width=6;

or you can use a style override for other ODS destinations in which WIDTH and CELLWIDTH are aliases:
define varname / display 'label'
style(column)={width=1.5in color=red};
or
define varname /display 'label'
style(column)={cellwidth=1.5in color=red};

In the simple LISTING example, WIDTH is the number of characters wide the column needs to be when displayed in a fixed pitch font. In the STYLE override examples, WIDTH= or CELLWIDTH= can be used interchangeably and you specify a number, followed by a unit of measure, pixels, inches, cm or percent.

Cynthia