PROC SQL solution, using @Ksharp's data sets above: data Table1;
input Field $ val1 val2;
cards;
Color 2 3
Color 1 1
Test 1 1
Test 1 0
;
run;
data Lookup;
input Field $ Value Name $;
cards;
Color 1 Red
Color 2 Orange
Color 3 Green
Test 1 yes
Test 0 no
;
run;
proc sql;
create table want
as
select T.Field
, T.val1
, T.val2
, L1.Name as Name1
, L2.Name as Name2
from Table1 as T
left join Lookup as L1
on L1.Value = T.Val1
and L1.Field = T.Field
left join Lookup as L2
on L2.Value = T.Val2
and L2.Field = T.Field;
run;
... View more