# How to verify if there are duplicated values in a series

By | May 30, 2015

uni is used to verify if there are or not duplicate values in a series of numeric, alphanumeric or dates variables. uni returns the rank of the first value equal to a previous value from the list, that is to say :

• if the first and the second are identical, uni returns 2
• if the first and the third (or the second and the third) are identical, uni returns 3.
• if no value is duplicated, uni returns 0.

For a numeric “uni” is it acceptable to mix the label, decimal, integer, floating and double precision variables.

Syntax: uni( list_exprg )

The below syntax will return 3,

num\$( uni(24, 15, 24, 1, 2, 3, 4, 5))

If one of the arguments for the function is a dimensioned variable without specifying an index or index interval, all the elements of the variable are used. The specifying of an index or index interval determines the elements to be taken into account.

If an index interval is given so that there is no element, for example uni(VALUES(1..0)), the result returned is 0.

Irrespective of the arguments, uni returns an integer. It should be noted that the uni function never returns 1.