Thanks Andrew for a good way to use Proc Format in joining 2 large tables. I detect a small typo? proc sort data = demo.tableb_fmt; should be proc sort data = demo.tableb_lat_fmt; Cheers, Qui