Today, I stumbled upon a post where the author talks about a new options that are available in SAS 9.3 and later versions. These options (NOUNIQUEKEYS and UNIQUEOUT) that allows sorting and then finding the duplicate records to be done in one step using PROC SORT.