Date:         Wed, 18 Jul 2007 06:40:07 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: Help to debug Proc Report Error!

You should not add a format and a width in the define statement to limit
your variable to the right length. PROC REPORT cannot handle very long
lines (note, it's a reporting procedure which has some limits in output).



On Tue, 17 Jul 2007 23:18:40 -0700, medpower@GMAIL.COM wrote:

>Dear friends,
>
>When I used proc report to output with ODS RTF, there will always be
>an error message saying that the coulmn width is not between 1 and
>256, if the variable's length larger than 256, However, the output
>result is not affected with the error! How could I block the error
>message? t
>
>Thanks
>Stanley
>
>
>options topmargin = '0.75in' bottommargin = '0.750in'
>leftmargin = '0.5in' rightmargin = '0.5in'
>orientation = landscape nonumber nodate linesize=256;
>
>                ods escapechar="~";
>                ods noresults;
>                ods rtf file="d:\temp.rtf";
>
>                data GML_H;
>                        length FUNCTION $300. XX 3.;
>                        FUNCTION="test data";
>                run;
>
>                proc report data=GML_H nowd spacing=2 split="^"
>                        style(header)={background=green foreground=white
font_weight=bold
>just=center};
>                        columns FUNCTION XX;
>                        define FUNCTION/"Function" left flow style=
{font_size=9pt
>cellwidth=100mm just=left};
>                quit;
>
>
>                ods rtf close;
>                ods listing;
>                ods results;