Thanks for all of your help. It works to me.
Kate


On Mon, Nov 15, 2010 at 10:06 AM, David Winsemius <dwinsemius@comcast.net>wrote:

>
> On Nov 15, 2010, at 10:42 AM, Kate Hsu wrote:
>
> Hi r users,
>>
>> I have two data sets (X1, X2). For example,
>> time1<-c( 0,   8,  15,  22,  43,  64,  85, 106, 127, 148, 169, 190 ,211 )
>> outpue1<-c(171 ,164 ,150 ,141 ,109 , 73 , 47  ,26  ,15  ,12   ,6   ,2   ,1
>> )
>> X1<-cbind(time1,outpue1)
>>
>> time2<-c( 0   ,8  ,15 , 22  ,43 , 64  ,85 ,106 ,148)
>> output2<-c( 5   ,5   ,4   ,5   ,5   ,4   ,1   ,2 ,  1 )
>> X2<-cbind(time2,output2)
>>
>> I want to merge X1 and X2 into a big dataset X by time1 and time2 so that
>> the missing item in output2 will be replace by 0. For example, there is no
>> output2 when time2=127, then the corresponding output will be 0. Anyone
>> know
>> how to use merge command to deal with this?
>>
>
> > merge(X1,X2, by.x="time1", by.y="time2", all=TRUE)
>   time1 outpue1 output2
> 1      0     171       5
> 2      8     164       5
> 3     15     150       4
> 4     22     141       5
> 5     43     109       5
> 6     64      73       4
> 7     85      47       1
> 8    106      26       2
> 9    127      15      NA
> 10   148      12       1
> 11   169       6      NA
> 12   190       2      NA
> 13   211       1      NA
>
>
>
>> Thanks,
>>
>> Kate
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help@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<http://www.r-project.org/posting-guide.html>
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
> David Winsemius, MD
> West Hartford, CT
>
>

	[[alternative HTML version deleted]]

