Hi , I am not aware of this functions mentioned above by ballardw..i did normal merge on your data to map the state names and codes... proc sort data=County_Pop;by State County cName; run; proc sort data=County_HH;by State County cName; run; proc sort data=State_Names;by State; run; data want ; merge County_Pop(in=a) County_HH(in=b) State_Names (in=c); by State ; if a and b; run; By running the above code i got the o/p as follows State County cName Population Households sName 01 01001 Autauga 222,135 106,625 Alabama 01 01011 Bullock 300,000 144,000 Alabama 01 01023 Choctaw 115,000 55,200 Alabama 42 42003 Allegheny 389,471 186,946 Pennsylvania 42 42101 Philadelphia 2,689,765 1,291,087 Pennsylvania
... View more