BookmarkSubscribeRSS Feed
NickR
Quartz | Level 8
Hi,

I am using proc report with ODS to generate the output in RTF. I am getting the following warning message when generating the output. The output is OK but not sure why I'm getting this warning message. I know this problem is coming when defining label for 'rate' and 'name' variables. When I put a label for these variables, I am not getting any warning message. It's just only when I assign label as empty. Appreicate if some one can help me with this.

WARNING: Use of CELLWIDTH/OUTPUTWIDTH= in a spanning header or footer will rarely yield expected results. For conventional usage, specify outputwidth only for the data column cells.
WARNING: Use of CELLWIDTH/OUTPUTWIDTH= in a spanning header or footer will rarely yield expected results. For conventional usage, specify outputwidth only for the data column cells.


proc report data = final nowd split='|' spacing=1 missing
style = [outputwidth = 9 in]
style(header)=[asis = on just = center protectspecialchars = off]
style(column)=[asis = on protectspecialchars = off];

column mypage index var sort rate name cnt ;

define index / order order=internal noprint;
define var / order order=internal noprint;
define sort / order order=internal noprint;
define mypage / order order=internal noprint;
define rate / display ' ' style=[just=l cellwidth=25];
define name / display ' ' style=[just=l cellwidth=40];
define cnt / display 'Total' style=[just=l cellwidth=15] ;

break after mypage / page;
compute before index; line '' ; endcomp;
compute after _page_; line '' ; endcomp;
run ;

ods rtf close;
ods listing;
1 REPLY 1
NickR
Quartz | Level 8
One of my colleague helped me to fix this. No more warning messages when I changed

Style=[] statements to
style(column)=[] statement.

thank you.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2709 views
  • 1 like
  • 1 in conversation