Finding identical rows in 2 tables

Hi everyone, I think my question is relatively easy to answer, but for some reason I can't seam to get it right. Any help will be apreciated.

Let's say I have a table A that has N rows and M columns. i have an other table B that has N+X rows and M columns. Table B contains all the rows in A, plus other rows.

I would like, for every row, to create a variable that takes the value 1 if this row is in table A, and that takes the value 0 if this row isn't in Table A.

Thanks in advance.

Answer 1

[Fangjun Jiang]

look for doc in "doc ismember". There is an example for table rows found in another table.

[Vincent Ouellet]

Thank you very much, didn't think it was that simple!