<?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.post1528394893539435334..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: PROC SQL Joins: A Step-by-Step Guide</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/1528394893539435334/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default?start-index=26&max-results=25'/><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>43</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3526257973703905056</id><published>2023-10-24T04:09:52.812-07:00</published><updated>2023-10-24T04:09:52.812-07:00</updated><title type='text'>In PROC SQL, you can use the %do %to loop to gener...</title><content type='html'>In PROC SQL, you can use the %do %to loop to generate a series of join statements for each table from BIRTHS12 to BIRTHS21. Better way to do this via merge statement in SAS (as shown below) -<br />data want;<br />merge BIRTHS12-BIRTHS21;<br />by ID;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3526257973703905056'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3526257973703905056'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1698145792812#c3526257973703905056' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/624770190275291850'/><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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 24, 2023 at 4:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-624770190275291850</id><published>2023-10-23T17:42:06.565-07:00</published><updated>2023-10-23T17:42:06.565-07:00</updated><title type='text'>Hi, Deepanshu! It&#39;s been years since you last ...</title><content type='html'>Hi, Deepanshu! It&#39;s been years since you last answered to any comments here, so this is a long shot. What if I want to use PROC SQL to join various tables that are listed in sequence? For instance, BIRTHS12, BIRTHS13... BIRTHS21? Is there a way to join tables in a range? [BIRTHS12-BIRTHS21]?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/624770190275291850'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/624770190275291850'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1698108126565#c624770190275291850' title=''/><author><name>Fah</name><uri>https://www.blogger.com/profile/03823531226510471820</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-763183820"/><gd:extendedProperty name="blogger.displayTime" value="October 23, 2023 at 5:42 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7698579083132545068</id><published>2020-09-20T02:44:30.860-07:00</published><updated>2020-09-20T02:44:30.860-07:00</updated><title type='text'>Great Job!</title><content type='html'>Great Job!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7698579083132545068'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7698579083132545068'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1600595070860#c7698579083132545068' title=''/><author><name>MIchał</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="September 20, 2020 at 2:44 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1702258030414044603</id><published>2020-09-06T00:20:58.331-07:00</published><updated>2020-09-06T00:20:58.331-07:00</updated><title type='text'>Why missing values are coming in right join but no...</title><content type='html'>Why missing values are coming in right join but not in left join?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1702258030414044603'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1702258030414044603'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1599376858331#c1702258030414044603' title=''/><author><name>Ashutosh Gupta</name><uri>https://www.blogger.com/profile/05433448489915916883</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzO4TojUxGUunSGi2vezhllqBpHG3Aui3jHYs9ixQ8KXd9Z6YVxdLmdVaVr1STjEfzTTLP19W8lldee9Bj8PTQV-bbtsun44SXQB2PiZOe3fd9bJHk1dnxsNvNTc1DMJc/s220/Ashutosh1011.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1503313834"/><gd:extendedProperty name="blogger.displayTime" value="September 6, 2020 at 12:20 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3321123880700912506</id><published>2019-02-27T02:04:42.749-08:00</published><updated>2019-02-27T02:04:42.749-08:00</updated><title type='text'>I dont think ur explaination about inner join is a...</title><content type='html'>I dont think ur explaination about inner join is accurate, ud better compare that with Proc SQL outter join.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3321123880700912506'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3321123880700912506'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1551261882749#c3321123880700912506' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/00551218678573381440</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1590333310"/><gd:extendedProperty name="blogger.displayTime" value="February 27, 2019 at 2:04 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5681052624385240959</id><published>2018-12-02T03:24:44.546-08:00</published><updated>2018-12-02T03:24:44.546-08:00</updated><title type='text'>Hi Deepanshu,
I appreciate your work and thanks fo...</title><content type='html'>Hi Deepanshu,<br />I appreciate your work and thanks for creating a decent tool. If you&#39;ll mention the rules that would be great. Also add interesting scenarios bit logical concepts.<br />and Syntax of every function statement.<br />Thanks</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/5681052624385240959'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/5681052624385240959'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1543749884546#c5681052624385240959' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15315359382029871015</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1826974907"/><gd:extendedProperty name="blogger.displayTime" value="December 2, 2018 at 3:24 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3649587486659972117</id><published>2018-11-15T23:10:38.336-08:00</published><updated>2018-11-15T23:10:38.336-08:00</updated><title type='text'>excellent explanation</title><content type='html'>excellent explanation</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3649587486659972117'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3649587486659972117'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1542352238336#c3649587486659972117' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/05598940539451267415</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-594349870"/><gd:extendedProperty name="blogger.displayTime" value="November 15, 2018 at 11:10 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8341836208106128766</id><published>2018-11-12T15:43:29.770-08:00</published><updated>2018-11-12T15:43:29.770-08:00</updated><title type='text'>Great, thanks for posting this.</title><content type='html'>Great, thanks for posting this.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8341836208106128766'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8341836208106128766'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1542066209770#c8341836208106128766' title=''/><author><name>Tom Little</name><uri>https://www.blogger.com/profile/10496080969995452049</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-4289643"/><gd:extendedProperty name="blogger.displayTime" value="November 12, 2018 at 3:43 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6204722699095322353</id><published>2018-09-24T19:57:02.346-07:00</published><updated>2018-09-24T19:57:02.346-07:00</updated><title type='text'>Superb description about SAS</title><content type='html'>Superb description about SAS</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/6204722699095322353'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/6204722699095322353'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1537844222346#c6204722699095322353' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/17388101576237010565</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1841382326"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2018 at 7:57 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7898636330616543754</id><published>2018-03-20T16:44:12.893-07:00</published><updated>2018-03-20T16:44:12.893-07:00</updated><title type='text'>I love your site to refer any concept in SAS or SQ...</title><content type='html'>I love your site to refer any concept in SAS or SQL</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7898636330616543754'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7898636330616543754'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1521589452893#c7898636330616543754' 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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 20, 2018 at 4:44 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1780011547904206335</id><published>2018-03-12T08:11:11.831-07:00</published><updated>2018-03-12T08:11:11.831-07:00</updated><title type='text'>How many datasets can be merged in proc sql (sas 9...</title><content type='html'>How many datasets can be merged in proc sql (sas 9.4)?<br /><br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1780011547904206335'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1780011547904206335'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1520867471831#c1780011547904206335' 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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 12, 2018 at 8:11 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7806166391890964763</id><published>2017-10-12T00:57:23.127-07:00</published><updated>2017-10-12T00:57:23.127-07:00</updated><title type='text'>It helpful for my understanding, Thank you</title><content type='html'>It helpful for my understanding, Thank you</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7806166391890964763'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7806166391890964763'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1507795043127#c7806166391890964763' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/03627784528336669729</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-753229901"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2017 at 12:57 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6409297663387440346</id><published>2017-03-03T21:16:08.768-08:00</published><updated>2017-03-03T21:16:08.768-08:00</updated><title type='text'>This is really great website. I&#39;m glad I found...</title><content type='html'>This is really great website. I&#39;m glad I found it.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/6409297663387440346'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/6409297663387440346'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1488604568768#c6409297663387440346' 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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 3, 2017 at 9:16 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4458825281521691322</id><published>2017-02-20T09:21:45.161-08:00</published><updated>2017-02-20T09:21:45.161-08:00</updated><title type='text'>The output record will be prepared either from the...</title><content type='html'>The output record will be prepared either from the record of A or B, hence the statement &quot;if x=1 or y=1;&quot; will not be required to mention and it will be by default.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/4458825281521691322'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/4458825281521691322'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1487611305161#c4458825281521691322' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2304210686868127008'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07902387948035908459</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1167181269"/><gd:extendedProperty name="blogger.displayTime" value="February 20, 2017 at 9:21 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2035402917234785997</id><published>2017-02-20T09:18:12.218-08:00</published><updated>2017-02-20T09:18:12.218-08:00</updated><title type='text'>What about Outer joins? How it will be prepared us...</title><content type='html'>What about Outer joins? How it will be prepared using PROC SQL?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2035402917234785997'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2035402917234785997'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1487611092218#c2035402917234785997' title=''/><author><name>Anil</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="February 20, 2017 at 9:18 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1440695536290094384</id><published>2017-02-06T04:35:10.463-08:00</published><updated>2017-02-06T04:35:10.463-08:00</updated><title type='text'>Was very useful.!! Well explained.</title><content type='html'>Was very useful.!! Well explained.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1440695536290094384'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/1440695536290094384'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1486384510463#c1440695536290094384' title=''/><author><name>chaithra</name><uri>https://www.blogger.com/profile/04770487774614757840</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1998711260"/><gd:extendedProperty name="blogger.displayTime" value="February 6, 2017 at 4:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-903157967610687064</id><published>2016-12-19T10:33:21.285-08:00</published><updated>2016-12-19T10:33:21.285-08:00</updated><title type='text'>Did you read the first paragraph &#39;Advantages o...</title><content type='html'>Did you read the first paragraph &#39;Advantages of PROC SQL Joins over Data Step Merging&#39;? That&#39;s answer of your first question. Second question is also discussed in the article. If you have duplicates in any of the tables, you would get cartesian product of the duplicate records.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/903157967610687064'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/903157967610687064'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1482172401285#c903157967610687064' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/5141329405198753799'/><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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="December 19, 2016 at 10:33 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8583463636992397144</id><published>2016-09-21T10:01:14.347-07:00</published><updated>2016-09-21T10:01:14.347-07:00</updated><title type='text'>Well explained about joins. Very use full for the ...</title><content type='html'>Well explained about joins. Very use full for the beginners.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8583463636992397144'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8583463636992397144'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1474477274347#c8583463636992397144' title=''/><author><name>RAO</name><uri>https://www.blogger.com/profile/10390185052797073885</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1386274296"/><gd:extendedProperty name="blogger.displayTime" value="September 21, 2016 at 10:01 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8229772184345408508</id><published>2016-07-21T07:55:48.502-07:00</published><updated>2016-07-21T07:55:48.502-07:00</updated><title type='text'>If you include &quot;*&quot; keyword, it would sel...</title><content type='html'>If you include &quot;*&quot; keyword, it would select variables from both the tables.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8229772184345408508'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/8229772184345408508'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469112948502#c8229772184345408508' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2654773783875760793'/><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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 7:55 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5179158867782871089</id><published>2016-07-21T07:54:45.051-07:00</published><updated>2016-07-21T07:54:45.051-07:00</updated><title type='text'>Thanks for pointing it out. I have corrected the c...</title><content type='html'>Thanks for pointing it out. I have corrected the code. Cheers!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/5179158867782871089'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/5179158867782871089'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469112885051#c5179158867782871089' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7251364054330741115'/><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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 7:54 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3469301813256902187</id><published>2016-07-21T07:53:38.080-07:00</published><updated>2016-07-21T07:53:38.080-07:00</updated><title type='text'>By default, MERGE Statement performs FULL JOIN so ...</title><content type='html'>By default, MERGE Statement performs FULL JOIN so &quot;if x=1 or y=1;&quot; is not required. Please let me know incase any query(s) Thanks!<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3469301813256902187'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/3469301813256902187'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469112818080#c3469301813256902187' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2304210686868127008'/><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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 7:53 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-84259017963925669</id><published>2016-07-21T06:09:15.400-07:00</published><updated>2016-07-21T06:09:15.400-07:00</updated><title type='text'>Please let me know if I am wrong </title><content type='html'>Please let me know if I am wrong </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/84259017963925669'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/84259017963925669'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469106555400#c84259017963925669' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2304210686868127008'/><author><name>ParveenSharma</name><uri>https://www.blogger.com/profile/05328224574286097056</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1455489468"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 6:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2304210686868127008</id><published>2016-07-21T06:07:48.971-07:00</published><updated>2016-07-21T06:07:48.971-07:00</updated><title type='text'>full join Data Step code should be

