topic IF/THEN/DELETE statement for time format variables. in New SAS User

IF/THEN/DELETE statement for time format variables.

njgrubic — Tue, 29 Sep 2020 13:23:16 GMT

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?

Re: IF/THEN/DELETE statement for time format variables.

PaigeMiller — Tue, 29 Sep 2020 13:36:13 GMT

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.

Re: IF/THEN/DELETE statement for time format variables.

Kurt_Bremser — Tue, 29 Sep 2020 13:33:18 GMT

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.