topic Re: Filter out Ranking's Highest Number in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-out-Ranking-s-Highest-Number/m-p/198784#M15029 <HTML><HEAD></HEAD><BODY><P>Thank you all, I figured it out.</P></BODY></HTML> Thu, 13 Aug 2015 23:31:27 GMT sdang 2015-08-13T23:31:27Z Filter out Ranking's Highest Number https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-out-Ranking-s-Highest-Number/m-p/198783#M15028 <HTML><HEAD></HEAD><BODY><P><BR />I ranked Guest account based on their playdate. So a guest first playdate&nbsp; is ranked as 1; second playdate is ranked as 2, and so on.&nbsp; I got million of rows of data and I want to get the highest ranked number of the guest's. </P><P>Please see image below of the sample data.&nbsp; Now what I want is to take GuestNumber 103726's highest ranked number which is 75 and bring it to another dataset.&nbsp; How do I go about to do that ?</P><P><IMG alt="Capture.PNG" class="jive-image" src="https://communities.sas.com/legacyfs/online/11389_Capture.PNG" /></P></BODY></HTML> Thu, 13 Aug 2015 21:42:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-out-Ranking-s-Highest-Number/m-p/198783#M15028 sdang 2015-08-13T21:42:16Z Re: Filter out Ranking's Highest Number https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-out-Ranking-s-Highest-Number/m-p/198784#M15029 <HTML><HEAD></HEAD><BODY><P>Thank you all, I figured it out.</P></BODY></HTML> Thu, 13 Aug 2015 23:31:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Filter-out-Ranking-s-Highest-Number/m-p/198784#M15029 sdang 2015-08-13T23:31:27Z