https://communities.sas.com/t5/SAS-Programming/Calculate-no-of-days-between-observations/m-p/837575#M331180 <P>For the status change, use the LAG function. For the number of days, keep the first date in a RETAINed variable.</P> <P>How do you want to calculate the duration (what should be used as the end date)?</P> Sun, 09 Oct 2022 18:38:14 GMT Kurt_Bremser 2022-10-09T18:38:14Z https://communities.sas.com/t5/SAS-Programming/Calculate-no-of-days-between-observations/m-p/837570#M331179 <P>Hi ,</P> <P>&nbsp;</P> <P>I got below data and need to Calulate the number days each the status stayed. I need to populate the last two fileds ?</P> <P>&nbsp;</P> <P>I need flag when the status changes and number of days in each status . Please let me know if you need any further infomration . thanks&nbsp;</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD>Code</TD> <TD>ID</TD> <TD>Date</TD> <TD>Status</TD> <TD>Status Change Flag</TD> <TD>No of days in each status</TD> </TR> <TR> <TD>55</TD> <TD>ABC</TD> <TD>25-Jan-12</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>29</TD> <TD>ABC</TD> <TD>22-Mar-12</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>56</TD> <TD>ABC</TD> <TD>05-Jan-13</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>60</TD> <TD>ABC</TD> <TD>03-Feb-14</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>91</TD> <TD>ABC</TD> <TD>15-May-15</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>81</TD> <TD>ABC</TD> <TD>09-Oct-16</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>98</TD> <TD>ABC</TD> <TD>09-Dec-16</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>102</TD> <TD>ABC</TD> <TD>25-Jan-18</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>105</TD> <TD>ADR</TD> <TD>05-Jan-13</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>125</TD> <TD>ADR</TD> <TD>09-Oct-16</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>135</TD> <TD>ADR</TD> <TD>25-Jan-18</TD> <TD>N</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>155</TD> <TD>ADR</TD> <TD>05-May-19</TD> <TD>Y</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>168</TD> <TD>ADR</TD> <TD>15-Jun-20</TD> <TD>Y&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> <P>Thanks</P> Mon, 10 Oct 2022 06:09:48 GMT https://communities.sas.com/t5/SAS-Programming/Calculate-no-of-days-between-observations/m-p/837570#M331179 prattipati 2022-10-10T06:09:48Z https://communities.sas.com/t5/SAS-Programming/Calculate-no-of-days-between-observations/m-p/837575#M331180 <P>For the status change, use the LAG function. For the number of days, keep the first date in a RETAINed variable.</P> <P>How do you want to calculate the duration (what should be used as the end date)?</P> Sun, 09 Oct 2022 18:38:14 GMT https://communities.sas.com/t5/SAS-Programming/Calculate-no-of-days-between-observations/m-p/837575#M331180 Kurt_Bremser 2022-10-09T18:38:14Z