Friday, March 2, 2012

Find out Duplicate observation


proc sql ;
SELECT name, age, count(*)
FROM ankit
GROUP BY name
HAVING count(*) > 1;
quit;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.