BookmarkSubscribeRSS Feed
omega1983
Calcite | Level 5

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

2 REPLIES 2
ballardw
Super User

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.

Cynthia_sas
SAS Super FREQ

Hi

  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

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
  • 2 replies
  • 668 views
  • 0 likes
  • 3 in conversation