Visintainer, Paul <[email protected]>:
see -help merge-
use dataset2
sort sex agemo
save d2
use dataset1
sort sex agemo
merge sex agemo using d2
tab _m
ren _m merge_d2
g underwt = (bmi < p5) if !mi(bmi,p5)
save combined
On 6/25/07, Visintainer, Paul <[email protected]> wrote:
I have a dataset of about 1000 children and adolescents all of whom have
My problem is that the unique BMI cutpoints based on age and sex (the
"specific value" in the command above--more than 400 of them), are in
another dataset. The format of the dataset with the BMI standards looks
like:
Sex Agemo P5 P85 P95
1 61.5 13.82664746 16.84600319 17.96602144
1 62.5 13.81537489 16.85300198 17.99561523
1 63.5 13.8047237 16.86173124 18.02763543
1 64.5 13.79469004 16.87216519 18.06201396
1 65.5 13.78526882 16.88428085 18.09868317
1 66.5 13.77645627 16.89805459 18.13757754
. . .
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/