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" <[email protected]>
To: <[email protected]>
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: [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/
