DATA Step, Macro, Functions and more

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

Reply
Contributor gsk
Contributor
Posts: 23

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

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? dataset.JPG

 

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; 

 

PROC Star
Posts: 500

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

[ Edited ]

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 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 61 views
  • 0 likes
  • 2 in conversation