Apply values across all in the same group

[Tiara Rosemond]

Hi all, I have a dataset of about 10k participants across 600 groups (ParentSiteID in the dataset). I have a status update (status=1) for 118 participants that need to be applied to all members of their group (ParentSiteID). How can I do this? Thanks!

[Carlo Lazzaro]

Tiara:
do you mean something along the lines of the following toy-example?

. set obs 5
number of observations (_N) was 0, now 5

. g Group=1

. g flag=1 in 1


. expand 2


. replace Group=2 in 6/10


. replace flag=1 in 7


. bysort Group: replace flag=1 if flag==.


. list

     +--------------+
     | Group   flag |
     |--------------|
  1. |     1      1 |
  2. |     1      1 |
  3. |     1      1 |
  4. |     1      1 |
  5. |     1      1 |
     |--------------|
  6. |     2      1 |
  7. |     2      1 |
  8. |     2      1 |
  9. |     2      1 |
 10. |     2      1 |
     +--------------+

.

[Fei Wang]

Tiara, it depends on the current values of status for other participants. If the status is missing (.) for other participants, just run the following codes.

bys ParentSiteID (status): replace status = status[_n-1] if status[_n-1] == 1

If not, then you may change their values to missing first.

[Tiara Rosemond]

Thank you, Fei Wang! It worked perfectly!
__

Tiara, it depends on the current values of status for other participants. If the status is missing (.) for other participants, just run the following codes.

bys ParentSiteID (status): replace status = status[_n-1] if status[_n-1] == 1

If not, then you may change their values to missing first.

[Tiara Rosemond]

Thanks, Carlo. That's not quite it, but I appreciate your help. Fei Wang provided the code I need.

Thank you again!
___

Tiara:
do you mean something along the lines of the following toy-example?

. set obs 5
number of observations (_N) was 0, now 5

. g Group=1

. g flag=1 in 1


. expand 2


. replace Group=2 in 6/10


. replace flag=1 in 7


. bysort Group: replace flag=1 if flag==.


. list

+--------------+
| Group flag |
|--------------|
1. | 1 1 |
2. | 1 1 |
3. | 1 1 |
4. | 1 1 |
5. | 1 1 |
|--------------|
6. | 2 1 |
7. | 2 1 |
8. | 2 1 |
9. | 2 1 |
10. | 2 1 |
+--------------+

.