topic Re: Merging Cells Vertically in PROC REPORT PDF in ODS and Base Reporting

Merging Cells Vertically in PROC REPORT PDF

JRUCF — Mon, 18 Jun 2012 16:44:13 GMT

I have a rather unique question regarding PROC REPORT and ODS PDF. I have currently assembled a schedule-like table using PROC REPORT and in order to make this table fit on one page, I have to reduce the font size down to 3pt. While everything at this point looks alright, it also forces the text in my groups to be at 3pt as well. Since the text in the group column needs to be readable, I want to be able to increase the font size. Just adding a style line to increase the font stretches the row which distorts the scale of the schedule, so merging the cell with the text with the cell below (the report is using SPANROWS and there is plenty of space between the groups) so I can utilize that blank space without stretching out the table.

ASCII Visual

Current:

Hour | Monday | ...

---------|-------------|

7:00 | x |

---------|-------------|

| x |

---------|-------------|

Result:

Hour | Monday | ...

---------|-------------|

7:00 | x |

|-------------|

| x |

---------|-------------|

(Assume the "7:00" can stretch further into the space between the two cells)

If anyone can figure this out, or point me to a reasonable alternative (I am using ODS REGION to put this next to another table) I would greatly appreciate it.

Re: Merging Cells Vertically in PROC REPORT PDF

Reeza — Mon, 18 Jun 2012 17:09:37 GMT

Try looking at the spanrows options in proc report:

http://support.sas.com/resources/papers/proceedings11/246-2011.pdf

ods pdf file='c:\spanrows.pdf';

proc report nowd data= spanrows_example spanrows;

col sex age name height weight;

define sex / order;

run;

ods pdf close;

Re: Merging Cells Vertically in PROC REPORT PDF

JRUCF — Mon, 18 Jun 2012 18:55:13 GMT

I'm already using spanrows and used the PDF you linked to heavily for the rest of the report. While spanrows gives me the appropriate look, all it does is hide the extra borderlines and instances of duplicate group values. The cell issue as I described in my original diagram still persists even though the visuals imply otherwise.

Re: Merging Cells Vertically in PROC REPORT PDF

Cynthia_sas — Mon, 18 Jun 2012 21:30:39 GMT

Hi:

Spanrows and PDF has a known issue where the first row of a group gets extra space added to it, as described in this Tech Support note:

http://support.sas.com/kb/45/549.html

It's hard for me to envision what you mean by "distorts the scale", since your drawing seems to me to show what you want, not what you're getting. And, since you didn't post your code, it's hard to tell whether the fix described in the Tech Support note is something you already tried.

If trying both cellwidth and cellheight do not work for you, as described in the Tech Support note (they have code that illustrates both the problem and the fix), then I'd recommend opening a track with Tech Support. They can look at all your code and help you figure out whether you have discovered a new problem or figure out if there's a workaround.

cynthia

Re: Merging Cells Vertically in PROC REPORT PDF

JRUCF — Tue, 19 Jun 2012 16:23:24 GMT

In theory that support should work, but I'm not sure if a larger font falls into the same guidelines of long text.

The following image shows the distortion. The horizontal gridlines are present to make it easier to see. The line with the '10' is in 6pt font which stretches the first row of the hour while the remaining rows stay in 3pt font. If I bring the '10' back to 3pt it will all look proper.

As for the code, I am only including a part of the code as the rest is just toying with borders and quite lengthy:

-------------------------

proc report data=work.bartrans spanrows contents="&facil" nowd

style(report)=[/*rules=none frame=void*/ cellspacing=0 cellpadding=0 fontsize=3pt]

style(column)=[textalign=c];

column building hour obs _emptym monday _emptyt tuesday _emptyw wednesday _emptyr thursday _emptyf friday _emptys;

define hour/ order style(column) = {borderleftcolor=black borderleftwidth=3

bordertopwidth=0 borderbottomwidth=0 fontsize=6pt};

compute hour;

call define(_COL_, 'style', 'style=[bordertopwidth=0 borderbottomwidth=0 borderleftwidth=1 borderrightwidth=1]');

endcomp;

define building / noprint order;

define obs / noprint order;

define monday / 'Mon' style(column) = {background=$ticklight. foreground=$ticklight.