As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Deduping using Proc Sort

From sasCommunity
Jump to: navigation, search

You can easily deduplicate records based on specific keys using PROC SORT by using the NODUPKEY option. Please note that the deduplication only occurs for the keys defined and not for any other variables.

proc sort data = <data> nodupkey;
    by key1 key2 ... keyN;
run;

....see also


Submitted by Murphy Choy. Contact me at my Discussion Page.