Proc report Missing age group

Akhila1 — Wed, 26 Oct 2022 14:28:48 GMT

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.

Re: Proc report Missing age group

PaigeMiller — Wed, 26 Oct 2022 14:39:20 GMT

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.

topic Proc report Missing age group in SAS Programming

Proc report Missing age group

Re: Proc report Missing age group