Help using Base SAS procedures

Specify horizontal lines within Proc Tabulate using Proc Template?

Reply
N/A
Posts: 0

Specify horizontal lines within Proc Tabulate using Proc Template?

Hello~ I have created a template that produces a border on the top and bottom of my table. What I would like to do is insert a horizontal line between the frequencies and means, to visually separate the two. Is this possible? Thanks in advance, here is my code so far:

proc template;
define style styles.custom;
parent=styles.rtf;
style table/
foreground=black
background=white
cellspacing=0
cellpadding=3
frame=hsides
rules=groups
borderwidth=4
borderstyle=double;
style header/
font_face="Courier"
font_size=8pt
font_weight=medium
font_style=roman
foreground=black
background=white;
style rowheader/
font_face="Courier"
font_size=8pt
font_weight=medium
font_style=roman
foreground=black
background=white;
style data/
font_face="Courier"
font_size=8pt
font_weight=medium
font_style=roman
foreground=black
background=white;
end;
run;

ods rtf file="C:\Output\Table1.rtf" newfile=none;
ods rtf style=custom;
options nodate nonumber;
proc tabulate data=ready(where=(wave ge 230)) format=9.1 noseps
formchar(1,8,2,3,4,5,6,7,9,10,11)='||----|+|---';
title ' ';
format wave wave. q1 sat. total total. mq1vn validn.;
class wave q1 total mq1vn;
var mq1 ;
table ((q1=' ' total=' ')*(N*f=4.0 f=p8r6.0* pctn)) (mq1='Mean'*mean*f=7.3)
(mq1vn=''),wave/rts = 34 box="Table 1. OVERALL SATISFACTION" misstext=' ';
keylabel pctn = "(%)";
run;
ods rtf close;
Ask a Question
Discussion stats
  • 0 replies
  • 89 views
  • 0 likes
  • 1 in conversation