<?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.post5000977557852686277..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS : Identifying and storing unique and duplicate values</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/5000977557852686277/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.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>15</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3504301577608353338</id><published>2022-02-17T08:46:57.725-08:00</published><updated>2022-02-17T08:46:57.725-08:00</updated><title type='text'>proc sort data=Distance nodupkey dupout=Sorted;&#xa;by...</title><content type='html'>proc sort data=Distance nodupkey dupout=Sorted;&lt;br /&gt;by distance;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3504301577608353338'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3504301577608353338'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1645116417725#c3504301577608353338' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><author><name>Shilpa Kale</name><uri>https://www.blogger.com/profile/06098268369477167359</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1753094932"/><gd:extendedProperty name="blogger.displayTime" value="February 17, 2022 at 8:46 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7791418477739857265</id><published>2022-02-17T08:45:23.316-08:00</published><updated>2022-02-17T08:45:23.316-08:00</updated><title type='text'>NODUP option removes duplicate observations where ...</title><content type='html'>NODUP option removes duplicate observations where values in all the variables are repeated (identical observations).&lt;br /&gt;NODUP check entire row, for both David score is different.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7791418477739857265'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7791418477739857265'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1645116323316#c7791418477739857265' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3546709717750215061'/><author><name>Shilpa Kale</name><uri>https://www.blogger.com/profile/06098268369477167359</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1753094932"/><gd:extendedProperty name="blogger.displayTime" value="February 17, 2022 at 8:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5424453080441284665</id><published>2022-02-17T08:39:37.924-08:00</published><updated>2022-02-17T08:39:37.924-08:00</updated><title type='text'>proc sort data=Distance nodupkey dupout=Sorted;&#xa;by...</title><content type='html'>proc sort data=Distance nodupkey dupout=Sorted;&lt;br /&gt;by distance;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/5424453080441284665'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/5424453080441284665'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1645115977924#c5424453080441284665' title=''/><author><name>Shilpa Kale</name><uri>https://www.blogger.com/profile/06098268369477167359</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1753094932"/><gd:extendedProperty name="blogger.displayTime" value="February 17, 2022 at 8:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7384942871619909649</id><published>2021-07-14T09:27:23.418-07:00</published><updated>2021-07-14T09:27:23.418-07:00</updated><title type='text'>This is more simpler way of doing. Try this&#xa;&#xa;proc ...</title><content type='html'>This is more simpler way of doing. Try this&lt;br /&gt;&lt;br /&gt;proc sort data=a2;&lt;br /&gt;by distance;&lt;br /&gt;run;&lt;br /&gt;data a3;&lt;br /&gt;set a2;&lt;br /&gt;by distance;&lt;br /&gt;if first.distance then output;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7384942871619909649'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7384942871619909649'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1626280043418#c7384942871619909649' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><author><name>Raghu Ramarapu</name><uri>https://www.blogger.com/profile/03251043434436758002</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='http://1.bp.blogspot.com/-ZT31oiGk2J4/TiFDVNJltCI/AAAAAAAAAJE/4wedMlHbnuE/s220/photo.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1672266646"/><gd:extendedProperty name="blogger.displayTime" value="July 14, 2021 at 9:27 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1181524522859461849</id><published>2019-02-05T01:59:57.490-08:00</published><updated>2019-02-05T01:59:57.490-08:00</updated><title type='text'>Please check this..&#xa;&#xa;Data Distance;&#xa;Length Source ...</title><content type='html'>Please check this..&lt;br /&gt;&lt;br /&gt;Data Distance;&lt;br /&gt;Length Source Destination $10.;&lt;br /&gt;Input Source $ Destination $ Distance;&lt;br /&gt;Cards;&lt;br /&gt;Bangalore Pune 1500&lt;br /&gt;BBSR Bangalore 1300&lt;br /&gt;Mumbai Bangalore 2000&lt;br /&gt;Pune BBSR 1800&lt;br /&gt;Bangalore BBSR 1300&lt;br /&gt;Pune Bangalore 1500&lt;br /&gt;Chennai BBSR 1800&lt;br /&gt;Hyderabad Pune 1000&lt;br /&gt;Hyderabad Mumbai 1600&lt;br /&gt;Delhi Bangalore 2200&lt;br /&gt;Pune Hyderabad 1000&lt;br /&gt;;&lt;br /&gt;Run;&lt;br /&gt;proc sort data=distance;&lt;br /&gt;by distance;&lt;br /&gt;run;&lt;br /&gt;data readin1;&lt;br /&gt;set distance;&lt;br /&gt;by Distance;&lt;br /&gt;First_Distance=First.Distance;&lt;br /&gt;IF (Distance=1500 and First_Distance=1) then delete;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1181524522859461849'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1181524522859461849'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1549360797490#c1181524522859461849' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><author><name>Bhupinder</name><uri>https://www.blogger.com/profile/14500548925339278560</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-629345625"/><gd:extendedProperty name="blogger.displayTime" value="February 5, 2019 at 1:59 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3546709717750215061</id><published>2018-07-19T07:17:44.009-07:00</published><updated>2018-07-19T07:17:44.009-07:00</updated><title type='text'>why David is there after _all_? same id same name</title><content type='html'>why David is there after _all_? same id same name</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3546709717750215061'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3546709717750215061'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1532009864009#c3546709717750215061' title=''/><author><name>Newe</name><uri>https://www.blogger.com/profile/07137559281856833306</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-25654853"/><gd:extendedProperty name="blogger.displayTime" value="July 19, 2018 at 7:17 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7306238443710786794</id><published>2018-05-08T08:12:59.746-07:00</published><updated>2018-05-08T08:12:59.746-07:00</updated><title type='text'>Data Distance2;&#xa;Length rs1 rs2 $10.;&#xa;Input rs1 $ r...</title><content type='html'>Data Distance2;&lt;br /&gt;Length rs1 rs2 $10.;&lt;br /&gt;Input rs1 $ rs2 $ mode1 $ mode2$;&lt;br /&gt;Cards;&lt;br /&gt;rs11122 rs33344 rec dom&lt;br /&gt;rs33344 rs11122 dom rec&lt;br /&gt;;&lt;br /&gt;Run;&lt;br /&gt;&lt;br /&gt;proc sort data = Distance2;&lt;br /&gt;by mode1 mode2;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data test;&lt;br /&gt;set distance2;&lt;br /&gt;if rs1 EQ Lag(rs2) then x = 1; else x = 2;&lt;br /&gt;if mode1 EQ Lag(mode2) then y = 1; else y = 2;&lt;br /&gt;if x= 2 and y = 2 then output;&lt;br /&gt;run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7306238443710786794'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7306238443710786794'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1525792379746#c7306238443710786794' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7980360346809485932'/><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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 8, 2018 at 8:12 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6172763792189065694</id><published>2017-08-22T08:52:43.874-07:00</published><updated>2017-08-22T08:52:43.874-07:00</updated><title type='text'>Hi Nikhil.. &#xa;Does this solution work&#xa;If distance i...</title><content type='html'>Hi Nikhil.. &lt;br /&gt;Does this solution work&lt;br /&gt;If distance is same from same source or destination to any other source or destinations.. &lt;br /&gt;Sample data:&lt;br /&gt;Bangalore pune 1500&lt;br /&gt;Pune bangalore 1500&lt;br /&gt;Shajahanpur pune 1500&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/6172763792189065694'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/6172763792189065694'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1503417163874#c6172763792189065694' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><author><name>Parthiban K</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="August 22, 2017 at 8:52 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7980360346809485932</id><published>2017-07-13T00:29:47.087-07:00</published><updated>2017-07-13T00:29:47.087-07:00</updated><title type='text'>Could someone please help me in this?:How should I...</title><content type='html'>Could someone please help me in this?:How should I do if I want to remove reverse duplicates for the below data: let´s say we have one row which shows interaction between rs1, rs2,through mode1 and mode2 and the other record shows the same interaction but changing the order of the SNPs and consequently of the mode of inheritance?&lt;br /&gt;rs11122 rs33344 rec dom&lt;br /&gt;rs33344 rs11122 dom rec&lt;br /&gt;I just want to keep one of those rows.&lt;br /&gt;Any help would be really appreciated</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7980360346809485932'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7980360346809485932'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1499930987087#c7980360346809485932' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/13249551381501867540</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1882226079"/><gd:extendedProperty name="blogger.displayTime" value="July 13, 2017 at 12:29 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3939743588767235492</id><published>2017-06-08T06:09:40.036-07:00</published><updated>2017-06-08T06:09:40.036-07:00</updated><title type='text'>Hi Unmesh,&#xa;&#xa;You can use below code for this...&#xa;&#xa;pr...</title><content type='html'>Hi Unmesh,&lt;br /&gt;&lt;br /&gt;You can use below code for this...&lt;br /&gt;&lt;br /&gt;proc sort data = distance;                                                                                                              &lt;br /&gt;by distance;                                                                                                                            &lt;br /&gt;run;                                                                                                                                    &lt;br /&gt;                                                                                                                                        &lt;br /&gt;data newdistance;                                                                                                                       &lt;br /&gt;set distance;                                                                                                                           &lt;br /&gt;if source eq lag(destination) then x=1;                                                                                                 &lt;br /&gt;else x=2;                                                                                                                               &lt;br /&gt;if x=2 then output;                                                                                                                     &lt;br /&gt;drop x;                                                                                                                                 &lt;br /&gt;run;  &lt;br /&gt;&lt;br /&gt;Please let me know if you have any question...&lt;br /&gt;&lt;br /&gt;Regards&lt;br /&gt;Nikhil Jain</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3939743588767235492'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/3939743588767235492'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1496927380036#c3939743588767235492' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><author><name>Nikhil</name><uri>https://www.blogger.com/profile/12584917026116622134</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1420559482"/><gd:extendedProperty name="blogger.displayTime" value="June 8, 2017 at 6:09 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2314675199732944566</id><published>2017-06-05T20:19:45.747-07:00</published><updated>2017-06-05T20:19:45.747-07:00</updated><title type='text'>very Helpful..</title><content type='html'>very Helpful..</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/2314675199732944566'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/2314675199732944566'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1496719185747#c2314675199732944566' title=''/><author><name>Ankit Gupta</name><uri>https://www.blogger.com/profile/02667780308415264707</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-401185185"/><gd:extendedProperty name="blogger.displayTime" value="June 5, 2017 at 8:19 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7882177469138281055</id><published>2017-01-19T12:22:12.589-08:00</published><updated>2017-01-19T12:22:12.589-08:00</updated><title type='text'>It&amp;#39;s really very helpful...</title><content type='html'>It&amp;#39;s really very helpful... </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7882177469138281055'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/7882177469138281055'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1484857332589#c7882177469138281055' title=''/><author><name>Nikhil</name><uri>https://www.blogger.com/profile/12584917026116622134</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1420559482"/><gd:extendedProperty name="blogger.displayTime" value="January 19, 2017 at 12:22 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1811839014958091449</id><published>2016-02-08T11:59:25.697-08:00</published><updated>2016-02-08T11:59:25.697-08:00</updated><title type='text'>If i want to remove reverse duplicates how should ...</title><content type='html'>If i want to remove reverse duplicates how should I go about it? I have mentioned the data below..For the below data: lets say we have one row which shows Bangalore to Pune and the other record shows Pune to Bangalore. I just want to keep any one of those values..&lt;br /&gt;&lt;br /&gt;Data Distance;&lt;br /&gt;Length Source Destination $10.;&lt;br /&gt;Input Source $ Destination $ Distance;&lt;br /&gt;Cards;&lt;br /&gt;Bangalore Pune 1500&lt;br /&gt;BBSR Bangalore 1300&lt;br /&gt;Mumbai Bangalore 2000&lt;br /&gt;Pune BBSR 1800&lt;br /&gt;Bangalore BBSR 1300&lt;br /&gt;Pune Bangalore 1500&lt;br /&gt;Chennai BBSR 1800&lt;br /&gt;Hyderabad Pune 1000&lt;br /&gt;Hyderabad Mumbai 1600&lt;br /&gt;Delhi Bangalore 2200&lt;br /&gt;Pune Hyderabad 1000&lt;br /&gt;;&lt;br /&gt;Run;&lt;br /&gt;&lt;br /&gt;Please suggest!&lt;br /&gt;&lt;br /&gt;Thanks,&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/1811839014958091449'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1454961565697#c1811839014958091449' title=''/><author><name>Unmesh Panigrahy</name><uri>https://www.blogger.com/profile/12957652256341755314</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-55031987"/><gd:extendedProperty name="blogger.displayTime" value="February 8, 2016 at 11:59 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-491095533313635503</id><published>2016-02-08T00:40:53.190-08:00</published><updated>2016-02-08T00:40:53.190-08:00</updated><title type='text'>More stuff on SAS Please!!! Big fan of you :D</title><content type='html'>More stuff on SAS Please!!! Big fan of you :D</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/491095533313635503'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/491095533313635503'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1454920853190#c491095533313635503' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/06886251102065867888</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-338759456"/><gd:extendedProperty name="blogger.displayTime" value="February 8, 2016 at 12:40 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6970377791847024250</id><published>2016-02-02T03:05:32.411-08:00</published><updated>2016-02-02T03:05:32.411-08:00</updated><title type='text'>All the questions and Answers are really informati...</title><content type='html'>All the questions and Answers are really informative and useful. I heart fully appreciate your effort.Please keep on post latest questions and Answers. They help us a lot...</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/6970377791847024250'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/5000977557852686277/comments/default/6970377791847024250'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2013/10/sas-identifying-and-storing-unique-and_7.html?showComment=1454411132411#c6970377791847024250' title=''/><author><name>Neelima</name><uri>https://www.blogger.com/profile/06335788799141603014</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/2013/10/sas-identifying-and-storing-unique-and_7.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-5000977557852686277' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/5000977557852686277' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1548625089"/><gd:extendedProperty name="blogger.displayTime" value="February 2, 2016 at 3:05 AM"/></entry></feed>