drop repeated school`s by years

[Rodrigo Badilla]

Hi all,

sorry for a cross posting..

I have a little big problem: I have a big dataset (n=6.000.000) with a school variable and year`s variable, i would like drop or flag the schools that repeated in differents years, I tried to use "repeated report" but I failed in these task.

I appreciate any comment.
Thank In advance
Rodrigo

[J]

I use the command 'duplicates' for this kind of thing. I think it is an add on.

[Ramadhani Abdul]

Try,

duplicates li school year..... this will list the duplicates in terms of school and year,  if you are ok with the output then use the command duplicates drop school year,force.    NB: make sure you have the backup of the data.