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