BookmarkSubscribeRSS Feed
deleted_user
Not applicable
hi,

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

date_time_start (yyyymmdd hhmmss) and duration (hh:mm:ss)

We have a need to create a new column called date_time_end in yyyymmdd hhmmss that would ultimatly be date_time_start + duration

how would one go about doing this in a data step?
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search arguments, this topic / post:

using sas date variables site:sas.com

dhms function site:sas.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 611 views
  • 0 likes
  • 2 in conversation