Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: merging data sets


From   "Elizabeth Allred" <lizard@hsph.harvard.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: RE: merging data sets
Date   Tue, 9 Aug 2005 15:40:16 -0400

Your first scenerio looks like an append problem (adding new records to
the bottom of a data set--increasing the number of observations) while
the second looks like a merge with a "by" variable, park name (join a
record to the end of another--increases the number of variables, though
you may add some observations as well).

Liz

> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu 
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of 
> Melissa Bain
> Sent: Tuesday, August 09, 2005 3:18 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: merging data sets
> 
> 
> Hi all,
> 
> Sorry for the incredibly beginner question, but I am having a 
> hard time merging data sets from Excel.  2 different scenarios....
> 
> 1.  I have individual patient data on separate Excel spread 
> sheets.  I have already saved them as text delimited and then 
> saved each patient as a separate Stata data set, but cannot 
> seem to merge them.  Is it "append" instead?  
> 
> 2.  Another data set is from parks that we evaluated, with 2 
> separate evaluation areas. 
> One was visitor interviews, and second was investigator 
> measurements.  The common "variable" (for lack of a better 
> term, since I'm a newbie) is the park name.
> 
> I am excited about using this program, but I can't even get 
> passed this first problem!!!!
> 
> Thanks,
> 
> Melissa Bain
> -----------------------------------
> 
> Melissa Bain, DVM, DACVB
> Companion Animal Behavior Program
> UC Davis School of Veterinary Medicine
> Davis, CA  95616
> mjbain@ucdavis.edu
> *
> *   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/



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