Re: st: dropped observations after append

[Michael McCulloch <mm@pinest.org>]

Thanks Maarten; dset is float  %9.0g in both datasets.

At 04:42 PM 3/19/2006, you wrote:
> Michael:
> Is the variable dset in dset1.dta a string? (open dset1.dta and type -desc 
> dset- to find out)
> HTH,
> Maarten
>
> --- Michael McCulloch <mm@pinest.org> wrote:
>
> > I have two datasets, (dset1.dta and dset2.dta).
> > With dset1.dta, I append with the command: append using dset2.dta.
> >
> > dset1.dta has:
> > id      dset    agev    male    meduse  afev1
> > 2       1       10      1       1       1.700833
> > 6       1       11      0       0       2.084792
> > 15      1       11      1       0       1.499583
> > 18      1       7       1       0       1.183437
> > 20      1       10      1       0       1.400417
> >
> > dset2.dta has:
> > id      dset    agev    male    meduse  afev1
> > 2       0       10      1       0       -9
> > 6       0       11      0       1       -9
> > 15      0       11      1       1       -9
> > 18      0       7       1       1       -9
> > 20      0       10      1       1       -9
> >
> > After I append, why are values from the first dataset dset1.dta for the
> > variable dset==1 are dropped?
> > id      dset    wheeze  cough   meduse  afev1   male    agev    height
> > anysx
> > 2       0       0       0       0       -9      1       10      137.922
> > 0
> > 2       .       0       0       1       1.700833        1       10
> > 137.922 0
> > 6       .       0       1       0       2.084792        0       11
> > 150.876 1
> > 6       0       0       1       1       -9      0       11      150.876
> > 1
> > 15      .       0       1       0       1.499583        1       11
> > 141.986 1
> > 15      0       0       1       1       -9      1       11      141.986
> > 1
> > 18      .       0       0       0       1.183437        1       7
> > 120.396 0
> > 18      0       0       0       1       -9      1       7       120.396
> > 0
> > 20      .       0       0       0       1.400417        1       10
> > 150.114 0
> > 20      0       0       0       1       -9      1       10      150.114 0
> >
> >
> >
> >
> > Best wishes,
> > Michael
> >
> >
> > ____________________________________
> >
> > Michael McCulloch
> > Pine Street Clinic
> > 124 Pine Street, San Anselmo, CA 94960-2674
> > tel     415.407.1357
> > fax     415.485.1065
> > email:  mm@pinest.org
> > web:    www.pinest.org
> >          www.pinestreetfoundation.org
> >
> >
> >
> >
> >
> > *
> > *   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/
> >
>
>
> -----------------------------------------
> between 1/2/2006 and 31/3/2006 I will be
> visiting the UCLA, during this time the
> best way to reach me is by email
>
> Maarten L. Buis
> Department of Social Research Methodology
> Vrije Universiteit Amsterdam
> Boelelaan 1081
> 1081 HV Amsterdam
> The Netherlands
>
> visiting adress:
> Buitenveldertselaan 3 (Metropolitan), room Z214
>
> +31 20 5986715
>
> http://home.fsw.vu.nl/m.buis/
> -----------------------------------------
>
>
>
> ___________________________________________________________
> Win a BlackBerry device from O2 with Yahoo!. Enter now. 
> http://www.yahoo.co.uk/blackberry
> *
> *   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/

Best wishes,
Michael


____________________________________

Michael McCulloch
Pine Street Clinic
124 Pine Street, San Anselmo, CA 94960-2674
tel     415.407.1357
fax     415.485.1065
email:  mm@pinest.org
web:    www.pinest.org
        www.pinestreetfoundation.org





*
*   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/