proc format lib = ia cntlout = fmtdata; select $airport; run; /* proc fsedit data=work.fmtdata; run; */ /* data work.fmtdata; set work.fmtdata end=last; output; if last then do; FmtName = '$airport'; Start = 'YYC'; End = 'YYC'; Label = 'Calgary, AB'; output; Start = 'YYZ'; End = 'YYZ'; Label = 'Toronto, ON'; output; Start = 'YQB'; End = 'YQB'; Label = 'Quebec, QC'; output; Start = 'YUL'; End = 'YUL'; Label = 'Montreal, QC'; output; end; run; */ proc sql; insert into fmtdata set FmtName = '$airport', Start = 'YYC', End = 'YYC', Label = 'Calgary, AB' set FmtName = '$airport', Start = 'YYZ', End = 'YYZ' , Label = 'Toronto, ON' set FmtName = '$airport', Start = 'YQB', End = 'YQB', Label = 'Quebec, QC' set FmtName = '$airport', Start = 'YUL', End = 'YUL' , Label = 'Montreal, QC'; quit; proc format library = ia cntlin = fmtdata; run; proc format library = ia fmtlib; select $airport; title 'New values in the $airport Format'; run;