https://communities.sas.com/t5/SAS-Procedures/How-to-add-quot-time-quot-to-an-existing-DateTime-value/m-p/65626#M18715 hi, <BR /> <BR /> Just a quick Q, and I can't seem to find examples anywhere of someone doing this but.. the dataset I have has two colums<BR /> <BR /> date_time_start (yyyymmdd hhmmss) and duration (hh:mm:ss)<BR /> <BR /> We have a need to create a new column called date_time_end in yyyymmdd hhmmss that would ultimatly be date_time_start + duration<BR /> <BR /> how would one go about doing this in a data step? Thu, 19 Aug 2010 18:08:10 GMT deleted_user 2010-08-19T18:08:10Z https://communities.sas.com/t5/SAS-Procedures/How-to-add-quot-time-quot-to-an-existing-DateTime-value/m-p/65626#M18715 hi, <BR /> <BR /> Just a quick Q, and I can't seem to find examples anywhere of someone doing this but.. the dataset I have has two colums<BR /> <BR /> date_time_start (yyyymmdd hhmmss) and duration (hh:mm:ss)<BR /> <BR /> We have a need to create a new column called date_time_end in yyyymmdd hhmmss that would ultimatly be date_time_start + duration<BR /> <BR /> how would one go about doing this in a data step? Thu, 19 Aug 2010 18:08:10 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-add-quot-time-quot-to-an-existing-DateTime-value/m-p/65626#M18715 deleted_user 2010-08-19T18:08:10Z https://communities.sas.com/t5/SAS-Procedures/How-to-add-quot-time-quot-to-an-existing-DateTime-value/m-p/65627#M18716 You simply add the two variables together, or you could use the DHMS function and code placeholder "0" values for the "h" and "m" arguments. You are working with a duration that is seconds and your datetime variable is also "seconds...since 1/1/1960". So these two variables are compatible.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search arguments, this topic / post:<BR /> <BR /> using sas date variables site:sas.com<BR /> <BR /> dhms function site:sas.com Thu, 19 Aug 2010 18:22:40 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-add-quot-time-quot-to-an-existing-DateTime-value/m-p/65627#M18716 sbb 2010-08-19T18:22:40Z