I often need to produce a count of the number of cases of certain diseases by geographic area, such as counties. The data set only consists of cases. When I run a PROC FREQ for the counts by county, I later export it to Excel to format it, etc. The trouble is that each time I run the report, different counties have zero counts for the disease, so there are no rows on the FREQ output for them. It makes comparing the tables from previous time frames difficult, and to make the Excel tables comparable I need to stick in rows or cells with zeroes if I want to combine the tables, which is tedious and error prone. How can I consistently get SAS to output frequencies for all 100 jurisdictions whether or not they have any observations (zero rows of cases) in the data for that time period?
... View more