https://communities.sas.com/t5/SAS-Programming/How-to-use-retain-function-to-retain-the-end-date-where-AEOUT-is/m-p/747290#M234521 <P>Could be solved by using proc sql with having-clause or by setting and retaining a flag if the condition is met and using output-statement conditionally, but that would require that the no obs has to be written to the result, that is before the condition is met.</P> <P>&nbsp;</P> <P>If you need further help, please post the data you have in usable form (data step with datalines) and show the expected output.</P> Fri, 11 Jun 2021 07:46:13 GMT andreas_lds 2021-06-11T07:46:13Z https://communities.sas.com/t5/SAS-Programming/How-to-use-retain-function-to-retain-the-end-date-where-AEOUT-is/m-p/747288#M234520 <P>Condition 1: If AEOUT = Fatal, then output all AE's where<BR />AESTDAT is on or after that Fatal AEENDAT</P> Fri, 11 Jun 2021 07:10:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-use-retain-function-to-retain-the-end-date-where-AEOUT-is/m-p/747288#M234520 Manogna1231 2021-06-11T07:10:29Z https://communities.sas.com/t5/SAS-Programming/How-to-use-retain-function-to-retain-the-end-date-where-AEOUT-is/m-p/747290#M234521 <P>Could be solved by using proc sql with having-clause or by setting and retaining a flag if the condition is met and using output-statement conditionally, but that would require that the no obs has to be written to the result, that is before the condition is met.</P> <P>&nbsp;</P> <P>If you need further help, please post the data you have in usable form (data step with datalines) and show the expected output.</P> Fri, 11 Jun 2021 07:46:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-use-retain-function-to-retain-the-end-date-where-AEOUT-is/m-p/747290#M234521 andreas_lds 2021-06-11T07:46:13Z