The SAS Output Delivery System and reporting techniques

Proc Report linesize

Reply
New Contributor
Posts: 4

Proc Report linesize

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?

Grand Advisor
Posts: 17,461

Re: Proc Report linesize

What ODS destination are you using?

 

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

New Contributor
Posts: 4

Re: Proc Report linesize

Thanks for your reply Reeza!

 

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

Grand Advisor
Posts: 10,251

Re: Proc Report linesize

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.

 

Grand Advisor
Posts: 17,461

Re: Proc Report linesize

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;

New Contributor
Posts: 4

Re: Proc Report linesize

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;

Grand Advisor
Posts: 17,461

Re: Proc Report linesize

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

Grand Advisor
Posts: 10,251

Re: Proc Report linesize

The line that reads
ODS RTF File = "&output.\&pgmn._&rtfn..rtf" ;
includes your ODS destination: RTF.
Ask a Question
Discussion stats
  • 7 replies
  • 779 views
  • 0 likes
  • 3 in conversation