i have two files respondents file and no of siblings file
in the siblings file i have a counter for no of siblings and number
of siblings satisfying certain criteria
for example if in the respondents file there is information
relating to 3 siblings then in the siblings file there are three
cases with the same id but each sibling is listed seperately and
the first counter is 3 for all three occurreences and may (for
eXample be 2 for two of the siblings who satisfy the criteria
i now have an additional variable giving the state of the sister in
the siblings file, alive , dead or dead of a specific case (coded
0, 1 or 2)
what i would like to do is to create a new variable (newdeath) in
the siblings file where for each respondent, if the repondent has
had a sibling dead of a specific cause and a dead sister, then the
new variable would redefine as the most extreme (dead of a
specicifi cause). I would then like to merge this new variable
back into the repondents file.
i give an example of the siblings file
id death newdeath
1 0 1
1 1 1
2 0 0
2 0 0
2 0 0
3 0 2
3 1 2
3 2 2
3 0 2
help much appreciated
regards
ann
----------------------
ann e fitzmaurice
medical statistician
dugald baird centre
department of obs and gynae
university of aberdeen
[log in to unmask]
tel 01224 553876 (direct)
fax 01224 404925
|