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.


Proc Sort dups under V9

From sasCommunity
Jump to: navigation, search

I have always thought that knowing which observations get 'sorted out' of your table when you do a "PROC SORT NODUPKEY" is valuable. Up until now you would have to reprocess the data, using first.var logic to find out the second and subsequent observations, writing them out to a temporary table for analysis.

Now PROC SORT does that all automatically for you:

PROC SORT DATA=foo OUT=foo2 NODUPKEY DUPOUT=foo_dups; BY var; Run;

--Mike 13:10, 21 May 2007 (EDT)