How to delete the replicated data in a dataset

[m1986MM]

Hello,

I've merged two datasets. However, there exist lots of replicated observations in the merged dataset. How can I say to just keep one of the observations with the same value for all the variables?

I appreciate your help in advance.

[LinusH · Accepted solution]

If you merged the tables using the data step MERGE BY, you could probably use if first. logic.

Otherwise use a subsequent PROC SORT with NODUPKEY option.