topic Re: Proc Report linesize in ODS and Base Reporting

Proc Report linesize

sling — Fri, 15 Jan 2016 15:49:57 GMT

Hi ,

I already used LS=200 and also used 'flow' in the proc report, but sitll got the error 'at least one column width is wider than line size'.

Any suggestions how I can fix the issue?

Re: Proc Report linesize

Reeza — Fri, 15 Jan 2016 15:54:25 GMT

What ODS destination are you using?

If you're not using, you can turn off that destination as it usually causes the warning.

Re: Proc Report linesize

sling — Fri, 15 Jan 2016 16:11:22 GMT

Thanks for your reply Reeza!

I used a physical folder as ODS destination. I need output an RTF file.

Re: Proc Report linesize

ballardw — Fri, 15 Jan 2016 16:49:05 GMT

ODS RTF doen't really use line size. You may want to set either orientation or papersize.

Also choice of ODS style and the font size used by that style determines printable line lengths and column breaks in tables.

Pick a style with smaller fonts, or you can override style just for the proc report output.

Re: Proc Report linesize

Reeza — Fri, 15 Jan 2016 18:37:18 GMT

If you haven't turned of ODS LISTING then the warning pertains to that destination, not your RTF file.

Close the ODS LISTING destination.

ods listing close;

*rest of code;

ods listing; *open again;

Re: Proc Report linesize

sling — Fri, 15 Jan 2016 19:21:33 GMT

I did not use ODS Listing.

here is my code. Is there anything wrong?

Options NoDate NoNumber Orientation = Portrait ;
ODS RTF File = "&output.\&pgmn._&rtfn..rtf" ;
ODS escapechar = "^" ;

Proc Report Data = all&cutoff Spacing = 2 Split = "*" HeadLine HeadSkip Wrap NoWd
style(report) = [ outputwidth=100%]
style(header)={background=none};

Column PTNAME2 ("All Available Follow-Up" evtnum ptnum col1 dev_rel proc_rel) ;

Define PTNAME2 / STYLE = {CELLWIDTH = 1.0in JUST = LEFT} " Event" flow ;
Define evtnum / STYLE = {CELLWIDTH = 0.3in JUST = CENTER} "Number of events" flow ;
Define ptnum / STYLE = {CELLWIDTH = 0.3in JUST = CENTER} "Number of subjects" flow ;
Define col1 / STYLE = {CELLWIDTH = 0.5in JUST = CENTER} "Percent of subjects" flow ;
Define dev_rel / STYLE = {CELLWIDTH = 0.6in JUST = CENTER} "Device related" flow ;
Define proc_rel / STYLE = {CELLWIDTH = 0.6in JUST = CENTER} "Procedure related" flow ;

Run;

ODS RTF Close;

Re: Proc Report linesize

Reeza — Fri, 15 Jan 2016 20:17:53 GMT

It can be the default setting. Give it a try and if it doesn't work post the log.

Re: Proc Report linesize

ballardw — Fri, 15 Jan 2016 21:02:24 GMT

The line that reads
ODS RTF File = "&output.\&pgmn._&rtfn..rtf" ;
includes your ODS destination: RTF.

Re: Proc Report linesize

DrAbhijeetSafai — Wed, 29 Jan 2025 09:01:28 GMT

Many thank @Reeza !

- Dr. Abhijeet Safai

Re: Proc Report linesize

DrAbhijeetSafai — Wed, 29 Jan 2025 09:02:17 GMT

Many many thanks @Reeza !

-- Dr. Abhijeet Safai