Hi,
I am a criminology student analysing survey data. I have two age grouped variables which I would like to combine in Stata:
Age first viewed Movie type 1 (1 (0–4 years) 2 (5–9 years) 3 (10–13 years) 4 (14–15 years) 5 (16–17 years) 6 )18–20 years 7 (21–24 years) 8 (25–29 years) 9 (30–34 years) 10 (35–39 years) 11 (40+ years)
Age first viewed Movie type 2 (same age categories as variable 1 above)
I would like to combine these two variables, telling Stata that if a respondent has viewed both movie types, to record earliest age viewed of the two movie types - i.e. record the age of whichever one came first. In other words, if a respondent first viewed Movie type 1 at age 14–15 years, and viewed Movie type 2 at age 16–17 years, to record the age 14–15 years as this is the earliest age.
At the end I would like one variable measuring the age respondents first viewed either type of movie, with the youngest age recorded if they viewed both types.
Can anyone help? Thank you in advance!