Data dummy; ...</title><content type='html'>full join Data Step code should be<br /><br />Data dummy; <br />Merge A (IN = X) B (IN=Y);<br />by ID;<br />if x=1 or y=1;<br />run;<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2304210686868127008'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2304210686868127008'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469106468971#c2304210686868127008' title=''/><author><name>ParveenSharma</name><uri>https://www.blogger.com/profile/05328224574286097056</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1455489468"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 6:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7251364054330741115</id><published>2016-07-21T06:03:23.675-07:00</published><updated>2016-07-21T06:03:23.675-07:00</updated><title type='text'>full join code should be like this
PROC SQL;
Creat...</title><content type='html'>full join code should be like this<br />PROC SQL;<br />Create table dummy as<br />Select coalesce (x.ID,y.ID) as ID, <br />coalesce (x.name,y.name) as name,height,weight<br />from A as x full join B as y<br />on x.ID = y.ID;<br />Quit;<br /><br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7251364054330741115'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/7251364054330741115'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1469106203675#c7251364054330741115' title=''/><author><name>ParveenSharma</name><uri>https://www.blogger.com/profile/05328224574286097056</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1455489468"/><gd:extendedProperty name="blogger.displayTime" value="July 21, 2016 at 6:03 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2654773783875760793</id><published>2016-06-24T00:42:12.564-07:00</published><updated>2016-06-24T00:42:12.564-07:00</updated><title type='text'>Hi Deepanshu,

in all the joins it is mentioned 

...</title><content type='html'>Hi Deepanshu,<br /><br />in all the joins it is mentioned <br /><br />(Common columns in both the data sets + uncommon columns from data set A + uncommon columns from data set B).<br /><br />is this true????</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2654773783875760793'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/1528394893539435334/comments/default/2654773783875760793'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2014/06/proc-sql-merging.html?showComment=1466754132564#c2654773783875760793' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12175757657794539192</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/2014/06/proc-sql-merging.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-1528394893539435334' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/1528394893539435334' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1780396830"/><gd:extendedProperty name="blogger.displayTime" value="June 24, 2016 at 12:42 AM"/></entry></feed>