Select the Statistics
PROC TABULATE gives
you a variety of statistics to choose from. We could report the minimum
income, the maximum income, or the sum of all incomes, but for this
example, the mean income seems more appropriate.
To get a rough idea
of what to expect, we can run PROC MEANS on the data set to calculate
the overall mean income. The results are shown in Output
3.6. The mean, minimum, and maximum values are useful
in deciding how to format the table values. Because the mean is approximately
$23,000, the format needs to have a width of at least 7 digits (2
digits for the dollar sign and the comma and 5 digits for the value).
Output 3.6 PROC MEANS Output Showing Information for the INCOME Variable
Get PROC TABULATE by Example, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.