How do I create an age roll-up recode? (Power Surveys)

You can create an age roll-up recode by manipulating the Date of Birth Question (DOB) from the Profiling Questionnaire. This recode is dynamic, which means that the roll-up will change when a respondent reaches a certain age group. 

Example

You would like to author an Age Roll-up with the following age groups based on a DOB question in the Profiling Questionnaire:

• 18 and below
• 19-54
• 55 and above

Detailed Steps

1. At the bottom of the Questionnaire tree, click References and Recodes.
2. Right-click the study name, and select Add recode.
3. Name the recode, and click OK.
4. Add the following answers to the recode:
   • 18 and below
   • 19-54
   • 55 and above
5. Click the Filter button of the 18 and below option.
   1. In the Quick Select list, right-click the DOB question, and select Add.
   2. Click the Include tab. 
   3. Add the condition DOB IS WITHIN PAST 19 Years.
6. Click the Filter button of 19-54 option.
   1. In the Quick Select list, right-click the DOB question, and select Add.
   2. Click the Include Tab.
   3. Add the condition DOB IS NOT WITHIN PAST 19 Years AND DOB IS WITHIN PAST 55 Years
7. Click the Filter button of 55 and above option.
   1. In the Quick Select list, right-click the DOB question, and select Add.
   2. Click the Include Tab.
   3. Add the condition - DOB IS NOT WITHIN PAST 55 Years.
8. Click Save.
9. Click Validate, to validate the study and fix any errors.

More Information

Please see our article for more information about creating a recode.