Complex Data Combinations on Large Volumes: How to Get the Best Performance
Developers are often challenged to build complex combinations of large files with a good performance. In most cases the SQL procedure is the obvious choice. However, the DATA step often provides better alternatives with outstanding performance improvements. An extra level of complexity is added when data cannot just be combined on common key fields, but time slices or weighting parameters have to be taken into account.