Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   "Richard Atkins" <Richard.Atkins@lshtm.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Combining two data files and follow-up data in Stata
Date   Fri, 30 Jun 2006 13:26:02 +0100

Whoops!  In case it wasn't obvious from the context, the last line was
meant to be "THEN use the merge command."

>>> Richard.Atkins@lshtm.ac.uk 06/30/06 12:54 pm >>>
You will have to reshape your followup file from long to wide (so each
case is a main_ID and has variables x_1, x_2 etc representing the
repeated measurements.  They use the merge command.

Richard Atkins.
London School of Hygiene and Tropical Medicine

>>> JWhite@yesvirginia.org 06/30/06 12:50 pm >>>
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/ 
*
*   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