Hi everyone,

hope you had a nice Christmas.

I am having some Stata issues and i hope that someone could help me.

I have different household IDs (HHID) in my dataset and per household there are several observations. The HHID is coded as a string and looks like "679Zbdejf987fbsdz89". Then I generated another variable that describes if a person is working or not. Work==1 if the person is working.
My goal is to create a variable that indicates if at least one person from the household is working. I.e. if at least one of the HHID has "679Zbdejf987fbsdz89" at work==1, then a variable should be created for all household members " Does anyone know how I implement this?

Regards,
Jasmin