topic Re: How to give Rank number in SAS Enterprise guide? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95816#M257726 <HTML><HEAD></HEAD><BODY><P>There should be a Rank task within EG. I believe it uses PROC RANK, and should probably suit your needs.</P></BODY></HTML> Fri, 27 Sep 2013 12:16:13 GMT LinusH 2013-09-27T12:16:13Z How to give Rank number in SAS Enterprise guide? https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95813#M257723 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I'm using Enterprise Guide 5.1&nbsp; here is my problem:</P><P>I have a table :</P><P></P><P>cust_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; payment_day_id</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">-----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201304</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201305</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201306<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">6789&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201307</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">6789&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201308</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">I want to give a rank number to each row according to&nbsp; payment_day&nbsp;&nbsp; by grouping cust_id</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">above example rank must be like this</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P>cust_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; payment_day_id&nbsp;&nbsp;&nbsp; rank</P><P><SPAN style="font-size: 10pt;">-----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----------------------&nbsp;&nbsp;&nbsp;&nbsp; -----</SPAN></P><P><SPAN style="font-size: 10pt;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201304&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 10pt;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></P><P><SPAN style="font-size: 10pt;">12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201306&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">6789&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201307&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></P><P><SPAN style="font-size: 10pt;">6789&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 201308&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">How can I do this with enterprise guide or&nbsp; in proc SQL ?<BR /></SPAN></P></BODY></HTML> Fri, 27 Sep 2013 11:25:26 GMT https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95813#M257723 sayginf 2013-09-27T11:25:26Z Re: How to give Rank number in SAS Enterprise guide? https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95814#M257724 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Have a look at the following discussion <A __default_attr="175198" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/" modifiedtitle="true" title="Find Latest value using ROW_NUMBER OVER (PARTITION BY 'X' ORDER BY DATE) AS Rank in SAS&lt;br/&gt;"></A></P><P>SAS Enterprise Guide has a Rank Task to find in the Daata category</P></BODY></HTML> Fri, 27 Sep 2013 12:02:47 GMT https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95814#M257724 BrunoMueller 2013-09-27T12:02:47Z Re: How to give Rank number in SAS Enterprise guide? https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95815#M257725 <HTML><HEAD></HEAD><BODY><P>thank you very much,&nbsp; Rank task is very helpful to me</P></BODY></HTML> Fri, 27 Sep 2013 12:09:26 GMT https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95815#M257725 sayginf 2013-09-27T12:09:26Z Re: How to give Rank number in SAS Enterprise guide? https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95816#M257726 <HTML><HEAD></HEAD><BODY><P>There should be a Rank task within EG. I believe it uses PROC RANK, and should probably suit your needs.</P></BODY></HTML> Fri, 27 Sep 2013 12:16:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-give-Rank-number-in-SAS-Enterprise-guide/m-p/95816#M257726 LinusH 2013-09-27T12:16:13Z