proc sql;
   alter table ia.cap2000
      add Constraint FKRoute Foreign Key (RouteID)
                    references ia.capInfo
					 on update restrict
					 on delete restrict;

proc sql;
   insert into ia.cap2000
       set  FlightID = 'IA00101',
	        RouteID = '0000145',
		    Origin = 'RDU',
		    Dest = 'LHR',
		    Cap1st = 15,
		    CapBusiness = 29,
		    CapEcon = 200;
		    
quit;