Statalist The Stata Listserver


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

Re: st: dropped observations after append


From   Michael McCulloch <mm@pinest.org>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: dropped observations after append
Date   Sun, 19 Mar 2006 17:23:59 -0800

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/



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