Asked • 04/23/19

How to remove duplicated records\\observations WITHOUT sorting in SAS?

I wonder if there is a way to unduplicate records **WITHOUT** sorting?Sometimes, I want to keep original order and just want to remove duplicated records. Is it possible? BTW, below are what I know regarding unduplicating records, which does sorting in the end.. 1. proc sql; create table yourdata_nodupe as select distinct * From abc; quit; 2. proc sort data=YOURDATA nodupkey; by var1 var2 var3 var4 var5; run;

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.