6-ways of removing duplicate

[Ksharp]

Hi.Charlotte,

That is Uma did.

Data Dup;

     set temp;

     by variable;

     if not first.variable and last.variable;

     run;

You also can get duplicated obs  by using the methods I mentioned before .

Ksharp

[AnandSahu]

Thanx PG State for providing a ans.

[Rahul_SAS]

Hi Uma,

Can you please explaint the 4th way of removing the duplicate.

[art297]

It is similar to Uma's incorrect application of #5.  It identifies values of "variable" where there aren't any duplicates (i.e., if count is gt 1 then there were more than one record which had the same value of variable.

[sandeep_reddy]

hi all,

there is another method to eliminate duplicate values by using proc summary with nway option and class statement.

[umashankersaini]

Apologies for 5th one....Thanks for correcting that....

[shivakrishna]

(4) is wrong uma

[shivakrishna]

how in below methods

6.proc means;

7.proc summary;

8.HashTable

9. proc tabulate

10.proc report