st: Generating a Variable

[Don Ruby <goofnmick@gmail.com>]

Suppose I have the following data (excepting Ssmoke which I need to create):

    +--------------------------------------------------------+
    |   Mid   Sid  Famid  Msmoke   Ssmoke |
    |----------------------------------------------------------|
 1. |    1      2      1         0              1         |
 2. |    2      1      1         1              0         |
 3. |    3      4      2         1              0         |
 4. |    4      3      2         0              1         |
    +--------------------------------------------------------+

Where Mid is a mother id, Sid is a sibling id, and Famid is a family
id. Msmoke indicates that the mother smoked.

What is the simplest way to create a variable "Ssmoke" that equals 1
if a sibling smoked, and 0 otherwise? (Note, there are families in
which there are more than 2 siblings.)


Thanks,

Don
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/