<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Can we create a hash table to be able to do our joins? in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Can-we-create-a-hash-table-to-be-able-to-do-our-joins/m-p/756064#M238641</link>
    <description>&lt;P&gt;Hello team,&lt;/P&gt;
&lt;P&gt;Can we create a hash table to do a join in SAS and then the result would be written to a permanent table?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If yes, how?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The reason I am asking or hash table because If I want to do the join through perm tables, my sas session might take a long time so the session might be killed.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;blue blue&lt;/P&gt;</description>
    <pubDate>Thu, 22 Jul 2021 21:51:51 GMT</pubDate>
    <dc:creator>GN0001</dc:creator>
    <dc:date>2021-07-22T21:51:51Z</dc:date>
    <item>
      <title>Can we create a hash table to be able to do our joins?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Can-we-create-a-hash-table-to-be-able-to-do-our-joins/m-p/756064#M238641</link>
      <description>&lt;P&gt;Hello team,&lt;/P&gt;
&lt;P&gt;Can we create a hash table to do a join in SAS and then the result would be written to a permanent table?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If yes, how?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The reason I am asking or hash table because If I want to do the join through perm tables, my sas session might take a long time so the session might be killed.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;blue blue&lt;/P&gt;</description>
      <pubDate>Thu, 22 Jul 2021 21:51:51 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Can-we-create-a-hash-table-to-be-able-to-do-our-joins/m-p/756064#M238641</guid>
      <dc:creator>GN0001</dc:creator>
      <dc:date>2021-07-22T21:51:51Z</dc:date>
    </item>
    <item>
      <title>Re: Can we create a hash table to be able to do our joins?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Can-we-create-a-hash-table-to-be-able-to-do-our-joins/m-p/756071#M238648</link>
      <description>Here's many papers on the topic:&lt;BR /&gt;&lt;A href="https://www.lexjansen.com/search/searchresults.php?q=sql%20merge%20versus%20sas%20data%20step" target="_blank"&gt;https://www.lexjansen.com/search/searchresults.php?q=sql%20merge%20versus%20sas%20data%20step&lt;/A&gt;&lt;BR /&gt;&lt;BR /&gt;Or a starter one:&lt;BR /&gt;&lt;A href="https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/249-30.pdf" target="_blank"&gt;https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/249-30.pdf&lt;/A&gt;</description>
      <pubDate>Thu, 22 Jul 2021 21:59:17 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Can-we-create-a-hash-table-to-be-able-to-do-our-joins/m-p/756071#M238648</guid>
      <dc:creator>Reeza</dc:creator>
      <dc:date>2021-07-22T21:59:17Z</dc:date>
    </item>
  </channel>
</rss>

