|
Yu
you are not using your style created by your templare
because you must use the option style= in the ods statement!
many variable but you use only 5 in the report!
the sas options must be putted before the ods destination are open
with orientation=landscape
the width of the columns can be specified into the proc report code
HTH
Andre
Quoting Yu Zhang <zhangyu05@GMAIL.COM>:
> Dear All,
>
> I have a dataset with many variables (25). record will be splited into
> serval lines when I generate report using PROC Report. I tried
> options=landscape, problem can not be solved. So I tried using proc
> template to reset the page margins (the rtf default left and rightmargins
> is 0.25 in). The output is o.k. but the rules except hearder part are
> greyed out. when you print it out, only header part has the rules.
>
> The code i am using is listed at below: Any suggestions ??
>
>
> Thank you in advance!
>
> Yu
>
>
> proc template;
> define style Styles.Yu;
> parent = Styles.RTF;
> replace Body from Document /
> bottommargin = 0.25in
> topmargin = 0.25in
> rightmargin = _undef_
> leftmargin = _undef_;
> end;
> run;
> options rightmargin = 0.1in leftmargin = 0.1in;
>
> ods rtf file='c:/test.rtf';
> proc report data=sashelp.class nowd split='*' style=yu
> style(header)={background=white font_size=8.5pt font_face="TimesRoman"
> font_weight=bold frame=box} ;
> column name sex age height weight;
> run;
> ods rtf close;
>
| 
