https://communities.sas.com/t5/SAS-Programming/sql-equivalent-of-first-variable-not-equal-to-last-variable/m-p/17074#M2438 in datastep if we want to select all those not distinct records first.variable ne last.variable logic can be applied.<BR /> Is there an equivalent in proc sql? Thu, 14 Oct 2010 18:49:59 GMT SASPhile 2010-10-14T18:49:59Z https://communities.sas.com/t5/SAS-Programming/sql-equivalent-of-first-variable-not-equal-to-last-variable/m-p/17074#M2438 in datastep if we want to select all those not distinct records first.variable ne last.variable logic can be applied.<BR /> Is there an equivalent in proc sql? Thu, 14 Oct 2010 18:49:59 GMT https://communities.sas.com/t5/SAS-Programming/sql-equivalent-of-first-variable-not-equal-to-last-variable/m-p/17074#M2438 SASPhile 2010-10-14T18:49:59Z https://communities.sas.com/t5/SAS-Programming/sql-equivalent-of-first-variable-not-equal-to-last-variable/m-p/17075#M2439 Got it:<BR /> <BR /> group by variable name<BR /> having count(*)&gt;1 Thu, 14 Oct 2010 19:12:57 GMT https://communities.sas.com/t5/SAS-Programming/sql-equivalent-of-first-variable-not-equal-to-last-variable/m-p/17075#M2439 SASPhile 2010-10-14T19:12:57Z