https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558991#M10214 <P>Show us a portion of your data, following this method:&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> Wed, 15 May 2019 15:02:04 GMT PaigeMiller 2019-05-15T15:02:04Z https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558986#M10213 <P>Hi all,</P><P>I'm trying to write a SAS program to find the most recent dose date prior to the AE start date.&nbsp;</P><P>&nbsp;</P><P>In the exposure data, some all subjects are having the same number of exposure visits. Also in AE data, a subject can have multiple AE onset date.</P><P>&nbsp;</P><P>So how should I write my program so that I can find the most recent dosing date prior to each AE onset date?</P><P>&nbsp;</P><P>Many thanks!!</P> Wed, 15 May 2019 14:58:27 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558986#M10213 yahoo0806 2019-05-15T14:58:27Z https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558991#M10214 <P>Show us a portion of your data, following this method:&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712" target="_blank">https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712</A></P> Wed, 15 May 2019 15:02:04 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558991#M10214 PaigeMiller 2019-05-15T15:02:04Z https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558993#M10215 <P>Please supply example data (in usable form, a data step with datalines), and what you expect to get out of it. Post your data step code by using the "little running man" icon.</P> Wed, 15 May 2019 15:03:14 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/558993#M10215 Kurt_Bremser 2019-05-15T15:03:14Z https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/559313#M10271 <P>Thank you I actually figured out how to do it: need to transpose the data first, then use array to pick up.</P> Thu, 16 May 2019 13:59:41 GMT https://communities.sas.com/t5/New-SAS-User/How-to-find-the-most-recent-dose-date-prior-to-AE-start-date/m-p/559313#M10271 yahoo0806 2019-05-16T13:59:41Z