Hi !   It’s my first thread 😀 I’m in the following situation:   Left join on five tables (first table: 100 million rows / 15 columns / about 15GB                                      second table: 300 million rows / 15 columns / about 80GB                                      third table: 10 000 rows / 10 columns / about 2MB                                      fourth table: 100 million rows / 40 columns / about 40GB                                      fifth table: 50 rows / 5columns / about 150KB) Filtering with IN clauses and Date intervals Selecting multiple variables and applying some Text functions and CASE WHEN statements   I’d like to improve the performances of my code, especially the speed.   I tried filtering the largest tables before joining them and also to compress them with a binary option, but my performances didn’t improve so much.   I’d like to know if you have any advice to suggest me to make it better ( I’ve already read this interesting topic and tried some methods from Making SAS® Tables Smaller and Faster Without Data Loss - SAS Support Communities, but without meaningful results).   Hope you can help me and in any case thanks in advance! ... View more