Generating a dummy variable if a household has a migrant or not.

[Nicola Barker]

I have household survey on data including variables

'HouseholdID' containing an ID number unique to each household, with about 1-10 individuals per household.

Some of these individuals are also migrants indicated by a dummy 'IndividualIsMigrant =1 if migrant =0 if not'

What i want to do is to create a new dummy variable 'HHdContainsMigrant' if any of the household members are migrants.

I hope this is clear

Thanks for the Help

[Nick Cox]

https://www.stata.com/support/faqs/d...ble-recording/

[Nicola Barker]

Thanks Very Much