This is probably an easy question for people accustomed to SQL programming, but, alas, I am not. Have AHS87: Control, Status, lots of other variables.... AHS89: Control, Status weight, lots of other variables... Want Linked: Control, Status87, Status89, weight no other variables In other words, I want to link AHS87 and AHS89 by matching on Control. I keep the Status variable from each dataset and drop everything else except the weight from AHS89. I could do this in a DATA step easily enough, but I'm trying to understand how to do it using PROC SQL. Thanks. --Dav
... View more