How can we do dedup in SAS?

[GN0001]

Hello team,

What are the methods to dedup in SAS? Can we dedup by proc sort nodup key?

Regards,

blueblue

[ChrisNZ · Accepted solution]

> Can we dedup by proc sort nodup key?

That's probably the easiest method.

Other methods include 

proc sql select unique 

and loading a hash table.

proc sort is almost always the appropriate tool for deduping..

[Kurt_Bremser]

---

@GN0001 wrote:

Hello team,

Can we dedup by proc sort nodup key?

---

Maxim 4.

Try it and see for yourself.

[japelin]

Why don't you try it anyway?

proc sort data=sashelp.class out=class nodupkey;
  by age;
run;


data class;
  set sashelp.class sashelp.class;
run;
proc sort data=class nodup;
  by age name;
run;