filtering rows

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20111011/0d8313cc/attachment.pl>

Hi everyone,

I've got two data sets as below. My question now is: how can I use  
Dataset2
as a filter for Dataset1? My goal is just to keep the rows of  
Dataset1 where
the first column (Date) matches the Dates in Dataset2.

Perhaps:

merge(Dataset1, Dataset2)

Or:

Dataset1[ Dataset1$Date %in% Dataset1$Date , ]
David.
>
> I would appreciate any solutions to this issue.
>
>
>
> Many thanks!
>
> S.B.
>
>
>
> Dataset1:
>
>                Date      A               B             C             D
>
> 1             1977      10           11           12           13
>
> 2             1978      14           15           16           17
>
> 3             1979      18           19           20           21
>
> 4             1980      22           23           24           25
>
> 5             1981      26           27           28           29
>
>
>
> Dateset2:
>
>
>
>                Date
>
> 1             1977
>
> 2             1978
>
> 3             1979
>
>
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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.

David Winsemius, MD
West Hartford, CT