maxo
maxo

Reputation: 7

how to get rtf file using proc report

I need to get output in the attached form. My code is as shown below. I used headskip but its not reflecting in my rtf file

ods rtf FILE="E:\GRAPHS/demog2.rtf" ;
         OPTIONS LS=100 PS=100 NODATE CENTER NONUMBER MISSING='' FORMDLIM='*' ;
         proc report data=finalt  headskip headline center spacing=5 split=" "  nowd
         style(header)={background=white foreground=black}
        STYLE(REPORT)=[BACKGROUND=WHITE /*BORDERCOLOR=BLACK*/  ASIS=ON  CELLPADDING=1.5
                         CELLSPACING=1.0 OUTPUTWIDTH=50%  ] /*style=[frame=hsides BORDERWIDTH = 0.1pt]*/style=journal ;

pic

Upvotes: 0

Views: 662

Answers (1)

whymath
whymath

Reputation: 1394

I think you are asking the way to produce "three line" table in SAS. Here are many examples you can find on the internet. The following is a very simple way:

option nonumber nodate;
title;
footnote;

proc template;
  define style sasuser.custom;
  parent=rtf;
  replace table from output/frame=hsides;
  replace color_list/'bgh'=white;
  end;
run;

ods rtf file="d:\test.rtf" style=custom;
proc report data=sashelp.class;
run;
ods rtf close;

Upvotes: 1

Related Questions