The SAS Output Delivery System and reporting techniques

getting border styles for particular cells

Reply
N/A
Posts: 0

getting border styles for particular cells

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
Contributor
Posts: 22

Re: getting border styles for particular cells

Posted in reply to deleted_user
quick response without being able to verify...

can you use inline formatting with the escapechar to define the style for that text???
SAS Super FREQ
Posts: 8,868

Re: getting border styles for particular cells

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 3 in conversation