https://communities.sas.com/t5/SAS-Programming/Perform-a-big-join-on-URLs/m-p/863991#M341230 <OL class="lia-list-style-type-lower-alpha"> <LI>Create a format</LI> <LI>Use a hash object</LI> </OL> <P>Both methods require that the smaller dataset fits into available memory.</P> Tue, 14 Mar 2023 10:31:52 GMT Kurt_Bremser 2023-03-14T10:31:52Z https://communities.sas.com/t5/SAS-Programming/Perform-a-big-join-on-URLs/m-p/863979#M341226 <P>Hi</P><P>&nbsp;</P><P>I have on one side a multi million records table including email sent with related URLS included. On the other, a smaller table where for each URL there is a label associated. The join on URLS is time intensive, so wondering if there is any trick I can use to speed up performances. I already sorted the tables per URLS. Bests</P> Tue, 14 Mar 2023 09:29:55 GMT https://communities.sas.com/t5/SAS-Programming/Perform-a-big-join-on-URLs/m-p/863979#M341226 dcortell 2023-03-14T09:29:55Z https://communities.sas.com/t5/SAS-Programming/Perform-a-big-join-on-URLs/m-p/863991#M341230 <OL class="lia-list-style-type-lower-alpha"> <LI>Create a format</LI> <LI>Use a hash object</LI> </OL> <P>Both methods require that the smaller dataset fits into available memory.</P> Tue, 14 Mar 2023 10:31:52 GMT https://communities.sas.com/t5/SAS-Programming/Perform-a-big-join-on-URLs/m-p/863991#M341230 Kurt_Bremser 2023-03-14T10:31:52Z