I can't read your comments.  But I have also gotten the WARNING you got.  I removed the DBIDIRECTEXEC option to get rid of the warning.  SAS R&D says that if you use SAS specific SQL against a native SAS table with DBIDIRECTEXEC and sastrace=',,,d' then you should expect to get that warning - it is "working as designed".   If that is working as designed, it sure isn't working as users expect.  There should at least be a technote. ... View more

#3 Use a hash object.  Load your ICD9 and ICD10 reference tables into one hash with lookup values of 'ICD9' and 'ICD10' respectively.  See if the code value in each row of your data is in the hash and retrieve either the 'ICD9 ' or 'ICD10' from that hit.  If you don't get a hit, assign the value 'Other'. ... View more