How to create variable for mother's age using ipums dataset in STATA

It is possible to create a variable within the IPUMS data extract system that contains the age of a respondent’s mother by utilizing the Attach Characteristics option. To do so, you should first select your samples and variables, which must contain AGE. Before submitting your extract, you will be given the option to choose “Attach characteristics” on the extract request screen. Check the box for “Mother” on the AGE row. This will add a variable to your data extract request called AGE_MOM. Now simply submit your extract. Keep in mind that the age of a respondent’s mother can be identified only if the mother and child belong to the same household.

Hope this helps.