BookmarkSubscribeRSS Feed
deleted_user
Not applicable
How do I remove some cell gridlines in an rtf output? I want to remove for the sake of argument, the right cell line from the third cell on some lines and have it appear on others. I do want gridlines around the headers and the entire table.
3 REPLIES 3
wayne_sas
SAS Employee
There is a distinction between gridlines and cell borders.

In Word, uneder the Table tab, there is a swithc for Show/Hide Gridlines. When it is on, it places a gridline around the table (titles and footnotes are tables, also).

There is no control for some gridlines and not others.

Borders on cells are a different story. They are applied on a cell by cell basis. Until 9.2, borders were only controlled on a table basis. Even then, you would have t be able to identify a specifc cell in some way to change border values. Some procs give better access with formats applied to values and column identification than others do.
Cynthia_sas
SAS Super FREQ
Hi:
This will be easier to do in 9.2 than in 9.1 -- in 9.2, there are bordertop...borderbottom...style attributes that you can change, as described starting here under border control:
http://support.sas.com/rnd/base/new92/92rtf.html#border Since these attributes work in a style template, they should also work in the STYLE=override capability of PROC PRINT, REPORT and TABULATE.

Your only choices for SAS 9.1 are:
1) turn off all table lines with SAS and then use RTF control strings (the \brdrt, \brdrb strings, etc) to change the borders of the cells (you would either pass these strings in as RAW text using ODS ESCAPECHAR or you would send them to the document with PRETEXT and POSTTEXT style attributes)
2) turn off all table lines with SAS and then use Word Macros or VB to change the table after its been opened in Word
3) use some other (non-ODS) method to generate your RTF control strings (such as some of the older programs that used DATA step code to write RTF)

cynthia

some relevant links:
http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0310B&L=sas-l&P=26278
http://www.lexjansen.com/pharmasug/2006/applicationsdevelopment/ad13.pdf
http://www.lexjansen.com/phuse/2005/ts/ts06.pdf
http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf
Duong
Obsidian | Level 7
Hi All

There are another 2 choices to Cynthia’s list I could think off.

1) Use ODS OO features (See SUGI28 paper 22-28 by Daniel O’Connor). This is
only experimental in v9.1 though.

2) By post-processing your RTF file. What you need to do is to tag the cells as
2j4tdas2yl (sorry don’t know your name) mentioned then post-process
accordingly.

I agree with 2j4tdas2yl - that is I don’t think the new features (bordertop … ect ) in
9.2 will help in this case because I believe its apply to per column and I think John
is asking per cell level.

Here are some exmples of what you can do:

www.tranz.co.uk

click on the downlod button.


Duong

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 2903 views
  • 1 like
  • 4 in conversation