data ia.capacity;
   modify ia.capacity ia.newrtnum;
   by FlightId;
run;

proc print data=ia.capacity (obs = 5);
   title 'Using a Transaction Data Set for Modifications';
run;