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.
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.
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: