Hello team,
What are the methods to dedup in SAS? Can we dedup by proc sort nodup key?
Regards,
blueblue
> 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..
> 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..
@GN0001 wrote:
Hello team,
Can we dedup by proc sort nodup key?
Maxim 4.
Try it and see for yourself.
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: