<?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.post3951143632290185649..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS SQL : Comparing two 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/3951143632290185649/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-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-1925128275686635986</id><published>2020-07-31T07:20:37.548-07:00</published><updated>2020-07-31T07:20:37.548-07:00</updated><title type='text'>data One;
input
a b c;
cards;
1 2 3
2 3 4
3 4 5
ru...</title><content type='html'>data One;<br />input<br />a b c;<br />cards;<br />1 2 3<br />2 3 4<br />3 4 5<br />run;<br />data Two;<br />input<br />_a _b _c;<br />cards;<br />1 3 3<br />2 3 4<br />3 4 5<br />run;<br />data aj;<br />set one ;<br />set two;<br />run;<br /><br />data dj(drop= a c _a _c);<br />set a;<br />where b ne _b;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/1925128275686635986'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/1925128275686635986'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-tables.html?showComment=1596205237548#c1925128275686635986' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/9076062579783091728'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/12664079669219732959</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/sas-sql-comparing-two-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3951143632290185649' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3951143632290185649' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1410066713"/><gd:extendedProperty name="blogger.displayTime" value="July 31, 2020 at 7:20 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6023833845425315252</id><published>2018-06-14T19:51:09.171-07:00</published><updated>2018-06-14T19:51:09.171-07:00</updated><title type='text'>Can you please post the results of the query as yo...</title><content type='html'>Can you please post the results of the query as you have been doing in other sections? Thanks</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/6023833845425315252'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/6023833845425315252'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-tables.html?showComment=1529031069171#c6023833845425315252' 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/04/sas-sql-comparing-two-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3951143632290185649' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3951143632290185649' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="June 14, 2018 at 7:51 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4646770284226369477</id><published>2017-06-17T12:30:16.562-07:00</published><updated>2017-06-17T12:30:16.562-07:00</updated><title type='text'>please send your suggestions as i need the solutio...</title><content type='html'>please send your suggestions as i need the solution very urgently. i am also working on that but not able to capture the erroneous attribute. Please email @pawan.pvs@gmail.com if someone finds something.<br /><br />Thanks a lot in advance!!!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/4646770284226369477'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/4646770284226369477'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-tables.html?showComment=1497727816562#c4646770284226369477' title=''/><author><name>Favouritism</name><uri>https://www.blogger.com/profile/03079094424616068449</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/sas-sql-comparing-two-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3951143632290185649' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3951143632290185649' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1712022239"/><gd:extendedProperty name="blogger.displayTime" value="June 17, 2017 at 12:30 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-9076062579783091728</id><published>2017-06-17T12:27:28.590-07:00</published><updated>2017-06-17T12:27:28.590-07:00</updated><title type='text'>e.g i have two datasets

One:-
a b c
1 2 3
2 3 4
3...</title><content type='html'>e.g i have two datasets<br /><br />One:-<br />a b c<br />1 2 3<br />2 3 4<br />3 4 5<br />Two:-<br />1 3 3<br />2 3 4<br />3 4 5<br /><br />so in the output i want to show that b attribute in the 1st row have different value. which wil help me to identify the pattern of wrong output and will help me to work only on those attributes for which my output is not matching with the master data.<br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/9076062579783091728'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/9076062579783091728'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-tables.html?showComment=1497727648590#c9076062579783091728' title=''/><author><name>Favouritism</name><uri>https://www.blogger.com/profile/03079094424616068449</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/sas-sql-comparing-two-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3951143632290185649' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3951143632290185649' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1712022239"/><gd:extendedProperty name="blogger.displayTime" value="June 17, 2017 at 12:27 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6735516070780301104</id><published>2017-06-17T12:24:01.635-07:00</published><updated>2017-06-17T12:24:01.635-07:00</updated><title type='text'>I also want to compare two datasets but want to ou...</title><content type='html'>I also want to compare two datasets but want to output those attributes for which the values are different only. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/6735516070780301104'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/3951143632290185649/comments/default/6735516070780301104'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/04/sas-sql-comparing-two-tables.html?showComment=1497727441635#c6735516070780301104' title=''/><author><name>Favouritism</name><uri>https://www.blogger.com/profile/03079094424616068449</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/sas-sql-comparing-two-tables.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-3951143632290185649' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/3951143632290185649' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1712022239"/><gd:extendedProperty name="blogger.displayTime" value="June 17, 2017 at 12:24 PM"/></entry></feed>