Sunday, March 19, 2006

RE: st: dropped observations after append

But shouldn't the variable type in the master set (dset1.dta) prevail, so the missing would be the dset values from dset2.dta? And doesn't Stata tell you it's seen that as a problem even though it goes ahead and does it anyway?

(Hi, Michael - I think I knew you in grad school.) Jen Marino

-----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Maarten buis Sent: Sunday, March 19, 2006 4:43 PM To: statalist@hsphsun2.harvard.edu Subject: Re: st: dropped observations after append

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/

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


Tag:


Links to this post:

Create a Link



<< Home

This page is powered by Blogger. Isn't yours?