Reviewing the instructions for getting the data they are using proc import. It could be better to replace that one with an approach that does not guessing column types. Bu guessing you have most likely the cause the datasets got different types. That is the failure at merging. Using the datastep merge the first (left) value gets precedence unless missing. That is different when using sql where you have to specify that.
... View more