If you think you may be doing things like this frequently you may want to look into Proc summary.
When you use class variables you levels of summary for combinations of the class variables. For instance if you you have Gender and Race as class variables you get an output of requested summaries for: All records, Race, Gender and Race combined with Gender. A special variable _type_ tells which combination data is summarized. So could summarize the data with one pass through and then using combinations of _type_ ,ranges of the Class variables and/ or statistics you can build a number of tables or charts from one summarized data set.
... View more