Dear All,
A big thank you to all who so promptly responded to my query, the data is
now duplication free.
For the benefit of those who might have a similar query, this is how it was
done:-
Sort in ascending order the variable(s) that are duplicated, then use the
LAG function to identify the duplication:-
For a single variable
if (x=lag(x)) dup=1.
for 2 variables
if (x=lag(x) and y=lag(y))=1.
Then
select if dup ne 1.
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|