topic Re: How to remove duplicates using proc SQL without Distinct in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185240#M35175 <HTML><HEAD></HEAD><BODY><P>What does your sample data look like ?</P></BODY></HTML> Thu, 04 Sep 2014 12:31:12 GMT Ksharp 2014-09-04T12:31:12Z How to remove duplicates using proc SQL without Distinct https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185238#M35173 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt;">How to remove duplicates using proc SQL without Distinct </SPAN></P></BODY></HTML> Thu, 04 Sep 2014 07:50:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185238#M35173 sas_Forum 2014-09-04T07:50:53Z Re: How to remove duplicates using proc SQL without Distinct https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185239#M35174 <HTML><HEAD></HEAD><BODY><P>What do you mean, please provide test input data and required output, with a description of what you mean by duplicates.&nbsp; The reason being that the sole function of distinct is to remove duplicates, and without some more, perhaps complicated code, you not going to get a better option.</P><P><A href="http://www.w3schools.com/sql/sql_distinct.asp" title="http://www.w3schools.com/sql/sql_distinct.asp">SQL SELECT DISTINCT Statement</A></P></BODY></HTML> Thu, 04 Sep 2014 08:28:22 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185239#M35174 RW9 2014-09-04T08:28:22Z Re: How to remove duplicates using proc SQL without Distinct https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185240#M35175 <HTML><HEAD></HEAD><BODY><P>What does your sample data look like ?</P></BODY></HTML> Thu, 04 Sep 2014 12:31:12 GMT https://communities.sas.com/t5/SAS-Programming/How-to-remove-duplicates-using-proc-SQL-without-Distinct/m-p/185240#M35175 Ksharp 2014-09-04T12:31:12Z