I have lots of data as follows:   FlightID Entry Exit NM FIR_ID FIR 94832841 0 165 35 1074 EDMONTON 94832841 165 290 65 1074 EDMONTON 94832841 290 330 31 1074 EDMONTON 94832841 330 330 256 1079 WINNIPEG 94832841 330 330 90 1079 WINNIPEG 94832841 330 350 167 1079 WINNIPEG 94832841 350 350 241 1079 WINNIPEG 94832841 350 350 198 1079 WINNIPEG 94832841 350 350 14 1078 TORONTO 94832841 350 330 207 1078 TORONTO 94832841 330 280 80 1078 TORONTO 94832841 280 132 48 1078 TORONTO 94832841 132 0 26 1078 TORONTO   Every flight has a unique FlightID and each flight can pass through regions (FIR). I'd like to be able to create a flight_segment variable.   Every time a NEW FlightID is found, that would be the start of a flight and thus the start of a segment...that is flight_segment would equal 1. If the next FlightID is the same AND the FIR is the same, it would remain at 1. If the next FlightID is the SAME and the FIR has changed, then the flight_segment would have one added to it.   Any ideas?   Thx ... View more

This is simple...but I'm stumped. I have:   data ESRA.&month_label._&year_want; set ESRA.CURRENTMONTH; run;   This makes a dataset called MARCH_2019   I would like MARCH 2019  (note the no underscore). I have tried a bunch of different ways but I know the marco references can be a bit strange when spaces are concerned.   Thanks   ... View more

I have a macro variable declared earlier as (it will be manually changed as needed):   %let monthly_update = 1;     Later on I would like to conditionally make a dataset as (not sure of the code but you will get the picture):   if &monthly_update = 1 then      data final;           set predata;           monthlyupdate = 1;     run; else      data final;            set predata;     run; end     thanks in advance!! -Bill ... View more

Any idea on how to create a variable that will give the number of days so far in the month...including hours?   For example, at 9pm tonight (March 25 ,2019), the variable dayssofar would be 24 days + 21hrs/24hrs = 24 + 0.875 = 24.875 days. Therefore dayssofar would equal 24.875   thanks   ... View more

Flights are assigned a UNIQUE numeric flt_biz_uid.  Each flight can have multiple messages associated with it. These messages are then grouped into 3 numeric types that are either 1 or 0 (true or not). Here is an example:   flt_biz_uid    msg_biz_uid    edm_datalink    gander_datalink    gander_voice 1                  22         1               0                  0 1                  23         0               0                  1 1                  26         0               0                  0 2                  26         0               0                  0 2                  22         0               0                  0 2                  23         0               0                  0   Supposed I want to pick flights that have edm_datalink=0 AND gander_datalink=0 AND gander_voice=0, but only if that particular flight has no messages that ever contained a edm_datalink=1 or a gander_datalink=1 or a gander_voice=1   In the example above, flt_biz_uid of 1 would NOT be included since its flight contains messages that have a 1 somewhere in edm_datalink, gander_datalink, or a gander_voice.   Meanwhile, flt_biz_uid 2 would be selected as there are 0s in all of its flight history for edm_datalink, gander_datalink, and gander_voice.   Can this be done easily?   Essentially this is "select flt_biz_uid when edm_datalink=0 AND gander_datalink=0 AND gander_voice=0 as long as the history of that flt_biz_uid has ALWAYS had edm_datalink=0 AND gander_datalink=0 AND gander_voice=0"   thx! ... View more