Dear R-list, I have a dataset, say (the real dataset is 20 columns,110200 rows).
> my.reducedID V1 V2 V3 V4 V5 V6 V7 V8 V9 [1,] 1 0 0 1 14 3 1 0 2 [2,] 2 0 0 1 14 3 1 0 2 [3,] 0 1 0 1 14 2 1 0 2 [4,] 0 0 1 1 14 3 1 0 2 [5,] 0 1 1 0 14 2 1 0 2 [6,] 0 0 0 1 14 3 1 0 2 [7,] 0 0 0 1 0 3 1 0 2 [8,] 0 0 0 1 1 3 1 0 2 [9,] 0 0 0 1 2 3 1 0 2 [10,] 0 0 0 1 3 3 1 0 2 [11,] 0 0 0 1 4 3 1 0 2 [12,] 0 0 0 1 5 3 1 0 2 [13,] 0 0 0 1 6 3 1 0 2 [14,] 0 0 0 1 7 3 1 0 2 [15,] 0 0 0 1 8 3 1 0 2 [16,] 0 0 0 1 9 3 1 0 2 [17,] 0 0 0 1 10 3 1 0 2 [18,] 0 0 0 1 11 3 1 0 2 [19,] 0 0 0 1 12 3 1 0 2 [20,] 0 0 0 1 13 3 1 0 2 [21,] 0 0 0 1 15 3 1 0 2 [22,] 0 0 0 1 16 3 1 0 2 [23,] 0 0 0 1 17 3 1 0 2 [24,] 0 0 0 1 18 3 1 0 2 [25,] 0 0 0 1 19 3 1 0 2 [26,] 0 0 0 1 20 3 1 0 2 [27,] 0 0 0 1 14 0 1 0 2 [28,] 0 0 0 1 14 1 1 0 2 [29,] 0 0 0 1 14 2 1 0 2 [30,] 0 0 0 1 14 4 1 0 2 > I want to search a value in variables, say V1=0, V5=14 and V6=2. The result should look like V1 V2 V3 V4 V5 V6 V7 V8 V9 [3,] 0 1 0 1 14 2 1 0 2 [5,] 0 1 1 0 14 2 1 0 2 [29,] 0 0 0 1 14 2 1 0 2 I can do this with: my.reducedID[c(3,5,29),] Because I have very large dataset I can not make this manual. Then I need the ID of row did not change, I mean like, [3,] [5,] [29,] In dataset this is about ID our customers. I was wondering if anyone give me a trick to make simple. Thanks you very much for any suggestions. Best, Muhammad Subianto ______________________________________________ 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