<?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 Combine two datasets that have no common variables in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449987#M113310</link>
    <description>&lt;P&gt;Hi, I have a problem that need to combine (or merge) two datesets&amp;nbsp;that have no common variables.&lt;/P&gt;&lt;P&gt;Here is an example:&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;have1&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;x;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;1&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;2&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;3&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;4&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;have2&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;y&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;5&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;6&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;7&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;8&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;want&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;x y&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;1 5&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;2 6&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;3 7&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;4 8&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;I am pretty sure that the variables in two datasets have exactly the same number of observations.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;Any suggestion is appreciated! Thank you.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Fri, 30 Mar 2018 17:47:45 GMT</pubDate>
    <dc:creator>Xusheng</dc:creator>
    <dc:date>2018-03-30T17:47:45Z</dc:date>
    <item>
      <title>Combine two datasets that have no common variables</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449987#M113310</link>
      <description>&lt;P&gt;Hi, I have a problem that need to combine (or merge) two datesets&amp;nbsp;that have no common variables.&lt;/P&gt;&lt;P&gt;Here is an example:&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;have1&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;x;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;1&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;2&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;3&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;4&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;have2&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;y&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;5&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;6&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;7&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;8&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csE0EE740F"&gt;data&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;want&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;input&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;&lt;SPAN&gt;&amp;nbsp;x y&lt;/SPAN&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csD28C4F3F"&gt;datalines&lt;/SPAN&gt;&lt;SPAN class="m_231069973099029295csAB6422E4"&gt;;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;1 5&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;2 6&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;3 7&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;4 8&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;run;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;I am pretty sure that the variables in two datasets have exactly the same number of observations.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P class="m_231069973099029295cs95E872D0"&gt;&lt;SPAN class="m_231069973099029295csECD9B3DF"&gt;Any suggestion is appreciated! Thank you.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Fri, 30 Mar 2018 17:47:45 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449987#M113310</guid>
      <dc:creator>Xusheng</dc:creator>
      <dc:date>2018-03-30T17:47:45Z</dc:date>
    </item>
    <item>
      <title>Re: Combine two datasets that have no common variables</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449989#M113311</link>
      <description>&lt;PRE&gt;data want;
  set have1;
  set have2;
run;
&lt;/PRE&gt;
&lt;P&gt;Art, CEO, AnalystFinder.com&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 30 Mar 2018 17:53:11 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449989#M113311</guid>
      <dc:creator>art297</dc:creator>
      <dc:date>2018-03-30T17:53:11Z</dc:date>
    </item>
    <item>
      <title>Re: Combine two datasets that have no common variables</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449990#M113312</link>
      <description>&lt;P&gt;Thank you.&lt;/P&gt;</description>
      <pubDate>Fri, 30 Mar 2018 17:55:08 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Combine-two-datasets-that-have-no-common-variables/m-p/449990#M113312</guid>
      <dc:creator>Xusheng</dc:creator>
      <dc:date>2018-03-30T17:55:08Z</dc:date>
    </item>
  </channel>
</rss>

