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

[gsk]

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; 

[kiranv_]

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