topic Evaluating time increments between records for same phone number in SAS Programming

Evaluating time increments between records for same phone number

Elliott — Wed, 04 Mar 2015 22:46:12 GMT

I need some help, not even sure where to start.

I have transactional data, I need to read through the records for each phone number and determine the time increment between each call to make sure it is outside allowable minimum number of minutes.

Each phone number could only have one call or multiple.

I have no idea how to do this, any assistance will be greatly appreciated.

thank you,

Re: Evaluating time increments between records for same phone number

Reeza — Wed, 04 Mar 2015 22:56:14 GMT

You need to post sample data.

In general use the dif function and then First/Last processing.

Use the First.phone_number to set the difference to missing.

Re: Evaluating time increments between records for same phone number

art297 — Wed, 04 Mar 2015 22:56:19 GMT

It would be helpful to know what your data looks like (i.e., fields, field types, and how they're formatted), and what you want to achieve. e.g., are you looking for the average time between phone calls for each number, and do you just want to ignore phone numbers that only have one call?

Re: Evaluating time increments between records for same phone number

Elliott — Thu, 05 Mar 2015 00:06:14 GMT

The data is transactional, there is an ID, $18.; phone_num $20.; call_time in a time format looks like 08:46 AM in the data set

I need to evaluate each record that has the same phone number to see if the calls were placed within a 15 minutes period. if so then I have to throw and error.

I do not need to worry about phone numbers that only have 1 record call.

Thanks

Re: Evaluating time increments between records for same phone number

art297 — Thu, 05 Mar 2015 00:40:12 GMT

Do you have a date variable as well?

Re: Evaluating time increments between records for same phone number

Elliott — Thu, 05 Mar 2015 00:43:07 GMT

all records are for the same date

Re: Evaluating time increments between records for same phone number

art297 — Thu, 05 Mar 2015 01:24:42 GMT

The dif function, based on a numeric variable that has a time format, will provide the number of seconds between two times. e.g.:

data have;

informat time time5.;

format time time5.;

input phonenum time;

cards;

123 9:35

123 10:15

123 14:50

321 9:55

321 10:45

321 14:10

;

data want;

set have;

by phonenum;

dif=dif(time);

if first.phonenum then call missing(dif);

run;

Re: Evaluating time increments between records for same phone number

Elliott — Mon, 09 Mar 2015 13:20:58 GMT

Thank you very much Arthur, that is exactly what I needed.

Cindy