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: [email protected]
> [mailto:[email protected]] On Behalf Of
> Melissa Bain
> Sent: Tuesday, August 09, 2005 3:18 PM
> To: [email protected]
> 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
> [email protected]
> *
> * 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/
