topic Re: ODS Multiple Rows; Color Coded Columns in SAS Programming

ODS Multiple Rows; Color Coded Columns

omega1983 — Fri, 31 May 2013 13:39:33 GMT

I have a report that writes to ODS Output. Example

COLUMN ID LAST_NAME FIRST_NAME WEST EAST SOUTH

Sample Output 1 SMITH JOHN Y Y

Now I need to show a row on top and color code the last three variables based on name

Sample Desired MY FIRST ROW

                                      Detail                                  ZONE1   ZONE2    ZONE3
COLUMN               ID LAST_NAME FIRST_NAME    WEST      EAST     SOUTH
                            1   SMITH           JOHN                  Y                              Y

The DETAIL area should not change. The Column and header is already blue Here is the present code for the style

style(report)=[background=black cellspacing=10 just=center font_size=11pt font_face="Calibri" bordercolor=black borderwidth=1]

style(column)=[background=white font_size=10pt bordercolor=black borderwidth=1]

style(header)=[background=blue font_weight=bold foreground=white bordercolor=black borderwidth=1]

;

MY FIRST ROW should be the first row header

DETAIL ZONE1 2 and 3 should be the second row headers

The ZONE1 should have a header(WEST) and row header=GREEN

The ZONE2 should have a header(EAST) and row header=RED

The ZONE3 should have a header(SOUTH) and row header=BLUE

Re: ODS Multiple Rows; Color Coded Columns

ballardw — Fri, 31 May 2013 16:50:40 GMT

Which procedure are you using to generate your report? Appearance options vary by procedure and you may not need to change a style to get desired results. An example of the code you are currently using would be helpful.

Re: ODS Multiple Rows; Color Coded Columns

Cynthia_sas — Fri, 31 May 2013 21:14:01 GMT

I agree with ballardw...the procedure you use and your ODS destination of choice (HTML, RTF, PDF) might make a difference. Based on the few code snippets you show, I would expect that you might be using PROC REPORT. For color coding based on name, see an example in my SGF paper with Allison Booth using PROC REPORT on page 13 of this paper (http://support.sas.com/resources/papers/proceedings13/366-2013.pdf), where the color coding is based on whether name='Alice' and age = 13 using the CALL DEFINE statement.

cynthia