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: collapsing data from multiple follow-up visits


From   Ashwin Ananthakrishnan <[email protected]>
To   [email protected]
Subject   st: collapsing data from multiple follow-up visits
Date   Tue, 1 Mar 2011 14:51:52 -0800 (PST)

Hi, 

I was wondering if somebody can give me tips on collapsing data points in Stata. 

I have an Excel spreadsheet with several study participants. Each participate has one row with their baseline information (medications). 

At each subsequent visit, the medication information is updated. This is on separate row. The follow up visits are at different time points for different participants and at varying intervals (i.e one person can have a 3 and 6 month follow up, while another can have a follow up visit at 10 months only).

What I would like to do to facilitate analysis is to collapse all data for each participant into one row. All I'm interested in knowing if if they were ever on a specific medication during their follow-up. The "time to new medication use" is not important. 

Is there a way in Stata or Excel to do this without having to manually go through all the follow-up visit rows for each of the 400 or so participants? 

Thanks, 

Ashwin


 


      
*
*   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