topic How can we do dedup in SAS? in SAS Programming

How can we do dedup in SAS?

GN0001 — Tue, 03 Aug 2021 03:47:32 GMT

Hello team,

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

Regards,

blueblue

Re: How can we do dedup in SAS?

ChrisNZ — Tue, 03 Aug 2021 04:26:14 GMT

> 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..

Re: How can we do dedup in SAS?

Kurt_Bremser — Tue, 03 Aug 2021 05:51:49 GMT

@GN0001 wrote:

Hello team,

Can we dedup by proc sort nodup key?

Maxim 4.

Try it and see for yourself.

Re: How can we do dedup in SAS?

japelin — Tue, 03 Aug 2021 09:58:48 GMT

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;