forvalues command for specific values of a variable

[Anna Arntz]

Hi all,

my problem is, that i´d like to delete just specific duplicates of a variable, but not all duplicates. Of course I could do it with repeatedly typing "duplicates drop if var_xy == x1" for all values
but I´m searching for a more elegant solution. I thought about solving it with a forvalues command like:

forvalues var_xy=1 5 6 9 ... {
duplicates drop
}

But forvalues isn´t working for single digits.

If anyone has an idea how to solve this problem, please let me know!

Thanks

Anna

[Jesse Wursten]

Try

local values "1 5 6 9"
foreach value of local values {
duplicates drop if var_xy == `value'
}

[Nick Cox]

First simplification

foreach value in 1 5 6 9  {    
   duplicates drop if var_xy == `value'
}

Second simplification

duplicates drop if inlist(var_xy, 1, 5, 6, 9)

[Anna Arntz]

Perfect! Thanks a lot!