Adding minutes to time field and comparing

[User123]

I wanted to know if the CENT_TM10 is greater than (COLL_TM1 + 15 minutes)

Data EC02;Set Ec01;

if cent_tm10 > coll_tm1 + 15 ;

Run;

I get all the records in EC01 again into EC02..

Any help..

Bob

[art297]

You didn't indicate what kind of fields cent_tm10 and coll_tm1 were.  If they are datatime fields they are measured in seconds thus you would have to change your comparison to that unit of measurement (i.e., times 60).

[User123]

time5. is the format that I have on all the time fields.

BOB

[Tom · Accepted solution]

SAS stores time in seconds. Use 15*60 to get 15 minutes.