https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504862#M135163 <P>HI,<BR /><BR />I have similar problem but here I am trying to keep all rows with different session for an ID . IF an ID have multiple rows with same session name then, keep the row with the earliest session begin date for an ID.<BR /><BR />For e.g for ID #3,5,7 having multiple rows with same session name, keep the row with the earliest begin date. For ID #6, with different session name, keep both the rows. Any suggestion?<BR /><BR /></P><TABLE><TBODY><TR><TD><STRONG>Date</STRONG></TD><TD><STRONG>ID</STRONG></TD><TD><STRONG>Session</STRONG></TD><TD><STRONG>SessionBeginDate</STRONG></TD><TD><STRONG>TotalDaysinSession</STRONG></TD><TD>Keep or Delete</TD></TR><TR><TD>2018-08</TD><TD>1</TD><TD>MMM</TD><TD>2018-08-13</TD><TD>63</TD><TD>Keep</TD></TR><TR><TD>2018-08</TD><TD>2</TD><TD>OOO</TD><TD>2018-08-22</TD><TD>40</TD><TD>Keep</TD></TR><TR><TD>2017-11</TD><TD>3</TD><TD>OOO</TD><TD>2017-11-30</TD><TD>199</TD><TD>Keep</TD></TR><TR><TD>2018-03</TD><TD>3</TD><TD>OOO</TD><TD>2018-03-02</TD><TD>199</TD><TD>&nbsp;</TD></TR><TR><TD>2017-10</TD><TD>3</TD><TD>OOO</TD><TD>2017-10-23</TD><TD>199</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>4</TD><TD>MMM</TD><TD>2018-03-07</TD><TD>41</TD><TD>Keep</TD></TR><TR><TD>2018-08</TD><TD>5</TD><TD>MMM</TD><TD>2018-08-07</TD><TD>48</TD><TD>Keep</TD></TR><TR><TD>2018-09</TD><TD>5</TD><TD>MMM</TD><TD>2018-09-08</TD><TD>48</TD><TD>&nbsp;</TD></TR><TR><TD>2018-07</TD><TD>6</TD><TD>MMM</TD><TD>2018-07-02</TD><TD>61</TD><TD>Keep</TD></TR><TR><TD>2017-03</TD><TD>6</TD><TD>OOO</TD><TD>2017-03-08</TD><TD>5</TD><TD>Keep</TD></TR><TR><TD>2017-10</TD><TD>7</TD><TD>OOO</TD><TD>2017-10-16</TD><TD>194</TD><TD>Keep</TD></TR><TR><TD>2017-12</TD><TD>7</TD><TD>OOO</TD><TD>2017-12-04</TD><TD>194</TD><TD>&nbsp;</TD></TR><TR><TD>2017-11</TD><TD>8</TD><TD>OOO</TD><TD>2017-11-20</TD><TD>244</TD><TD>Keep</TD></TR><TR><TD>2017-05</TD><TD>8</TD><TD>OOO</TD><TD>2017-05-12</TD><TD>244</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 16 Oct 2018 20:26:35 GMT d0816 2018-10-16T20:26:35Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504706#M135121 <P>I have following sample&nbsp;dataset&nbsp;that is&nbsp;sorted by ID and Class Start Date. For an "ID", I&nbsp;would like&nbsp;to keep those rows whenever ID has a NEW "Class Start Date" for the same or different "Class". When doing this, I want to keep the row with the earliest "Date".I have added a column to show which rows I&nbsp;need to keep for an ID. Any help is much appreciated. Thank You.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><STRONG>Date</STRONG></TD><TD><STRONG>ID</STRONG></TD><TD><STRONG>Class</STRONG></TD><TD><STRONG>Class Start Date</STRONG></TD><TD><STRONG>Class End Date</STRONG></TD><TD><STRONG>Days in Class </STRONG></TD><TD><STRONG>Months in College</STRONG></TD><TD><STRONG>Month Category</STRONG></TD><TD><STRONG>Keep or Delete</STRONG></TD></TR><TR><TD>2018-08</TD><TD>1</TD><TD>AAA</TD><TD>2018-08-13</TD><TD>9999-12-31</TD><TD>63</TD><TD>20</TD><TD>13-24 Months</TD><TD>Keep</TD></TR><TR><TD>2018-09</TD><TD>1</TD><TD>AAA</TD><TD>2018-08-13</TD><TD>9999-12-31</TD><TD>63</TD><TD>21</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-10</TD><TD>1</TD><TD>AAA</TD><TD>2018-08-13</TD><TD>9999-12-31</TD><TD>63</TD><TD>21</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-08</TD><TD>2</TD><TD>BBB</TD><TD>2018-08-22</TD><TD>2018-09-30</TD><TD>40</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2018-09</TD><TD>2</TD><TD>BBB</TD><TD>2018-08-22</TD><TD>2018-09-30</TD><TD>40</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-10</TD><TD>3</TD><TD>CCC</TD><TD>2017-10-02</TD><TD>2017-10-22</TD><TD>21</TD><TD>0</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-10</TD><TD>3</TD><TD>BBB</TD><TD>2017-10-23</TD><TD>2017-11-28</TD><TD>37</TD><TD>0</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-11</TD><TD>3</TD><TD>BBB</TD><TD>2017-10-23</TD><TD>2017-11-28</TD><TD>37</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-11</TD><TD>3</TD><TD>BBB</TD><TD>2017-11-30</TD><TD>2018-02-28</TD><TD>91</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-12</TD><TD>3</TD><TD>BBB</TD><TD>2017-11-30</TD><TD>2018-02-28</TD><TD>91</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-01</TD><TD>3</TD><TD>BBB</TD><TD>2017-11-30</TD><TD>2018-02-28</TD><TD>91</TD><TD>3</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-02</TD><TD>3</TD><TD>BBB</TD><TD>2017-11-30</TD><TD>2018-02-28</TD><TD>91</TD><TD>4</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>3</TD><TD>BBB</TD><TD>2018-03-02</TD><TD>2018-05-11</TD><TD>71</TD><TD>4</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2018-04</TD><TD>3</TD><TD>BBB</TD><TD>2018-03-02</TD><TD>2018-05-11</TD><TD>71</TD><TD>6</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-05</TD><TD>3</TD><TD>BBB</TD><TD>2018-03-02</TD><TD>2018-05-11</TD><TD>71</TD><TD>7</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-08</TD><TD>4</TD><TD>AAA</TD><TD>2018-08-07</TD><TD>2018-08-31</TD><TD>25</TD><TD>8</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2018-09</TD><TD>4</TD><TD>AAA</TD><TD>2018-09-08</TD><TD>2018-09-30</TD><TD>23</TD><TD>9</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-03</TD><TD>5</TD><TD>BBB</TD><TD>2017-03-08</TD><TD>2017-03-12</TD><TD>5</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-03</TD><TD>5</TD><TD>CCC</TD><TD>2017-03-13</TD><TD>2017-05-31</TD><TD>80</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-04</TD><TD>5</TD><TD>CCC</TD><TD>2017-03-13</TD><TD>2017-05-31</TD><TD>80</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-05</TD><TD>5</TD><TD>CCC</TD><TD>2017-03-13</TD><TD>2017-05-31</TD><TD>80</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-07</TD><TD>5</TD><TD>AAA</TD><TD>2018-07-02</TD><TD>2018-08-31</TD><TD>61</TD><TD>8</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2018-08</TD><TD>5</TD><TD>AAA</TD><TD>2018-07-02</TD><TD>2018-08-31</TD><TD>61</TD><TD>9</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-10</TD><TD>6</TD><TD>BBB</TD><TD>2017-10-16</TD><TD>2017-11-30</TD><TD>46</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-11</TD><TD>6</TD><TD>BBB</TD><TD>2017-10-16</TD><TD>2017-11-30</TD><TD>46</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-12</TD><TD>6</TD><TD>BBB</TD><TD>2017-12-04</TD><TD>2018-04-30</TD><TD>148</TD><TD>3</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2018-01</TD><TD>6</TD><TD>BBB</TD><TD>2017-12-04</TD><TD>2018-04-30</TD><TD>148</TD><TD>4</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-02</TD><TD>6</TD><TD>BBB</TD><TD>2017-12-04</TD><TD>2018-04-30</TD><TD>148</TD><TD>5</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>6</TD><TD>BBB</TD><TD>2017-12-04</TD><TD>2018-04-30</TD><TD>148</TD><TD>6</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-04</TD><TD>6</TD><TD>BBB</TD><TD>2017-12-04</TD><TD>2018-04-30</TD><TD>148</TD><TD>7</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-01</TD><TD>7</TD><TD>CCC</TD><TD>2018-01-12</TD><TD>2018-01-31</TD><TD>20</TD><TD>0</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-03</TD><TD>8</TD><TD>CCC</TD><TD>2017-03-15</TD><TD>2017-05-11</TD><TD>58</TD><TD>0</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-04</TD><TD>8</TD><TD>CCC</TD><TD>2017-03-15</TD><TD>2017-05-11</TD><TD>58</TD><TD>0</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-05</TD><TD>8</TD><TD>CCC</TD><TD>2017-03-15</TD><TD>2017-05-11</TD><TD>58</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-05</TD><TD>8</TD><TD>BBB</TD><TD>2017-05-12</TD><TD>2017-08-31</TD><TD>112</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-06</TD><TD>8</TD><TD>BBB</TD><TD>2017-05-12</TD><TD>2017-08-31</TD><TD>112</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-07</TD><TD>8</TD><TD>BBB</TD><TD>2017-05-12</TD><TD>2017-08-31</TD><TD>112</TD><TD>3</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-08</TD><TD>8</TD><TD>BBB</TD><TD>2017-05-12</TD><TD>2017-08-31</TD><TD>112</TD><TD>4</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-11</TD><TD>8</TD><TD>BBB</TD><TD>2017-11-20</TD><TD>2018-03-31</TD><TD>132</TD><TD>5</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-12</TD><TD>8</TD><TD>BBB</TD><TD>2017-11-20</TD><TD>2018-03-31</TD><TD>132</TD><TD>6</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-01</TD><TD>8</TD><TD>BBB</TD><TD>2017-11-20</TD><TD>2018-03-31</TD><TD>132</TD><TD>7</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-02</TD><TD>8</TD><TD>BBB</TD><TD>2017-11-20</TD><TD>2018-03-31</TD><TD>132</TD><TD>8</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>8</TD><TD>BBB</TD><TD>2017-11-20</TD><TD>2018-03-31</TD><TD>132</TD><TD>8</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-11</TD><TD>9</TD><TD>AAA</TD><TD>2017-11-10</TD><TD>2017-12-31</TD><TD>52</TD><TD>12</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-12</TD><TD>9</TD><TD>AAA</TD><TD>2017-11-10</TD><TD>2017-12-31</TD><TD>52</TD><TD>13</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-04</TD><TD>9</TD><TD>AAA</TD><TD>2018-04-30</TD><TD>2018-07-05</TD><TD>67</TD><TD>16</TD><TD>13-24 Months</TD><TD>Keep</TD></TR><TR><TD>2018-05</TD><TD>9</TD><TD>AAA</TD><TD>2018-04-30</TD><TD>2018-07-05</TD><TD>67</TD><TD>17</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-06</TD><TD>9</TD><TD>AAA</TD><TD>2018-04-30</TD><TD>2018-07-05</TD><TD>67</TD><TD>18</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-07</TD><TD>9</TD><TD>AAA</TD><TD>2018-04-30</TD><TD>2018-07-05</TD><TD>67</TD><TD>19</TD><TD>13-24 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>72</TD><TD>61+ Months</TD><TD>Keep</TD></TR><TR><TD>2018-04</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>73</TD><TD>61+ Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-05</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>74</TD><TD>61+ Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-06</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>75</TD><TD>61+ Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-07</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>76</TD><TD>61+ Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-08</TD><TD>10</TD><TD>AAA</TD><TD>2018-03-26</TD><TD>2018-08-31</TD><TD>159</TD><TD>77</TD><TD>61+ Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-09</TD><TD>10</TD><TD>AAA</TD><TD>2018-09-03</TD><TD>2018-09-05</TD><TD>3</TD><TD>78</TD><TD>61+ Months</TD><TD>Keep</TD></TR><TR><TD>2017-06</TD><TD>11</TD><TD>BBB</TD><TD>2017-06-05</TD><TD>2017-06-30</TD><TD>26</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-10</TD><TD>11</TD><TD>CCC</TD><TD>2017-10-23</TD><TD>2018-01-31</TD><TD>101</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-11</TD><TD>11</TD><TD>CCC</TD><TD>2017-10-23</TD><TD>2018-01-31</TD><TD>101</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-12</TD><TD>11</TD><TD>CCC</TD><TD>2017-10-23</TD><TD>2018-01-31</TD><TD>101</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2018-01</TD><TD>11</TD><TD>CCC</TD><TD>2017-10-23</TD><TD>2018-01-31</TD><TD>101</TD><TD>1</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-05</TD><TD>12</TD><TD>BBB</TD><TD>2017-05-30</TD><TD>2017-06-04</TD><TD>6</TD><TD>1</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-06</TD><TD>12</TD><TD>BBB</TD><TD>2017-05-30</TD><TD>2017-06-04</TD><TD>6</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR><TR><TD>2017-06</TD><TD>12</TD><TD>CCC</TD><TD>2017-06-05</TD><TD>2017-07-28</TD><TD>54</TD><TD>2</TD><TD>0-12 Months</TD><TD>Keep</TD></TR><TR><TD>2017-07</TD><TD>12</TD><TD>CCC</TD><TD>2017-06-05</TD><TD>2017-07-28</TD><TD>54</TD><TD>2</TD><TD>0-12 Months</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 16 Oct 2018 13:21:16 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504706#M135121 d0816 2018-10-16T13:21:16Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504711#M135123 <P>Sort by id, &lt;class start date&gt; and date. Then do a data step with by id and &lt;class start date&gt;, and use a subsetting if first.&lt;class start date&gt;</P> <P>Insert the real names ("class start date" is not a valid SAS name).</P> Tue, 16 Oct 2018 13:41:15 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504711#M135123 Kurt_Bremser 2018-10-16T13:41:15Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504732#M135126 <P>Thank you so much. It worked.</P> Tue, 16 Oct 2018 14:33:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504732#M135126 d0816 2018-10-16T14:33:04Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504862#M135163 <P>HI,<BR /><BR />I have similar problem but here I am trying to keep all rows with different session for an ID . IF an ID have multiple rows with same session name then, keep the row with the earliest session begin date for an ID.<BR /><BR />For e.g for ID #3,5,7 having multiple rows with same session name, keep the row with the earliest begin date. For ID #6, with different session name, keep both the rows. Any suggestion?<BR /><BR /></P><TABLE><TBODY><TR><TD><STRONG>Date</STRONG></TD><TD><STRONG>ID</STRONG></TD><TD><STRONG>Session</STRONG></TD><TD><STRONG>SessionBeginDate</STRONG></TD><TD><STRONG>TotalDaysinSession</STRONG></TD><TD>Keep or Delete</TD></TR><TR><TD>2018-08</TD><TD>1</TD><TD>MMM</TD><TD>2018-08-13</TD><TD>63</TD><TD>Keep</TD></TR><TR><TD>2018-08</TD><TD>2</TD><TD>OOO</TD><TD>2018-08-22</TD><TD>40</TD><TD>Keep</TD></TR><TR><TD>2017-11</TD><TD>3</TD><TD>OOO</TD><TD>2017-11-30</TD><TD>199</TD><TD>Keep</TD></TR><TR><TD>2018-03</TD><TD>3</TD><TD>OOO</TD><TD>2018-03-02</TD><TD>199</TD><TD>&nbsp;</TD></TR><TR><TD>2017-10</TD><TD>3</TD><TD>OOO</TD><TD>2017-10-23</TD><TD>199</TD><TD>&nbsp;</TD></TR><TR><TD>2018-03</TD><TD>4</TD><TD>MMM</TD><TD>2018-03-07</TD><TD>41</TD><TD>Keep</TD></TR><TR><TD>2018-08</TD><TD>5</TD><TD>MMM</TD><TD>2018-08-07</TD><TD>48</TD><TD>Keep</TD></TR><TR><TD>2018-09</TD><TD>5</TD><TD>MMM</TD><TD>2018-09-08</TD><TD>48</TD><TD>&nbsp;</TD></TR><TR><TD>2018-07</TD><TD>6</TD><TD>MMM</TD><TD>2018-07-02</TD><TD>61</TD><TD>Keep</TD></TR><TR><TD>2017-03</TD><TD>6</TD><TD>OOO</TD><TD>2017-03-08</TD><TD>5</TD><TD>Keep</TD></TR><TR><TD>2017-10</TD><TD>7</TD><TD>OOO</TD><TD>2017-10-16</TD><TD>194</TD><TD>Keep</TD></TR><TR><TD>2017-12</TD><TD>7</TD><TD>OOO</TD><TD>2017-12-04</TD><TD>194</TD><TD>&nbsp;</TD></TR><TR><TD>2017-11</TD><TD>8</TD><TD>OOO</TD><TD>2017-11-20</TD><TD>244</TD><TD>Keep</TD></TR><TR><TD>2017-05</TD><TD>8</TD><TD>OOO</TD><TD>2017-05-12</TD><TD>244</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 16 Oct 2018 20:26:35 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504862#M135163 d0816 2018-10-16T20:26:35Z https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504974#M135209 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/155169">@d0816</a>&nbsp;wrote:<BR /> <P>HI,<BR /><BR />I have similar problem but here I am trying to keep all rows with different session for an ID . IF an ID have multiple rows with same session name then, keep the row with the earliest session begin date for an ID.<BR /><BR />For e.g for ID #3,5,7 having multiple rows with same session name, keep the row with the earliest begin date. For ID #6, with different session name, keep both the rows. Any suggestion?<BR /><BR /></P> <TABLE> <TBODY> <TR> <TD><STRONG>Date</STRONG></TD> <TD><STRONG>ID</STRONG></TD> <TD><STRONG>Session</STRONG></TD> <TD><STRONG>SessionBeginDate</STRONG></TD> <TD><STRONG>TotalDaysinSession</STRONG></TD> <TD>Keep or Delete</TD> </TR> <TR> <TD>2018-08</TD> <TD>1</TD> <TD>MMM</TD> <TD>2018-08-13</TD> <TD>63</TD> <TD>Keep</TD> </TR> <TR> <TD>2018-08</TD> <TD>2</TD> <TD>OOO</TD> <TD>2018-08-22</TD> <TD>40</TD> <TD>Keep</TD> </TR> <TR> <TD>2017-11</TD> <TD>3</TD> <TD>OOO</TD> <TD>2017-11-30</TD> <TD>199</TD> <TD>Keep</TD> </TR> <TR> <TD>2018-03</TD> <TD>3</TD> <TD>OOO</TD> <TD>2018-03-02</TD> <TD>199</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2017-10</TD> <TD>3</TD> <TD>OOO</TD> <TD>2017-10-23</TD> <TD>199</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2018-03</TD> <TD>4</TD> <TD>MMM</TD> <TD>2018-03-07</TD> <TD>41</TD> <TD>Keep</TD> </TR> <TR> <TD>2018-08</TD> <TD>5</TD> <TD>MMM</TD> <TD>2018-08-07</TD> <TD>48</TD> <TD>Keep</TD> </TR> <TR> <TD>2018-09</TD> <TD>5</TD> <TD>MMM</TD> <TD>2018-09-08</TD> <TD>48</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2018-07</TD> <TD>6</TD> <TD>MMM</TD> <TD>2018-07-02</TD> <TD>61</TD> <TD>Keep</TD> </TR> <TR> <TD>2017-03</TD> <TD>6</TD> <TD>OOO</TD> <TD>2017-03-08</TD> <TD>5</TD> <TD>Keep</TD> </TR> <TR> <TD>2017-10</TD> <TD>7</TD> <TD>OOO</TD> <TD>2017-10-16</TD> <TD>194</TD> <TD>Keep</TD> </TR> <TR> <TD>2017-12</TD> <TD>7</TD> <TD>OOO</TD> <TD>2017-12-04</TD> <TD>194</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2017-11</TD> <TD>8</TD> <TD>OOO</TD> <TD>2017-11-20</TD> <TD>244</TD> <TD>Keep</TD> </TR> <TR> <TD>2017-05</TD> <TD>8</TD> <TD>OOO</TD> <TD>2017-05-12</TD> <TD>244</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <HR /></BLOCKQUOTE> <P>Use the same method as previous, just with different variables (session!) in the by statements and the first. condition.</P> Wed, 17 Oct 2018 06:49:32 GMT https://communities.sas.com/t5/SAS-Programming/How-to-keep-rows-conditionally-for-an-ID/m-p/504974#M135209 Kurt_Bremser 2018-10-17T06:49:32Z