topic Re: selecting first obs of a combination in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201737#M4449 <HTML><HEAD></HEAD><BODY><P>Thanks for coming back to post your solution, <STRONG><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="-1" data-externalid="" data-presence="null" data-userid="856677" data-username="ilikesas" href="https://communities.sas.com/people/ilikesas" id="jive-85667749435119611524186">ilikesas</A></STRONG>!</P></BODY></HTML> Thu, 11 Jun 2015 20:39:59 GMT AnnaBrown 2015-06-11T20:39:59Z selecting first obs of a combination https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201735#M4447 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>suppose that I have the following table already sorted in this specific way:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 686px; height: 100px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>number</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">31/11/2010</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">31/11/2010</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">22/1/2009</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1/1/2008</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>I just need the first row for each company-date combination so that the final result is:</P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 677px; height: 95px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>number</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">31/11/2010</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">22/1/2009</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1/1/2008</TD><TD style="padding: 2px;">1</TD></TR></TBODY></TABLE><P></P><P>thank you!</P></BODY></HTML> Tue, 09 Jun 2015 23:49:09 GMT https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201735#M4447 ilikesas 2015-06-09T23:49:09Z Re: selecting first obs of a combination https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201736#M4448 <HTML><HEAD></HEAD><BODY><P>omg this is so simple that I just didn't think about it, I just do proc sort with nodupkey by company and date!!</P></BODY></HTML> Wed, 10 Jun 2015 00:16:21 GMT https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201736#M4448 ilikesas 2015-06-10T00:16:21Z Re: selecting first obs of a combination https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201737#M4449 <HTML><HEAD></HEAD><BODY><P>Thanks for coming back to post your solution, <STRONG><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" data-avatarid="-1" data-externalid="" data-presence="null" data-userid="856677" data-username="ilikesas" href="https://communities.sas.com/people/ilikesas" id="jive-85667749435119611524186">ilikesas</A></STRONG>!</P></BODY></HTML> Thu, 11 Jun 2015 20:39:59 GMT https://communities.sas.com/t5/SAS-Data-Management/selecting-first-obs-of-a-combination/m-p/201737#M4449 AnnaBrown 2015-06-11T20:39:59Z