Thx! by running the command proc sql; create index securityId on FOUNDATION_SECURITY; quit; the sql-step is executed a lot faster. It takes about 2min to create the index but since I am running similar join-queries further down the in the program with the large dataset then this helped a lot. Thx!
... View more
