topic Re: proc rank within ranks in SAS Programming

topic Re: proc rank within ranks in SAS Programming https://communities.sas.com/t5/SAS-Programming/proc-rank-within-ranks/m-p/172712#M33179 <HTML><HEAD></HEAD><BODY><P>Let var. A be a BY variable in the second PROC RANK call.</P></BODY></HTML> Sun, 16 Nov 2014 17:04:55 GMT Howles 2014-11-16T17:04:55Z proc rank within ranks https://communities.sas.com/t5/SAS-Programming/proc-rank-within-ranks/m-p/172711#M33178 <HTML><HEAD></HEAD><BODY><P></P><P>I already use the 'proc rank' to rank data based on criteria A, for example, stocks are ranked into 10 groups based on returns. Then I want to further rank the data within each group based on criteria B. How to rank such way in a dataset?</P><P></P><P></P><P>Thanks</P><P></P><P></P><P>  ID        DATE     A     B</P><P>109                      1     1</P><P>678                      1     2</P><P>567                      1     3</P><P>.....</P><P>189                      2     1</P><P>608                      2     2</P><P>597                      2     3</P><P>.....</P><P>489                      3     1</P><P>408                      3     2</P><P>997                      3     3</P><P>.....</P><P></P></BODY></HTML> Sat, 15 Nov 2014 05:58:11 GMT https://communities.sas.com/t5/SAS-Programming/proc-rank-within-ranks/m-p/172711#M33178 ZZB 2014-11-15T05:58:11Z Re: proc rank within ranks https://communities.sas.com/t5/SAS-Programming/proc-rank-within-ranks/m-p/172712#M33179 <HTML><HEAD></HEAD><BODY><P>Let var. A be a BY variable in the second PROC RANK call.</P></BODY></HTML> Sun, 16 Nov 2014 17:04:55 GMT https://communities.sas.com/t5/SAS-Programming/proc-rank-within-ranks/m-p/172712#M33179 Howles 2014-11-16T17:04:55Z