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

Re: st: merging data sets


From   Manuel Chávez <mchavez@evalalianza.org.mx>
To   <statalist@hsphsun2.harvard.edu>
Subject   Re: st: merging data sets
Date   Tue, 9 Aug 2005 15:40:03 -0500

You can also use the standard Stat Transfer for transforming excell into
stata files.

Another thing, just remember to

drop _merge

after using merge in any case you have many files, or give a different name
to the _merge variable, just read the help file.

Good Luck

Manuel


----- Original Message -----
From: "Svend Juul" <SJ@SOCI.AU.DK>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, August 09, 2005 2:36 PM
Subject: Re: st: merging data sets


> Melissa wrote:
>
> ... having a hard time merging data sets from Excel.  2 different
scenarios....
>
> * Did you use Excel for entering data? One sheet per patient? There are
better solutions; my preference is EpiData which can be downloaded for free
from http://www.epidata.dk. It is easy to use and can export to, among
others, Stata.
>
> ---------------------------
>
> 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?
>
> * Since you have similar data on different patients on the sheets you
need -append-.
>
> ----------------------------
>
> 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.
>
> * Here you have different data on the same subjects (parks) and you
need -merge-:
>   . merge parkname using(...)
>
> -----------------------------
>
> I am excited about using this program, but I can't even get passed this
first problem!!!!
>
> * I recall the feeling.
>
> -----------------------------
>
> Hope this helps
> Svend
>
> ________________________________________________________
>
> Svend Juul
> Institut for Folkesundhed, Afdeling for Epidemiologi
> (Institute of Public Health, Department of Epidemiology)
> Vennelyst Boulevard 6
> DK-8000 Aarhus C,  Denmark
> Phone, work:  +45 8942 6090
> Phone, home:  +45 8693 7796
> Fax:          +45 8613 1580
> E-mail:       sj@soci.au.dk
> _________________________________________________________
>
> *
> *   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