https://communities.sas.com/t5/New-SAS-User/Creating-a-new-date-from-two-variables-in-SAS/m-p/649945#M22316 <P>use the MDY()&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">start_date = mdy(month, 1, year); duration = intck('month', start_date, event_date); </CODE></PRE> <P>Look up INTCK() and in particular the fourth parameter.</P> Fri, 22 May 2020 16:19:44 GMT Reeza 2020-05-22T16:19:44Z https://communities.sas.com/t5/New-SAS-User/Creating-a-new-date-from-two-variables-in-SAS/m-p/649943#M22315 <P>Hi, I am working on a Cox Regression Model and am having trouble formatting my date to event. I have two variables showing the month of the event (DOD_M) and the year (DOD_Y). The month is formatted as a numeric variable (1-12), and the year is a numeric four digit variable (1995-2018). I would like to eventually create a variable that shows the time to event from enrollment in the study (5/1/1995) to the event, in months. What is the easiest way to do this? Thanks!</P> Fri, 22 May 2020 16:12:51 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-new-date-from-two-variables-in-SAS/m-p/649943#M22315 amng 2020-05-22T16:12:51Z https://communities.sas.com/t5/New-SAS-User/Creating-a-new-date-from-two-variables-in-SAS/m-p/649945#M22316 <P>use the MDY()&nbsp;</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">start_date = mdy(month, 1, year); duration = intck('month', start_date, event_date); </CODE></PRE> <P>Look up INTCK() and in particular the fourth parameter.</P> Fri, 22 May 2020 16:19:44 GMT https://communities.sas.com/t5/New-SAS-User/Creating-a-new-date-from-two-variables-in-SAS/m-p/649945#M22316 Reeza 2020-05-22T16:19:44Z