This example shows how to
customize row and column headings.
A label specifies text for a heading. A blank label creates a blank heading.
PROC TABULATE removes the space for blank column headings from the table.
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
options nodate pageno=1 linesize=80 pagesize=60; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
proc tabulate data=energy format=dollar12.; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
class region division type; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
var expenditures; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
table region*division,
type='Customer Base'*expenditures=' '*sum=' ' |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
/ rts=25; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
format region regfmt. division divfmt. type usetype.; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
title 'Energy Expenditures for Each Region';
title2 '(millions of dollars)';
run; |
![Note about figure](../../../../common/63294/HTML/default/images/snbut.gif) |
Energy Expenditures for Each Region 1
(millions of dollars)
---------------------------------------------------
| | Customer Base |
| |-------------------------|
| |Residential | Business |
| | Customers | Customers |
|-----------------------+------------+------------|
|Region |Division | | |
|-----------+-----------| | |
|Northeast |New England| $7,477| $5,129|
| |-----------+------------+------------|
| |Middle | | |
| |Atlantic | $19,379| $15,078|
|-----------+-----------+------------+------------|
|West |Mountain | $5,476| $4,729|
| |-----------+------------+------------|
| |Pacific | $13,959| $12,619|
---------------------------------------------------
| |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.