Sent from my phone. Please excuse my brevity.
On June 2, 2017 8:49:11 PM PDT, Val <valkremk at gmail.com> wrote:
>Hi all,
>
>I have a data set with time interval and depending on the interval I
>want
>to create 5 more variables . Sample data below
>
>obs, Start, End
>1,2/1/2015, 1/1/2017
>2,4/11/2010, 1/1/2011
>3,1/4/2006, 5/3/2007
>4,10/1/2007, 1/1/2008
>5,6/1/2011, 1/1/2012
>6,10/15/2004,12/1/2004
>
>First, I want get interval between the start date and end dates
>(End-start).
>
> obs, Start , end, datediff
>1,2/1/2015, 1/1/2017, 700
>2,4/11/2010, 1/1/2011, 265
>3,1/4/2006, 5/3/2007, 484
>4,10/1/2007, 1/1/2008, 92
>5,6/1/2011, 1/1/2012, 214
>6,10/15/2004,12/1/2004,47
>
>Second. I want create 5 more variables t1, t2, t3, t4 and t5
>The value of each variable is defined as follows
>if datediff < 100 then t1=1, t2=t3=t4=t5=-1.
>if datediff >= 100 and < 200 then t1=0, t2=1,t3=t4=t5=-1,
>if datediff >= 200 and < 300 then t1=0, t2=0,t3=1,t4=t5=-1,
>if datediff >= 300 and < 400 then t1=0, t2=0,t3=0,t4=1,t5=-1,
>if datediff >= 400 and < 500 then t1=0, t2=0,t3=0,t4=0,t5=1,
>if datediff >= 500 then t1=0, t2=0,t3=0,t4=0,t5=0
>
>The complete out put looks like as follow.
>obs, start, end, datediff, t1, t2, t3, t4, t5
>1, 2/1/2015, 1/1/2017, 700, 0, 0, 0, 0, 0
>2, 4/11/2010, 1/1/2011, 265, 0, 0, 1, -1, -1
>3, 1/4/2006, 5/3/2007, 484, 0, 0, 0, 0, 1
>4, 10/1/2007, 1/1/2008, 92, 1, -1, -1,-1, -1
>5 , 6/1/2011, 1/1/2012, 214, 0, 0, 1,-1, -1
>6, 10/15/2004, 12/1/2004, 47, 1, -1, -1, -1, -1
>
>Thank you.
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.