PROC TABULATE by Example, Second Edition

Incorrectly Grouped Statistics

The reason we build tables is to use them to ask questions of our data. Sometimes you build a perfectly good table, but because of how it is organized, it’s hard to figure out what is going on in the data.

This is the case with the following example. We have some data on income, age, and education levels. What we want to know is whether income varies by age or education. Also, we want to know whether there is more variation in income in any particular age or education group. The statistics that we need to answer these questions are MEAN and STD.

The following code produces a table with means and standard deviations for RATE by age and education level. The code is set up correctly, and there is nothing inherently ...