<?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.post9149906101783197836..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: PROC SQL Joins on Multiple Tables</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/9149906101783197836/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.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>5</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-340247351978864057</id><published>2019-10-04T22:15:17.204-07:00</published><updated>2019-10-04T22:15:17.204-07:00</updated><title type='text'>Hi Deepanshu, in reference to Mr.Swaroop&#39;s que...</title><content type='html'>Hi Deepanshu, in reference to Mr.Swaroop&#39;s questions... can we achieve the output by referring to the same code given above just by adding table and respective column names one after another if i have 10 tables? is it possible if i don&#39;t want to use any sort of loops as you have suggested? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/340247351978864057'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/340247351978864057'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.html?showComment=1570252517204#c340247351978864057' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/02210192902143275064</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/04/proc-sql-joins-on-multiple-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-9149906101783197836' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/9149906101783197836' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1094226969"/><gd:extendedProperty name="blogger.displayTime" value="October 4, 2019 at 10:15 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3299287738095208748</id><published>2018-09-21T14:34:14.671-07:00</published><updated>2018-09-21T14:34:14.671-07:00</updated><title type='text'>Hi Deepanshu, Can i have a example for the same. I...</title><content type='html'>Hi Deepanshu, Can i have a example for the same. If you feel like to share.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/3299287738095208748'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/3299287738095208748'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.html?showComment=1537565654671#c3299287738095208748' title=''/><author><name>Swaroop</name><uri>https://www.blogger.com/profile/05082851265730356053</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/04/proc-sql-joins-on-multiple-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-9149906101783197836' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/9149906101783197836' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-615297778"/><gd:extendedProperty name="blogger.displayTime" value="September 21, 2018 at 2:34 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2281021548026046091</id><published>2018-02-28T01:57:07.515-08:00</published><updated>2018-02-28T01:57:07.515-08:00</updated><title type='text'>Yes, you can use loop. Loop works under PROC SQL.</title><content type='html'>Yes, you can use loop. Loop works under PROC SQL.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2281021548026046091'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2281021548026046091'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.html?showComment=1519811827515#c2281021548026046091' title=''/><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/04/proc-sql-joins-on-multiple-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-9149906101783197836' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/9149906101783197836' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="February 28, 2018 at 1:57 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2469723032135284709</id><published>2018-02-28T01:49:54.735-08:00</published><updated>2018-02-28T01:49:54.735-08:00</updated><title type='text'>Hi, thanks for your tutorial. By the way I got one...</title><content type='html'>Hi, thanks for your tutorial. By the way I got one question: how to join efficiently more than 10 tables using proc sql (should we do a loop for that?)<br />Thanks. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2469723032135284709'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2469723032135284709'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.html?showComment=1519811394735#c2469723032135284709' title=''/><author><name>Charl E</name><uri>https://www.blogger.com/profile/06842790996822017487</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/04/proc-sql-joins-on-multiple-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-9149906101783197836' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/9149906101783197836' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2010625451"/><gd:extendedProperty name="blogger.displayTime" value="February 28, 2018 at 1:49 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2989864143531310664</id><published>2016-08-04T00:51:31.818-07:00</published><updated>2016-08-04T00:51:31.818-07:00</updated><title type='text'>Thanks for sharing..Good one..</title><content type='html'>Thanks for sharing..Good one..</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2989864143531310664'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/9149906101783197836/comments/default/2989864143531310664'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/proc-sql-joins-on-multiple-tables.html?showComment=1470297091818#c2989864143531310664' title=''/><author><name>Ravi</name><uri>https://www.blogger.com/profile/01335650195778431564</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/04/proc-sql-joins-on-multiple-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-9149906101783197836' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/9149906101783197836' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1287025831"/><gd:extendedProperty name="blogger.displayTime" value="August 4, 2016 at 12:51 AM"/></entry></feed>