Auto-Code Age Group For Multiple Respondents
I have read the "Auto-Code Age Group Survey Sample" and wonder if anyone could kindly help me with similar technique but for the survey with more than one respondent.
Question 1: Names of all respondents in the household
Answer 1: John, Martha, Mary
Question 2: Age of each respondent
Answer 2: John: 36, Martha: 35, Mary:10
Question 3: Occupation of each respondent
Answer 3: John: Salesman, Martha: Teacher, Mary: Student
Is there a way to default Mary's answer to be Student as her age is under 15? What I want is anyone in the age group of 6-15 will have the answer of Student in question 3 while others get to choose their occupation. I would really appreciate any helps on this issue. Thank you very much in advance.