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
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.
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
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.
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.