BookmarkSubscribeRSS Feed
djbateman
Lapis Lazuli | Level 10

I am trying to find a simple way to merge cells in an rtf file using SAS code.  An example of what I want to do is found in the following paper.  See page 5, example 2.

http://www.lexjansen.com/phuse/2007/po/po07.pdf

I know it can be done because I have combined cells in table headers in PROC REPORT, but I cannot figure out how merge the cells in the body of the table.

3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  If you look immediately underneath the example you cited, the paper author provides the program name that he used to create the output. Perhaps if you contacted the paper author, you could obtain his macro program that performed the cell merge using RTF control strings.

  I have done a similar report using just PROC REPORT, by making a character variable, for example, with the N and PCTN concatenated into 1 string: NNN (yy.y%) and then using the character string with PROC REPORT instead of the 2 separate variables.

  My paper "Creating Complex Reports" has 3 examples of creating such a demographic report and can be downloaded from here:

http://www2.sas.com/proceedings/forum2008/173-2008.pdf

The example programs that accompany can be downloaded from the site:

http://support.sas.com/rnd/papers

and you can find the download by searching for the paper title.

cynthia

sravanpathu
Calcite | Level 5

Dear All,

i want to merge cells like follow and colors too

can any one help

Cynthia_sas
SAS Super FREQ

Your question has been answered in your other posting.

cynthia

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
  • 4664 views
  • 0 likes
  • 3 in conversation