A late comment: In general, when you fetch a lot of data from a big DWH, you want an ABEND if ANYTHING is incorrect. Then you can sit down and consider the structure of your tables, and what problem you really want to solve. There are of course several technical ways of avoiding the the error message, but they do not really help you to get accurate and realiable SAS-programs. Please note that the use of LENGTH mergevar $ 32767; will increase the amount of computer resorces used. Regards Anders
... View more