topic Re: How to delete the replicated data in a dataset in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-delete-the-replicated-data-in-a-dataset/m-p/189803#M47929 <HTML><HEAD></HEAD><BODY><P>If you merged the tables using the data step MERGE BY, you could probably use if first. logic.</P><P>Otherwise use a subsequent PROC SORT with NODUPKEY option.</P></BODY></HTML> Fri, 28 Nov 2014 14:18:13 GMT LinusH 2014-11-28T14:18:13Z How to delete the replicated data in a dataset https://communities.sas.com/t5/SAS-Procedures/How-to-delete-the-replicated-data-in-a-dataset/m-p/189802#M47928 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>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?</P><P>I appreciate your help in advance.</P></BODY></HTML> Fri, 28 Nov 2014 05:00:16 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-delete-the-replicated-data-in-a-dataset/m-p/189802#M47928 m1986MM 2014-11-28T05:00:16Z Re: How to delete the replicated data in a dataset https://communities.sas.com/t5/SAS-Procedures/How-to-delete-the-replicated-data-in-a-dataset/m-p/189803#M47929 <HTML><HEAD></HEAD><BODY><P>If you merged the tables using the data step MERGE BY, you could probably use if first. logic.</P><P>Otherwise use a subsequent PROC SORT with NODUPKEY option.</P></BODY></HTML> Fri, 28 Nov 2014 14:18:13 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-delete-the-replicated-data-in-a-dataset/m-p/189803#M47929 LinusH 2014-11-28T14:18:13Z