<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post4746493353360577182..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : Many to Many Merge</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>13</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6855000563677765244</id><published>2019-12-29T10:10:14.314-08:00</published><updated>2019-12-29T10:10:14.314-08:00</updated><title type='text'>Well explained..</title><content type='html'>Well explained..</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/6855000563677765244'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/6855000563677765244'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1577643014314#c6855000563677765244' title=''/><author><name>Balaji Ch</name><uri>https://www.blogger.com/profile/06499106282214676997</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1235815237"/><gd:extendedProperty name="blogger.displayTime" value="December 29, 2019 at 10:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3456629181781944897</id><published>2019-11-17T08:57:28.460-08:00</published><updated>2019-11-17T08:57:28.460-08:00</updated><title type='text'>What is the difference in Cartesian Product and Cr...</title><content type='html'>What is the difference in Cartesian Product and Cross join. If they are one and the same, why haven&#39;t you used keyword cross in the above query?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/3456629181781944897'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/3456629181781944897'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1574009848460#c3456629181781944897' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07408172268352646931</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1004960583"/><gd:extendedProperty name="blogger.displayTime" value="November 17, 2019 at 8:57 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7092128150766829947</id><published>2019-06-21T22:27:42.085-07:00</published><updated>2019-06-21T22:27:42.085-07:00</updated><title type='text'>Can u please tell me in case of many to many match...</title><content type='html'>Can u please tell me in case of many to many match which would be more perfect Data Step Merge or Proc SQL join and why???? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/7092128150766829947'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/7092128150766829947'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1561181262085#c7092128150766829947' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/14242985529940318208</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1206971185"/><gd:extendedProperty name="blogger.displayTime" value="June 21, 2019 at 10:27 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2158354529952269256</id><published>2019-05-14T10:56:20.277-07:00</published><updated>2019-05-14T10:56:20.277-07:00</updated><title type='text'>What if i did not want all 6 obs shown in example ...</title><content type='html'>What if i did not want all 6 obs shown in example but needed only the ones in first dataset merged with the variables in 2nd dataset without extra observations? What i mean is if I have 10 obs(with repeats) and 6 variables in dataset A and 12 obs(with repeats) and 3 variables in dataset B; i want the product to be Dataset C with 10 obs from A but will all 9 variables coming from A and B?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/2158354529952269256'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/2158354529952269256'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1557856580277#c2158354529952269256' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 14, 2019 at 10:56 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8886781937295455216</id><published>2019-04-21T01:29:54.949-07:00</published><updated>2019-04-21T01:29:54.949-07:00</updated><title type='text'>Use intersect operator</title><content type='html'>Use intersect operator</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8886781937295455216'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8886781937295455216'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1555835394949#c8886781937295455216' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/22725939462476612'/><author><name>Unknown</name><uri>https://www.blogger.com/profile/01439870058672472247</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1115869353"/><gd:extendedProperty name="blogger.displayTime" value="April 21, 2019 at 1:29 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5367952239248093701</id><published>2018-08-09T02:36:17.340-07:00</published><updated>2018-08-09T02:36:17.340-07:00</updated><title type='text'>Use Innerjoin</title><content type='html'>Use Innerjoin</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5367952239248093701'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5367952239248093701'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1533807377340#c5367952239248093701' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/22725939462476612'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04926032502040026375</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-860665413"/><gd:extendedProperty name="blogger.displayTime" value="August 9, 2018 at 2:36 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-22725939462476612</id><published>2017-08-08T11:34:28.457-07:00</published><updated>2017-08-08T11:34:28.457-07:00</updated><title type='text'>Hi 
Have a query 
I have 10 observations in datase...</title><content type='html'>Hi <br />Have a query <br />I have 10 observations in dataset A and 20 observations in dataset B<br />How to find whether the 10 observations in dataset A are present in dataset B</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/22725939462476612'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/22725939462476612'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1502217268457#c22725939462476612' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="August 8, 2017 at 11:34 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8760454665202189175</id><published>2017-06-04T19:00:27.131-07:00</published><updated>2017-06-04T19:00:27.131-07:00</updated><title type='text'>Hi, 

can you please explain how it writes the va...</title><content type='html'>Hi, <br /><br />can you please explain how it writes the value 1234 in info for last 1 in output : Merge ? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8760454665202189175'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8760454665202189175'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1496628027131#c8760454665202189175' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="June 4, 2017 at 7:00 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6529663069317967483</id><published>2017-01-11T12:21:14.258-08:00</published><updated>2017-01-11T12:21:14.258-08:00</updated><title type='text'>Hi Deepanshu,

Superb work &amp; many many thanks....</title><content type='html'>Hi Deepanshu,<br /><br />Superb work &amp; many many thanks... Can I get a detail explanation on different kinds of join (left, right, full, inner, cross) with PROC SQL as well as DATA MERGE. Again keep the good work up :)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/6529663069317967483'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/6529663069317967483'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1484166074258#c6529663069317967483' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 11, 2017 at 12:21 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4415270417713514848</id><published>2016-08-30T14:28:21.590-07:00</published><updated>2016-08-30T14:28:21.590-07:00</updated><title type='text'>Here we are talking about all possible combination...</title><content type='html'>Here we are talking about all possible combinations of matching observations (not all possible combinations of all the values). Primary key exists here. Hope it helps.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/4415270417713514848'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/4415270417713514848'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1472592501590#c4415270417713514848' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5908737176568968968'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="August 30, 2016 at 2:28 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5908737176568968968</id><published>2016-06-23T12:46:10.251-07:00</published><updated>2016-06-23T12:46:10.251-07:00</updated><title type='text'>why the sql code says left join? Shouldn&#39;t it ...</title><content type='html'>why the sql code says left join? Shouldn&#39;t it be cross join?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5908737176568968968'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5908737176568968968'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1466711170251#c5908737176568968968' title=''/><author><name>Amrita</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="June 23, 2016 at 12:46 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8058941801841107712</id><published>2016-03-07T00:49:57.833-08:00</published><updated>2016-03-07T00:49:57.833-08:00</updated><title type='text'>Nice work!!! </title><content type='html'>Nice work!!! </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8058941801841107712'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/8058941801841107712'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1457340597833#c8058941801841107712' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 7, 2016 at 12:49 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5371261244951100361</id><published>2016-01-17T01:15:23.266-08:00</published><updated>2016-01-17T01:15:23.266-08:00</updated><title type='text'>super work..keep continuing..</title><content type='html'>super work..keep continuing..</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5371261244951100361'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/4746493353360577182/comments/default/5371261244951100361'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html?showComment=1453022123266#c5371261244951100361' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-many-to-many-merge.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-4746493353360577182' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/4746493353360577182' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="January 17, 2016 at 1:15 AM"/></entry></feed>