I am running the following sql-step: proc sql; create table id_map as select a.securityId ,b.name ,b.companyId from eq_securityIds as a left join FOUNDATION_SECURITY as b on a.securityId=b.securityId ; quit; where the dataset eq_securityId consists of ~16000 observations (here denoted a small dataset) and the dataset FOUNDATION_SECURITY consist of ~60 000 000 observations (here denoted a large dataset). As of now the runtime to execute this command is about 10min, is there anything I can do to speed up the sql-step? e.g, is it in general faster to join a small dataset on to a large dataset instead of me joining the large dataset onto the small dataset? could some kind of indexation of the large dataset help me speeding up the computations? I noted that the command ran a lot faster (~3min) when I excluded the variable b.name in the same sql-step, is this a general result or was it just a fluke? I run SAS 9.4 (in enterprise guide 7.1)
... View more