topic Re: Arrival and Departure Delay in SAS Programming

Arrival and Departure Delay

abhi18 — Tue, 30 Jan 2018 06:48:35 GMT

Hi, So I have a dataset of Flights. In that i have Variables like Schedule_dep, Schedule_arr, actual_dep, actual_arr and I have to calculate delay from these variables.

The problem here is whenever the date changes for eg:-

Schedule_dep:- 11:45 Pm

Actual_dep:- 01:00 Am

The result that I'm getting is something -2315 instead of 75 minutes.

How to resolve this Plz help.

Re: Arrival and Departure Delay

error_prone — Tue, 30 Jan 2018 07:28:43 GMT

Please post example data. It is not clear of what type the variables are. How do you calculate the difference? Have you tried the appropriate function?

Re: Arrival and Departure Delay

PeterClemmensen — Tue, 30 Jan 2018 07:36:57 GMT

What does your code look like now?

Re: Arrival and Departure Delay

abhi18 — Tue, 30 Jan 2018 07:38:26 GMT

Data types are:-

Schedule and Actual arrival :- Numeric

The function that I'm using is Intck(), So I'm getting the desired output for rest of the observations only those are creating a problem in which the date for actual_dep changes after 00:00 HRS

Re: Arrival and Departure Delay

abhi18 — Tue, 30 Jan 2018 07:43:52 GMT

Using this code to get the delay:-

dep_delay = intck('minute',scd_dep_time,dept_time);

Re: Arrival and Departure Delay

PeterClemmensen — Tue, 30 Jan 2018 07:51:44 GMT

If you do not bring the dates into the calculations, you will not be able to get the desired result. What does your data look like? Do you have a date variable as well?

Re: Arrival and Departure Delay

Kurt_Bremser — Tue, 30 Jan 2018 07:52:15 GMT

Your problem comes from the fact that you are working with time values, while you should be working with datetime values.

I take it that your dataset also contains dates; you can easily create datetimes fro the date and time values.

Please show the code you are using now, and a quick overview of the variables in your dataset, with type and formats.

Re: Arrival and Departure Delay

Satish_Parida — Tue, 30 Jan 2018 07:53:35 GMT

You need to have date with time, to get the exact result.

If you have the date of departure with you, then multiply it by 3600 and then add it to time of departure. Same with arrival.

Then you do not need to use any function just subtraction will give you the difference of time in seconds.
Afterwards you can use formats to display them as you want.

Re: Arrival and Departure Delay

Kurt_Bremser — Tue, 30 Jan 2018 07:57:49 GMT

@Satish_Parida wrote:

You need to have date with time, to get the exact result.

If you have the date of departure with you, then multiply it by 3600 and then add it to time of departure. Same with arrival.

Then you do not need to use any function just subtraction will give you the difference of time in seconds.
Afterwards you can use formats to display them as you want.

Correction: a day has 86400 seconds, so the date needs to be multiplied by that.

Re: Arrival and Departure Delay

PeterClemmensen — Tue, 30 Jan 2018 08:15:40 GMT

If you have a date and a time for both the acheduled and the actual departure time, then convert to datetime values and use the INTCK function on those

data have;
input Schedule_dep_date:date9. Schedule_dep_time:time. Actual_dep_date:date9. Actual_dep_time:time.;
format Schedule_dep_date Actual_dep_date date9. Schedule_dep_time Actual_dep_time time.;
datalines;
30jan2018 11:45PM 31jan2018 01:00AM
;

data want;
   set have;
   Schedule_dep_dt=dhms(Schedule_dep_date,0,0,Schedule_dep_time);
   Actual_dep_dt=dhms(Actual_dep_date,0,0,Actual_dep_time);
   dep_delay=intck('minute',Schedule_dep_dt, Actual_dep_dt);
   format dt datetime.;
run;

Re: Arrival and Departure Delay

abhi18 — Tue, 30 Jan 2018 08:04:33 GMT

I do have the date variable...Data shared below:-

Obs Date Scd_dep arr_time delay

6210

12/03/2013

8:35:00 PM

8:53:00 PM

6211

11/11/2013

2:59:00 PM

2:56:00 PM

-3

6212

12/19/2013

8:27:00 PM

8:22:00 PM

-5

6213

11/12/2013

8:30:00 AM

10:06:00 AM

6214

12/21/2013

2:59:00 PM

3:27:00 PM

6215

12/10/2013

8:35:00 PM

8:31:00 PM

-4

6216

02/15/2013

3:05:00 PM

3:03:00 PM

-2

6217

12/05/2013

8:35:00 PM

12:27:00 AM

-1208

Re: Arrival and Departure Delay

abhi18 — Tue, 30 Jan 2018 08:10:23 GMT

Understood...Thanks 🙂

Re: Arrival and Departure Delay

Kurt_Bremser — Tue, 30 Jan 2018 08:12:15 GMT

To get precise results, you need to have dates for scheduled and actual time. Otherwise, you'll have to make guesses (if the number is far enough in the negative range, add 1440 (number of minutes for a day)). But that will obviously fail when the delay exceeds one day.