IF/THEN/DELETE statement for time format variables.

[njgrubic]

I have 4 variables that are formatted as time variables (hh:mm:ss). Specifically, I am looking to exclude any observations from the dataset where where the time interval is 00:00:00, negative, or greater than 01:00:00.

How would I write this code in a typical if/then delete data set?

[PaigeMiller · Accepted solution]

data want;
    set have;
    if time_interval<='00:00:00't or time_interval>'01:00:00't then delete;
run;

As a side issue, the variables are not "formatted as time variables", they are time variables, representing the number of seconds after midnight, or if you really have an interval, the value is the number of seconds in the interval. The format used is irrelevant to the above code, which will work however the variable TIME_INTERVAL is formatted and will work if the variable is not formatted.

[Kurt_Bremser]

Which interval? Between values in separate observations for the same column, or between separate columns within a single observation?

Please supply some example data in a data step with datalines, and the expected outcome from that.