st: RE: Combining two data files and follow-up data in Stata

["White, Justin" <JWhite@yesvirginia.org>]

Try the merge command.


Justin White

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Ashwin
Ananthakrishnan
Sent: Friday, June 30, 2006 7:48 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Combining two data files and follow-up data in Stata

Hi,

I currently have 2 data files in Stata - the first
file is the main file with a list of all the subjects
in the study organised by a main_ID number. I have a
second file which contains follow-up data - with each
entry representing one follow-up visit. That file is
sorted by the main_ID also but because each patient
has more than 1 follow-up visit, there might be
multiple entries per main_ID. 

1. How do I combine these two data files using main_ID
as the common variable?

2. How can I combine the follow-up data such that I
have one 1 record for each main_ID number which lists
the outcome at each follow-up visit?

Thanks,
Ashwin

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
*
*   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/