subset(table1, rate != 999&id == table2$id) On 2/6/07, lalitha viswanath <[EMAIL PROTECTED]> wrote: > Hi > I have table1 which has the foll. columns > id age rate > > and table2 which has the foll. columns > id count > > I wish to get data from table1 for all the ids which > are persent in table2 and where the rate is not equal > to 999. > The ids in table2 are a subset of those in table1 and > every id in table2 has an entry in table1. > > I would appreciate your input regarding the above. > > Thanks in advance > Lalitha > > ______________________________________________ > R-help@stat.math.ethz.ch 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. >
-- WenSui Liu A lousy statistician who happens to know a little programming (http://spaces.msn.com/statcompute/blog) ______________________________________________ R-help@stat.math.ethz.ch 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.