topic How to remove duplicate observation through only datastep? in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134117#M10914 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>want to remove duplicate observation from data set only in data&nbsp; step not using any proc not even proc SQL, can we do that?</P><P>can first. and last, variable will help in this case? any other way please let me know.</P></BODY></HTML> Tue, 14 May 2013 19:07:19 GMT Tushar 2013-05-14T19:07:19Z How to remove duplicate observation through only datastep? https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134117#M10914 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>want to remove duplicate observation from data set only in data&nbsp; step not using any proc not even proc SQL, can we do that?</P><P>can first. and last, variable will help in this case? any other way please let me know.</P></BODY></HTML> Tue, 14 May 2013 19:07:19 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134117#M10914 Tushar 2013-05-14T19:07:19Z Re: How to remove duplicate observation through only datastep? https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134118#M10915 <HTML><HEAD></HEAD><BODY><P>How are you defining a "DUPLICATE" and how many variables?</P><P>And why...</P></BODY></HTML> Tue, 14 May 2013 19:15:12 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134118#M10915 Reeza 2013-05-14T19:15:12Z Re: How to remove duplicate observation through only datastep? https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134119#M10916 <HTML><HEAD></HEAD><BODY><P>Duplicate like below one suppose Test is my dataset then</P><P></P><P>id&nbsp;&nbsp;&nbsp; Name&nbsp; address</P><P>===============</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; stef road</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; stef road</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; josef raod</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; josef road</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; pqr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mery road</P><P></P><P></P><P>now all i want to remove duplicare rows like id 1 and 2 and want to keep only single one.. like</P><P></P><P>id&nbsp;&nbsp;&nbsp; Name&nbsp; address</P><P>===============</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; stef road</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; St&nbsp; josef raod</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; pqr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mery road</P></BODY></HTML> Tue, 14 May 2013 19:25:18 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134119#M10916 Tushar 2013-05-14T19:25:18Z Re: How to remove duplicate observation through only datastep? https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134120#M10917 <HTML><HEAD></HEAD><BODY><P>Use a hash table:</P><P><A href="http://stackoverflow.com/questions/5698291/how-to-remove-duplicated-records-observations-without-sorting-in-sas" title="http://stackoverflow.com/questions/5698291/how-to-remove-duplicated-records-observations-without-sorting-in-sas">How to remove duplicated records\observations WITHOUT sorting in SAS？ - Stack Overflow</A></P></BODY></HTML> Tue, 14 May 2013 19:29:01 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-remove-duplicate-observation-through-only-datastep/m-p/134120#M10917 Reeza 2013-05-14T19:29:01Z