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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.