topic rank for group in SAS Programming https://communities.sas.com/t5/SAS-Programming/rank-for-group/m-p/570459#M160853 <P>I have following tables.</P><P>&nbsp;</P><PRE><CODE class=" language-sas">data Table1; input product $ start_date :date7. end_date:date7. Price; format start_date end_date date9.; datalines; p1 01Jan17 18Jan18 15 p1 19Jan18 15Jul18 30 p1 16Jul18 31Mar19 24 p2 08Jan17 31Dec17 17 p2 01Jan18 15Mar18 19 p2 26Jul18 31Mar19 18 ;</CODE></PRE><TABLE><TBODY><TR><TD>Product</TD><TD>sd</TD><TD>ed</TD><TD>price</TD></TR><TR><TD>p1</TD><TD>01-Jan-17</TD><TD>18-Jan-18</TD><TD>15</TD></TR><TR><TD>p1</TD><TD>19-Jan-18</TD><TD>15-Jul-18</TD><TD>30</TD></TR><TR><TD>p1</TD><TD>16-Jul-18</TD><TD>31-Mar-19</TD><TD>24</TD></TR><TR><TD>p2</TD><TD>08-Jan-17</TD><TD>31-Dec-17</TD><TD>17</TD></TR><TR><TD>p2</TD><TD>01-Jan-18</TD><TD>15-Mar-18</TD><TD>19</TD></TR><TR><TD>p2</TD><TD>26-Jul-18</TD><TD>31-Mar-19</TD><TD>18</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I wanted to rank product, means p1 is rank 1 and p2 is rank 2.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>sd</TD><TD>ed</TD><TD>price</TD><TD>Rank</TD></TR><TR><TD>p1</TD><TD>01-Jan-17</TD><TD>18-Jan-18</TD><TD>15</TD><TD>1</TD></TR><TR><TD>p1</TD><TD>19-Jan-18</TD><TD>15-Jul-18</TD><TD>30</TD><TD>1</TD></TR><TR><TD>p1</TD><TD>16-Jul-18</TD><TD>31-Mar-19</TD><TD>24</TD><TD>1</TD></TR><TR><TD>p2</TD><TD>08-Jan-17</TD><TD>31-Dec-17</TD><TD>17</TD><TD>2</TD></TR><TR><TD>p2</TD><TD>01-Jan-18</TD><TD>15-Mar-18</TD><TD>19</TD><TD>2</TD></TR><TR><TD>p2</TD><TD>26-Jul-18</TD><TD>31-Mar-19</TD><TD>18</TD><TD>2</TD></TR></TBODY></TABLE> Tue, 02 Jul 2019 09:14:23 GMT Srigyan 2019-07-02T09:14:23Z rank for group https://communities.sas.com/t5/SAS-Programming/rank-for-group/m-p/570459#M160853 <P>I have following tables.</P><P>&nbsp;</P><PRE><CODE class=" language-sas">data Table1; input product $ start_date :date7. end_date:date7. Price; format start_date end_date date9.; datalines; p1 01Jan17 18Jan18 15 p1 19Jan18 15Jul18 30 p1 16Jul18 31Mar19 24 p2 08Jan17 31Dec17 17 p2 01Jan18 15Mar18 19 p2 26Jul18 31Mar19 18 ;</CODE></PRE><TABLE><TBODY><TR><TD>Product</TD><TD>sd</TD><TD>ed</TD><TD>price</TD></TR><TR><TD>p1</TD><TD>01-Jan-17</TD><TD>18-Jan-18</TD><TD>15</TD></TR><TR><TD>p1</TD><TD>19-Jan-18</TD><TD>15-Jul-18</TD><TD>30</TD></TR><TR><TD>p1</TD><TD>16-Jul-18</TD><TD>31-Mar-19</TD><TD>24</TD></TR><TR><TD>p2</TD><TD>08-Jan-17</TD><TD>31-Dec-17</TD><TD>17</TD></TR><TR><TD>p2</TD><TD>01-Jan-18</TD><TD>15-Mar-18</TD><TD>19</TD></TR><TR><TD>p2</TD><TD>26-Jul-18</TD><TD>31-Mar-19</TD><TD>18</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I wanted to rank product, means p1 is rank 1 and p2 is rank 2.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>sd</TD><TD>ed</TD><TD>price</TD><TD>Rank</TD></TR><TR><TD>p1</TD><TD>01-Jan-17</TD><TD>18-Jan-18</TD><TD>15</TD><TD>1</TD></TR><TR><TD>p1</TD><TD>19-Jan-18</TD><TD>15-Jul-18</TD><TD>30</TD><TD>1</TD></TR><TR><TD>p1</TD><TD>16-Jul-18</TD><TD>31-Mar-19</TD><TD>24</TD><TD>1</TD></TR><TR><TD>p2</TD><TD>08-Jan-17</TD><TD>31-Dec-17</TD><TD>17</TD><TD>2</TD></TR><TR><TD>p2</TD><TD>01-Jan-18</TD><TD>15-Mar-18</TD><TD>19</TD><TD>2</TD></TR><TR><TD>p2</TD><TD>26-Jul-18</TD><TD>31-Mar-19</TD><TD>18</TD><TD>2</TD></TR></TBODY></TABLE> Tue, 02 Jul 2019 09:14:23 GMT https://communities.sas.com/t5/SAS-Programming/rank-for-group/m-p/570459#M160853 Srigyan 2019-07-02T09:14:23Z Re: rank for group https://communities.sas.com/t5/SAS-Programming/rank-for-group/m-p/570464#M160856 <PRE><CODE class=" language-sas">data want; set Table1; by product; if first.product then Rank+1; run;</CODE></PRE> Tue, 02 Jul 2019 09:25:35 GMT https://communities.sas.com/t5/SAS-Programming/rank-for-group/m-p/570464#M160856 PeterClemmensen 2019-07-02T09:25:35Z