I have a base master table of about 150 million rows. I have a series of about 20 different tables that I need to link into the master table in order to fill out additional columns. These additional tables range in size from 500 rows to 30 million rows. Each one has a unique key that can be used to link to the master table. What is my best bet in creating one massive base table with all the columns I need filled out? I have tried a series of inner and left joins through proc sql but it takes way too long, probably 20-30 hours if I let it continue to run. I am a SAS novice but have a good understanding of SQL. Any tips for me?
... View more