Proc report Missing age group

[Akhila1]

Hi,

Age Group
00-17 Under 18
18-19
20-21
22-24
25-29
40-49

I am seeing these age groups in my SAS report. I want to see the  missing age group 30-34 and 35-39 and 40-45 etc. in my proc report output

Any help on adding this in proc report is appreciated.

Thank you.

[PaigeMiller · Accepted solution]

If the age groups are created by a format, then in PROC REPORT you can use COMPLETEROWS and PRELOADFMT, and age groups with zero observations will show up in the table.

If the age groups are a character variable, then the above won't work, you probably have to resort to a trick to get PROC REPORT to make use of these age groups — include all age groups in your data set with all missing values and use the MISSING option.