I have a dataset where everybody has household ID and each respondent has a given economic status: "Unemployed/Student/Employed/Home Duties". I want to create a variable that records the proportion of the household which is unemployed. i.e. if there is a household of 4 members and 2 are unemployed, then I want this variable to record that 50% of the household is unemployed. Does anyone know how can I create a new variable by household ID to record this?

Thanks,

John