Couple of thoughts. First make sure each county is unique. Many Counties have the same name in different states. For example, there is an Orange County, TX and Orange County, CA. You may need to get the variable State into your Teacher dataset and use both State and County to preform the merge. proc sql; create table cmt as select * from One a FULL join Two b on a.cou=b.cou and a.STATE = b.STATE; quit; You will get a message about variables that are in both datasets. You might want to consider doing a COALESCE() on those variables that are in both for example cou and state. Carry
... View more
