topic Re: Convert start time to a differ time in SAS Procedures

Convert start time to a differ time

Gil_ — Tue, 01 May 2018 21:09:37 GMT

I have a table that has a start time which is a datetime field ... I need to convert the start time to a morning time if the original eq 22:30. I need it to change time to 08:00 and day would be the following day
For example

Start time new time
29Apr18 22:30:00. 30Apr18 08:00:00

29Apr18 01:00:00. 30Apr18 08:00:00

Re: Convert start time to a differ time

Gil_ — Tue, 01 May 2018 21:13:53 GMT

The start time could vary anyyhing = greater than 22:30

Re: Convert start time to a differ time

novinosrin — Tue, 01 May 2018 21:22:53 GMT

data want;
starttime='29Apr18 22:30:00'dt;
if timepart(starttime)='22:30't then starttime=dhms(datepart(intnx('dtDay', starttime, 1)),8,0,0);
 format starttime datetime20.;run;

Re: Convert start time to a differ time

ballardw — Tue, 01 May 2018 21:42:04 GMT

@Gil_ wrote:
The start time could vary anyyhing = greater than 22:30

But your example

29Apr18 01:00:00. 30Apr18 08:00:00

I much less than 22:30. Was that a typo of some flavor.

Possibly intending

  30Apr18 01:00:00. 30Apr18 08:00:00

Which would likely mean that your rule is "any time after 22:30 on one day gets advanced to 08:00 the next day

and any time prior to 08:00 gets set to 08:00 for the same day".

Example of the above rule:

data want;
   input starttime datetime.;
   format starttime datetime.;
   if timepart(starttime) ge '22:30't then wanttime=dhms(datepart(starttime)+1,8,0,0);
   else if timepart(starttime) < '08:00't then wanttime=dhms(datepart(starttime),8,0,0);
   else wanttime=starttime;
   format wanttime datetime.;
datalines;
29Apr18:22:30:00
30Apr18:01:00:00
30Apr18:12:00:00
;
run;

Re: Convert start time to a differ time

Gil_ — Tue, 01 May 2018 21:48:39 GMT

Thank you