PROC TABULATE by Example, Second Edition

Plan the Categories

For most tables, you will want to break down your variables into a manageable number of categories for reporting. For example, a table on age might show categories of 0-19, 20-29, 30-39, and so on. In this table, the variable EDUC needs to be broken down based on college degree status.

For our purposes, we only care if the person has a college degree or not, so the first three categories of EDUC (<HS, HS GRAD, and SOME COLLEGE) can be combined in our table into a single NO COLLEGE DEGREE category. The COLLEGE GRAD category can then be relabeled COLLEGE DEGREE. The only question is what to do with the SOME GRADUATE category? These people have additional education, which makes them different from the people who have an undergraduate ...