For my 2p, using formats won't change the underlying data, only how it is displayed. You could do the following two options in SQL which would change the data: proc sql; create table WANT as select BASE.OBS, (select THIS.HEADER2 from MAPPING THIS where THIS.HEADER1=BASE.HEADER2) as HEADER2, (select THIS.HEADER2 from MAPPING THIS where THIS.HEADER1=BASE.HEADER3) as HEADER3, (select THIS.HEADER2 from MAPPING THIS where THIS.HEADER1=BASE.HEADER4) as HEADER4 from HAVE; quit; Or: proc sql; create table WANT as select A.OBS, B.HEADER2 as HEADER2, C.HEADER2 as HEADER3, D.HEADER2 as HEADER4 from HAVE A left join MAPPING B on A.HEADER2=B.HEADER1 left join MAPPING C on A.HEADER3=B.HEADER1 left join MAPPING D on A.HEADER4=B.HEADER1; quit;
... View more