Hi, all-- I know of Proc Compare, but I do not think it will satisfy my needs... Here is what I have: Data Set 1 Data Set 2 I am looking for a way to compare the two tables such that the output table is a result of additions/removals/changes based on Name & Weight...so, if there is the same name on both data sets, did the weight change? Is there a name on the first data set not on the second? Is there a name on the second date set not on the first? Here is what I'm looking for: Rob --> name on both, but weight changed Ben --> name on first, not on second Sam --> name on second, not on first So, essentially, am looking for a table that compiles those three kinds of changes, while showing the value from the first & the second data set if applicable (such as the Rob record). I have no issues importing the data into SAS, but I am struggling with a way to satisfy the above. Thanks in advance for any help!!
... View more