https://communities.sas.com/t5/SAS-Programming/setting-up-time-to-event-data-given-certain-conditions/m-p/837737#M331256 <P>I want to make a table with multiple observations per participant given certain conditions.</P><P>The conditions are:</P><P>1) the follow-up starts when event 1 occurs for the first time&nbsp;</P><P>2) The participant isn't included if event 1 does not occur.</P><P>3) the time to event is calculated between the first time for event 1 and the following firstevent 2.</P><P>4) If event 2 occurs prior to event 1, it isn't counted.</P><P>&nbsp;</P><P>So below is the example tables:</P><P>What I have</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>id</TD><TD>event1</TD><TD>event2</TD></TR><TR><TD>1</TD><TD>20100108</TD><TD>.</TD></TR><TR><TD>1</TD><TD>.</TD><TD>20110108</TD></TR><TR><TD>2</TD><TD>.</TD><TD>20110305</TD></TR><TR><TD>2</TD><TD>&nbsp;</TD><TD>20130110</TD></TR><TR><TD>3</TD><TD>.</TD><TD>20110510</TD></TR><TR><TD>3</TD><TD>&nbsp;</TD><TD>20140510</TD></TR><TR><TD>3</TD><TD>20160510</TD><TD>.</TD></TR><TR><TD>4</TD><TD>20100210</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>20100310</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>&nbsp;</TD><TD>20150220</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I want</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>id</TD><TD>event1</TD><TD>event2</TD><TD>censored</TD><TD>days</TD></TR><TR><TD>1</TD><TD>20100108</TD><TD>20110108</TD><TD>0</TD><TD>365.5</TD></TR><TR><TD>3</TD><TD>20160510</TD><TD>.</TD><TD>1</TD><TD>1827.5</TD></TR><TR><TD>4</TD><TD>20100210</TD><TD>20150220</TD><TD>0</TD><TD>1470</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could you please help me to write the code?&nbsp;</P><P>Thank you very much.</P> Mon, 10 Oct 2022 22:16:22 GMT Lily07 2022-10-10T22:16:22Z https://communities.sas.com/t5/SAS-Programming/setting-up-time-to-event-data-given-certain-conditions/m-p/837737#M331256 <P>I want to make a table with multiple observations per participant given certain conditions.</P><P>The conditions are:</P><P>1) the follow-up starts when event 1 occurs for the first time&nbsp;</P><P>2) The participant isn't included if event 1 does not occur.</P><P>3) the time to event is calculated between the first time for event 1 and the following firstevent 2.</P><P>4) If event 2 occurs prior to event 1, it isn't counted.</P><P>&nbsp;</P><P>So below is the example tables:</P><P>What I have</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>id</TD><TD>event1</TD><TD>event2</TD></TR><TR><TD>1</TD><TD>20100108</TD><TD>.</TD></TR><TR><TD>1</TD><TD>.</TD><TD>20110108</TD></TR><TR><TD>2</TD><TD>.</TD><TD>20110305</TD></TR><TR><TD>2</TD><TD>&nbsp;</TD><TD>20130110</TD></TR><TR><TD>3</TD><TD>.</TD><TD>20110510</TD></TR><TR><TD>3</TD><TD>&nbsp;</TD><TD>20140510</TD></TR><TR><TD>3</TD><TD>20160510</TD><TD>.</TD></TR><TR><TD>4</TD><TD>20100210</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>20100310</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>&nbsp;</TD><TD>20150220</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I want</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>id</TD><TD>event1</TD><TD>event2</TD><TD>censored</TD><TD>days</TD></TR><TR><TD>1</TD><TD>20100108</TD><TD>20110108</TD><TD>0</TD><TD>365.5</TD></TR><TR><TD>3</TD><TD>20160510</TD><TD>.</TD><TD>1</TD><TD>1827.5</TD></TR><TR><TD>4</TD><TD>20100210</TD><TD>20150220</TD><TD>0</TD><TD>1470</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Could you please help me to write the code?&nbsp;</P><P>Thank you very much.</P> Mon, 10 Oct 2022 22:16:22 GMT https://communities.sas.com/t5/SAS-Programming/setting-up-time-to-event-data-given-certain-conditions/m-p/837737#M331256 Lily07 2022-10-10T22:16:22Z https://communities.sas.com/t5/SAS-Programming/setting-up-time-to-event-data-given-certain-conditions/m-p/837966#M331342 <P>Why is ID 3 in the output?</P> Wed, 12 Oct 2022 00:26:10 GMT https://communities.sas.com/t5/SAS-Programming/setting-up-time-to-event-data-given-certain-conditions/m-p/837966#M331342 ChrisNZ 2022-10-12T00:26:10Z