I mean, we did create these reports with SAS so there's a ton of functionality available to automate. There were 132 different reports created.  So it depends on the amount of effort you want to put in to the report, but it's definitely doable.    Super basic starting ideas: https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md   ... View more

@cjpink07 wrote: Thanks. Just working with BRFSS data. I couldn’t remember how to code for a frequency data for number of good health days by race and sex. Last time I checked the question response was in days not good EXCEPT for the Don't Know and Refused which were 77 and 99. The 88 meant no days of bad/poor mental or physical health. So you need to change the 88 to 0 and set the 77 and 99 to missing before any calculations.   The tricky part is if you are looking for just Physical Health or Mental Health, as those are two topics that some combine to get a single Healthy Days. At which point you may want to look at the documentation for your data set and see if there is a CDC added variable that has the value you want.   One of the approaches was to use the average physical and mental days not good after setting the don't know and refused to missing and the conversion of 88 to 0. Then subtract that from 30 if you want days not poor/bad. Another approach would be to subtract the max of the physical/mental days bad from 30 to get "good" days. After you have the new variable with the count you want then it should be easy. ... View more