Procedure features: |
PROC TABULATE
statement options:
|
STYLE= option in
|
CLASSLEV statement |
|
TABLE statement | |
TABLE statement
|
crossing (*) operator |
|
STYLE_PRECEDENCE= option | |
|
Other features: |
ODS HTML statement |
FORMAT statement |
|
Data set: |
SALES
|
This example
-
creates a category for each sales
type, retail or wholesale, in
each region
-
applies the dollar format to all cells in the table
-
applies an italic font style for each region and sales
type
-
applies a style (background = red, yellow, or orange) color based
on the SYTLE_PRECEDENCE = option
-
generates ODS HTML output
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
proc format;
value $saletypefmt 'R'='Retail'
'W'='WholeSale';
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
ods html file="stylePrecedence.html"; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
title "Style Precedence";
title2 "First Table: no precedence, Orange ";
title3 "Second Table: style_precedence=page, Yellow"; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
proc tabulate data=sales format=dollar10.; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
class product region saletype;
|
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
classlev region saletype / style={font_style=italic};
|
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
var netsales; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
label netsales="Net Sales";
|
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
keylabel all="Total";
|
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
table product *{style={background=red}},
region*{style={background=yellow}},
saletype*{style={background=orange}}; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
table product *{style={background=red}},
region*{style={background=yellow}},
saletype*{style={background=orange}} / style_precedence=page; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
format saletype $saletypefmt.;
|
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
run;
ods html close;
|
![[untitled graphic]](images/proctabulatestyleprecedence.gif)
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.