getting border styles for particular cells

deleted_user — Wed, 22 Oct 2008 12:49:19 GMT

I have written the following SAS code.
ods escapechar="^";
ods rtf file="&path3.\sae_caureln.rtf" style=journal;

proc report data=ae_fin nowd split='*'
style(report)= {font_face='Arial narrow'
font_size=4pt
cellpadding=10px rules=hsides
} style(header)={font_face='Arial narrow'
font_size=11pt
cellpadding=10px }
style(column)= {font_face='Arial narrow'
font_size=11pt
cellpadding=10px
} missing;

columns soc ptmedra tot_freq ("Frequency by Causal Relationship" "--" definite possible probable remote unrelated);
define ptmedra/group "Preferred Term*Total AEs" width=15 flow;
define tot_freq/group "Total Frequency" width=13 center;
define definite/group width=8 "Definite" center Style(column)={cellwidth=1in};
define probable/group width=8 "Probable" center Style(column)={cellwidth=1in};
define possible/group width=8 "Possible" center style(column)={cellwidth=1in};
define remote/group width=8 "Remote" center style(column)={cellwidth=1in};
define unrelated/group width=9 "Unrelated" center ;
compute after;
line @10 "MedDRA Version9.0";
endcomp;
run;
ods rtf close;

I have following issues with above code.
1. column header "Frequency by Causal Relationship" is not getting underlined.
2. The footer is displaying in the following way
MedDRA Version9.0
----------------------------------------------------
But I want it to be displayed like this
----------------------------------------------------------------------------------------------
MedDra Version 9.0
Please help in resolving these issues

Re: getting border styles for particular cells

RobW — Wed, 22 Oct 2008 13:26:12 GMT

quick response without being able to verify...

can you use inline formatting with the escapechar to define the style for that text???

Re: getting border styles for particular cells

Cynthia_sas — Wed, 22 Oct 2008 16:08:31 GMT

Hi:
HSIDES writes a line at the BOTTOM of the table. Your LINE statement text is INSIDE the table. You would have to use RTF control strings to get lines where you want them, either using the \ul (for a single word) or the \brdrs\brdrt control strings.
There are several examples of using RTF control strings in various PharmaSUG papers and if you search the Forum, using the search string:
brdrs
you should come up with 10 or 12 previous postings for similar questions.

cynthia

topic getting border styles for particular cells in ODS and Base Reporting

getting border styles for particular cells

Re: getting border styles for particular cells

Re: getting border styles for particular cells