Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Combining multiple observations by an ID variable


From   "Swanquist, Quinn Thomas" <[email protected]>
To   "[email protected]" <[email protected]>
Subject   st: RE: Combining multiple observations by an ID variable
Date   Tue, 12 Jun 2012 21:16:11 +0000

Do you have an identifier for visit number (if not you could use date).

Sort as follows:

sort IDcode visit

then merge many to one as follows:

merge m:1 IDcode using "usingfile"



Quinn Swanquist
[email protected]




-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Claude Beaty
Sent: Tuesday, June 12, 2012 5:02 PM
To: [email protected]
Subject: st: Combining multiple observations by an ID variable

All,

I have a large dataset of observations in which individuals (~40,000 ID codes) were evaluated multiple times (5-10 visit numbers per individual) on over 70 variables. However, the data has been arranged so that each visit number is an observation, instead of each individual ID code as an observation. I need to merge this file with another file sorted by individual ID codes. How do I rearrange this data so that it is arranged by ID codes with consecutive follow up visits? Thanks

Claude A. Beaty Jr., M.D.
Halsted Surgical Resident
Cardiac Surgery Research Fellow
The Johns Hopkins Hospital


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/





*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index