proc sql: finding observation that satisfies certain conditions and putting to make a new variable

gsk — Tue, 06 Feb 2018 15:31:19 GMT

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;

Re: proc sql: finding observation that satisfies certain conditions and putting to make a new variab

kiranv_ — Tue, 06 Feb 2018 16:00:16 GMT

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

topic proc sql: finding observation that satisfies certain conditions and putting to make a new variable in SAS Programming

proc sql: finding observation that satisfies certain conditions and putting to make a new variable

Re: proc sql: finding observation that satisfies certain conditions and putting to make a new variab