topic Re: Last n obs from each group in SAS Programming https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146395#M29144 <HTML><HEAD></HEAD><BODY><P>To add, the double dow loop <A href="http://support.sas.com/resources/papers/proceedings09/038-2009.pdf" title="http://support.sas.com/resources/papers/proceedings09/038-2009.pdf">http://support.sas.com/resources/papers/proceedings09/038-2009.pdf</A> looks to uses the merge by with a reset at the same position / group order.</P><P>In that case you have a generic approach for a sorted dataset.&nbsp; </P></BODY></HTML> Wed, 17 Sep 2014 17:04:38 GMT jakarman 2014-09-17T17:04:38Z Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146387#M29136 <HTML><HEAD></HEAD><BODY><P>can anyone please help me to get last n obs from each group with out sort the dataset?</P><P></P><P>Thanks </P></BODY></HTML> Tue, 16 Sep 2014 06:17:04 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146387#M29136 Aman4SAS 2014-09-16T06:17:04Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146388#M29137 <HTML><HEAD></HEAD><BODY><P>It are the first n obs of each group when processing in reversed order.&nbsp; For small data re-sorting is easy and quickest way. </P></BODY></HTML> Tue, 16 Sep 2014 06:21:53 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146388#M29137 jakarman 2014-09-16T06:21:53Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146389#M29138 <HTML><HEAD></HEAD><BODY><P>Thanks, but i cant sort the data, i need to get from as data it is.</P></BODY></HTML> Tue, 16 Sep 2014 06:24:26 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146389#M29138 Aman4SAS 2014-09-16T06:24:26Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146390#M29139 <HTML><HEAD></HEAD><BODY><P>please elaborate your limitations.&nbsp; <BR />With an external RDBMS there is no physical order defined only logical ordering. In that case a question like this is humbug.<BR />With streaming data you could define a queue of defined size. The lag function of SAS is looking like that. Also a hash can be used for that<BR />Big data with SAS-datasets (relative to your machine) can be processed using a point but than you are losing the first/last options.</P><P>What to do if there are less than n records in a group?&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Tue, 16 Sep 2014 07:10:52 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146390#M29139 jakarman 2014-09-16T07:10:52Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146391#M29140 <HTML><HEAD></HEAD><BODY><P>Hi, Thanks my issue has been solved.</P><P>Should i delete this post?</P></BODY></HTML> Tue, 16 Sep 2014 07:17:10 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146391#M29140 Aman4SAS 2014-09-16T07:17:10Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146392#M29141 <HTML><HEAD></HEAD><BODY><P>No. On the contrary, I think you should share your solution with the forum. So should someone else have the similar issue, the answer becomes available. </P><P></P><P>Regards,</P><P>Haikuo </P></BODY></HTML> Tue, 16 Sep 2014 14:03:35 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146392#M29141 Haikuo 2014-09-16T14:03:35Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146393#M29142 <HTML><HEAD></HEAD><BODY><P>Isn't this same questions <A __default_attr="645292" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A> showed us the clever solution to within the last month?</P></BODY></HTML> Tue, 16 Sep 2014 14:09:52 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146393#M29142 data_null__ 2014-09-16T14:09:52Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146394#M29143 <HTML><HEAD></HEAD><BODY><P>I was so honor being mentioned by SAS Master&nbsp; Mr.&nbsp; NULL .</P></BODY></HTML> Wed, 17 Sep 2014 12:03:39 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146394#M29143 Ksharp 2014-09-17T12:03:39Z Re: Last n obs from each group https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146395#M29144 <HTML><HEAD></HEAD><BODY><P>To add, the double dow loop <A href="http://support.sas.com/resources/papers/proceedings09/038-2009.pdf" title="http://support.sas.com/resources/papers/proceedings09/038-2009.pdf">http://support.sas.com/resources/papers/proceedings09/038-2009.pdf</A> looks to uses the merge by with a reset at the same position / group order.</P><P>In that case you have a generic approach for a sorted dataset.&nbsp; </P></BODY></HTML> Wed, 17 Sep 2014 17:04:38 GMT https://communities.sas.com/t5/SAS-Programming/Last-n-obs-from-each-group/m-p/146395#M29144 jakarman 2014-09-17T17:04:38Z