Is there a procedure or other easy way to perform the lookup below? Or do I have to transpose the definition table and do a join on each column? My dataset contains many variables where I need to perform the this operation, so if there is a convenient way of doing this dynamically that would help allot.   Dataset: type shape count 1 1 57 4 1 127 9 2 35 9 2 87   Definition table: format id name type 1 blue type 4 gray type 9 red shape 1 round shape 2 circle   Want: type shape count blue round 57 gray round 127 red circle 35 red circle 87 ... View more