Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: using two dataset simultaneously


From   "Austin Nichols" <[email protected]>
To   [email protected]
Subject   Re: st: using two dataset simultaneously
Date   Mon, 25 Jun 2007 14:59:34 -0400

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index