Duplicate Data finding

[Raeedur Rahman]

on my work sheet i deal with a variable named rmid this mrid contains individual information...i need to find out duplicate rmids from my work sheet.. please any one help me with the command of duplicate data(rmid)
rmid
0112996
0113996
0112587
0112996
0225070
0145562
1112567
0112587

[Carlo Lazzaro]

Raeedur:
you may want to try:

duplicates tag rmid, g(flag)
tab flag

[Raeedur Rahman]

Dear Lazzara Sir
Thank you for your help it works nice for me
sir if i want to see those d uplicates "rmids" at "Data Editor" what shoul i do

[Jorrit Gosens]

bysort rmid:  gen duplicate = cond(_N==1,0,_n)

will give the number of observations with each rmid; 1 for first observation, 2 for first duplicate, 3 for second duplicate etc

[Carlo Lazzaro]

Raeedur:
look for the variables named -flag-.

[Raeedur Rahman]

Thank you all
regards
raeed

[Raeedur Rahman]

carlo sir cant understand ur last advice

[Carlo Lazzaro]

Raeedur:
I meant that, if you open the Editor after running the code, you will find the variable named -flag-.