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?
What ODS destination are you using?
If you're not using, you can turn off that destination as it usually causes the warning.
Thanks for your reply Reeza!
I used a physical folder as ODS destination. I need output an RTF file.
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.
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;
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;
It can be the default setting. Give it a try and if it doesn't work post the log.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.