Dear R list, I have an event history data set that is structured like this: Legislative act Discussion Agreement Time Event Act1 2006-05-30 2006-06-19 20 1 Act2 2004-03-01 2004-06-14 105 1 . . . I have information on the meetings in the legislature between adoption periods in a separate variable (the start and stop dates are included): Act1 meeting:2006-05-30, 2006-06-19. Act2 meeting: 2004-03-22, 2004-04-26, 2004-06-14. I want to code this as a discrete event data set, so it should look like this: Legislative act Event Meeting Time Count Act1 0 2006-05-30 1 Act1 1 2006-06-07 2 Act2 0 2004-03-22 1 Act2 0 2004-04-26 2 Act2 1 2004-06-14 3 Can anyone tell me if it is possible to do this recoding in R, or do I have to do it by hand? Best, Thomas
If you are talking about changing from a "wide" format to "long" take a look at ?reshape --- Josh On Fri, Apr 23, 2010 at 7:09 AM, Thomas Jensen <thomas.jensen at eup.gess.ethz.ch> wrote:> Dear R list, > > I have an event history data set that is structured like this: > > Legislative act ? ? Discussion ? ? Agreement ? ? Time ? ? Event > Act1 ? ? ? ? ? ? ? ?2006-05-30 ? ? 2006-06-19 ? ? 20 ? ? ? ?1 > Act2 ? ? ? ? ? ? ? ?2004-03-01 ? ? 2004-06-14 ? ? 105 ? ? ? 1 > . > . > . > > I have information on the meetings in the legislature between adoption > periods in a separate variable (the start and stop dates are included): > > Act1 meeting:2006-05-30, 2006-06-19. > Act2 meeting: 2004-03-22, 2004-04-26, 2004-06-14. > > I want to code this as a discrete event data set, so it should look like > this: > > Legislative act ? ? Event ? ? Meeting ? ? Time Count > Act1 ? ? ? ? ? ? ? ? ?0 ? ? ? 2006-05-30 ? ? ?1 > Act1 ? ? ? ? ? ? ? ? ?1 ? ? ? 2006-06-07 ? ? ?2 > Act2 ? ? ? ? ? ? ? ? ?0 ? ? ? 2004-03-22 ? ? ?1 > Act2 ? ? ? ? ? ? ? ? ?0 ? ? ? 2004-04-26 ? ? ?2 > Act2 ? ? ? ? ? ? ? ? ?1 ? ? ? 2004-06-14 ? ? ?3 > > Can anyone tell me if it is possible to do this recoding in R, or do I > have to do it by hand? > > Best, Thomas > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Joshua Wiley Senior in Psychology University of California, Riverside http://www.joshuawiley.com/
Thanks Josh, But I am not sure if the reshape function can create new rows based on the meeting variable. For the second act there are three meetings, i.e. one meeting between discussion and agreement, and this should be entered as a separate row. Best, Thomas On Fri, 2010-04-23 at 07:45 -0700, Joshua Wiley wrote:> If you are talking about changing from a "wide" format to "long" take a look at > > ?reshape > > > --- > Josh > > On Fri, Apr 23, 2010 at 7:09 AM, Thomas Jensen > <thomas.jensen at eup.gess.ethz.ch> wrote: > > Dear R list, > > > > I have an event history data set that is structured like this: > > > > Legislative act Discussion Agreement Time Event > > Act1 2006-05-30 2006-06-19 20 1 > > Act2 2004-03-01 2004-06-14 105 1 > > . > > . > > . > > > > I have information on the meetings in the legislature between adoption > > periods in a separate variable (the start and stop dates are included): > > > > Act1 meeting:2006-05-30, 2006-06-19. > > Act2 meeting: 2004-03-22, 2004-04-26, 2004-06-14. > > > > I want to code this as a discrete event data set, so it should look like > > this: > > > > Legislative act Event Meeting Time Count > > Act1 0 2006-05-30 1 > > Act1 1 2006-06-07 2 > > Act2 0 2004-03-22 1 > > Act2 0 2004-04-26 2 > > Act2 1 2004-06-14 3 > > > > Can anyone tell me if it is possible to do this recoding in R, or do I > > have to do it by hand? > > > > Best, Thomas > > > > ______________________________________________ > > R-help at r-project.org mailing list > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > > > >
did you look at the survSplit() function in the survival library? you may have to recode your date variable to a zero point, i.e. Jan 1 1900 = 0, and measure your time like that. The survSplit function will split your survival duration into specified cut points. I hope this helps Corey ----- Corey Sparks, PhD Assistant Professor Department of Demography and Organization Studies University of Texas at San Antonio 501 West Durango Blvd Monterey Building 2.270C San Antonio, TX 78207 210-458-3166 corey.sparks 'at' utsa.edu https://rowdyspace.utsa.edu/users/ozd504/www/index.htm -- View this message in context: http://r.789695.n4.nabble.com/Event-History-Data-Recoding-tp2062297p2063087.html Sent from the R help mailing list archive at Nabble.com.