cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
EPANG1
‎12-01-2021
  • 9 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: how to separate variable into date and time

by Fluorite | Level 6 in SAS Programming
‎11-21-2021 05:57 PM
‎11-21-2021 05:57 PM
Apologies as I only see your answer in my inbox, but not displaying in the community forum. that's why I have copy the response again.  ... View more

Re: how to separate variable into date and time

by Fluorite | Level 6 in SAS Programming
‎11-21-2021 05:49 PM
‎11-21-2021 05:49 PM
Here is the solution. Thanks Koen. Re: how to separate variable into date and time data _NULL_; a='01JAN2021:03:20:55'dt; put a= datetime22.; b=datepart(a) ; put b= date9.; c=timepart(a) ; put c= time8.; run; /* end of program */ Koen ... View more

how to separate variable into date and time

by Fluorite | Level 6 in SAS Programming
‎11-21-2021 05:40 PM
‎11-21-2021 05:40 PM
Hi all,   Currently the variable is formated as datetime22.  like 01JAN2021:03:20:55.    How can I get the time out of this field in the output below ?   03:20:55    Thanks ... View more

calculate average for time in different format

by Fluorite | Level 6 in SAS Programming
‎11-12-2021 11:58 PM
‎11-12-2021 11:58 PM
Good afternoon,   I would like to calculate the average time for all records for the columns of  time_arrival and time_attend. However, one is display as character and one is display as time. How can I do this? Thanks       ... View more

Re: Need to calculate time difference from character format

by Fluorite | Level 6 in SAS Programming
‎11-10-2021 09:40 PM
‎11-10-2021 09:40 PM
the code works beautifully.  ... View more

Re: Need to calculate time difference from character format

by Fluorite | Level 6 in SAS Programming
‎11-10-2021 05:59 PM
‎11-10-2021 05:59 PM
the example for data spread into 2 days are as follow:   start time: 20191011234432AD end time: 20191012005325AD   I use substr (starttime,9,6) = 234432  and substr(endtime,9,6) = 005325   The output I need is 53 minutes 25 seconds plus 15minutes 28 seconds which gives the final answer as 01:08:53.    Hope this make sense.    ... View more

Re: Need to calculate time difference from character format

by Fluorite | Level 6 in SAS Programming
‎11-10-2021 05:52 PM
‎11-10-2021 05:52 PM
The answer I need is 00:12:04. ... View more

Re: Need to calculate time difference from character format

by Fluorite | Level 6 in SAS Programming
‎11-10-2021 05:25 PM
‎11-10-2021 05:25 PM
the answer I need is to count the time in seconds. So I can convert the answer into hours and minutes later. Also, if the time go over onto the next day, I need a condition statement in order to calculate the time.At the moment, the data is only set as character. ... View more

Need to calculate time difference from character format

by Fluorite | Level 6 in SAS Programming
‎11-10-2021 05:10 PM
‎11-10-2021 05:10 PM
Hi,    I have the data stored in character for start time and end time which represent yyyymmddhhmmss. eg date start time   20210218050525 ,   date end time 20210218051729 I use the substr function to extract the time as below:   start time 050525   end time 051729    I need to calculate the time difference.  If the date go over onto the next day. Is there a condition statement can be used ?       Thanks   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-01-2021 12:51 AM
Quick links