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/
