topic Re: setting column width in proc report while setting ls value in options in ODS and Base Reporting

setting column width in proc report while setting ls value in options

wikich — Wed, 10 Oct 2018 13:16:11 GMT

I want to use proc report for exporting my table to rtf file.

for example, my table has five columns named _var_ para col1 col2 col3.

Before writing the pro report, I set the value of ls as 75 in options, like this: options ls=75;

Here I want to set the width of each column as 15, and the sum of all columns width is equal to ls(75).

I see the answer of @Cynthia_sas to set column width like this: style(column)={width=1.5in}, but this solution could not deal

with my problem. I want to known how to set the column width in my problem.

Thanks.

Re: setting column width in proc report while setting ls value in options

Ksharp — Wed, 10 Oct 2018 13:52:57 GMT

First of all,

options ls=75; is not suited for your RTF destination. it is only for LISTING destination.

also try

style(column)={cellwidth=1cm}

style(report)={outputwidth=50%}

Re: setting column width in proc report while setting ls value in options

wikich — Wed, 10 Oct 2018 14:10:38 GMT

if proc report data=mydata ls=75, ls in proc report . is it suited for rtf document?

Re: setting column width in proc report while setting ls value in options

ballardw — Wed, 10 Oct 2018 14:19:40 GMT

@wikich wrote:

if proc report data=mydata ls=75, ls in proc report . is it suited for rtf document?

The very old LINESIZE, or LS, setting is a number of print positions and basically for a line printer and later fixed width font. It does not actually specify a "width" as the size of the font in a file could change the "width" for any given number of characters.

Why does Cynthia's solution "to set column width like this: style(column)={width=1.5in}" not ideal.

Describe why in some detail. The units can be specified differently if you do not like to use inches.

Re: setting column width in proc report while setting ls value in options

Cynthia_sas — Thu, 11 Oct 2018 12:59:25 GMT

NO, Linesize or the LS= option is ONLY a LISTING destination option. It is ignored for RTF.
Cynthia