My data looks like the attached: how do we find the observations that had 0 or -1 delays in a row (by dates) and make four new variables for first and second date, and first and second delay values?
I want to write something like:
proc sql;
select flightnumber, date, delay
from airline.flightdelays
where delay = 0 or delay = -1 && the difference between dates for delay = 0 and delay = -1 is only 1 && flight numbers for
delay = 0 and delay = -1 are the same
make 4 new variables, one col with delay =0s, one with delay = -1s, one with delay =0 dates, one with delay =-1 dates;
quit;
I am not totally clear but
new variables can be made through case statement like
case when delay = -1 or delay = 0 then date
else whatever
end as newvariable
where clause what you have mentioned should work
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.