Use the Output Delivery System (ODS) in conjunction with the FREQ procedure to create a temporary SAS data set calledincome2 that when printed in its entirety looks like the following: That is, tell SAS to create a data set with the observations containing the number of ICDB subjects (Frequency) for each combination of gender (sex) and marital status (mar_st) (_TYPE_ = 11), as well as the total number for each gender (_TYPE_ = 10), the total number for each marital status (_TYPE_ = 01), and the total overall number (_TYPE_ = 00).
Some helpful comments:
You'll have to sort the data set so that it can be processed by income. When you do so, select only those observations "where" income is not equal to missing.
You'll have to use the ODS TRACE statement to determine which output object is created for income = 2, that is, for an income of at least $30,000.
The _TYPE_ variable is created when you make an output data set using the FREQ procedure.
To suppress the unnecessary default statistics determined in the FREQ procedure, you'll have to use the NOROW, NOCOL, and NOPERCENT options on the TABLE statement.
You'll have to drop a few unnecessary variables from your output data set to get your data set to look like the one above.
To create a table that is formatted like the above, print the income2 data set by sending it to an RTF destination. Note that when you create RTF files, you have to close the SAS Results Viewer between attempts.