<?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.post8899351495827912809..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS SQL : Use Distinct in CASE WHEN</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/8899351495827912809/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.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>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1460389056044990875</id><published>2022-02-15T01:23:19.521-08:00</published><updated>2022-02-15T01:23:19.521-08:00</updated><title type='text'>Great content overall. Thanks to the Author.
One r...</title><content type='html'>Great content overall. Thanks to the Author.<br />One request, could you please add details about PROC REPORT and PROC TEMPLATE here?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/1460389056044990875'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/1460389056044990875'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1644916999521#c1460389056044990875' title=''/><author><name>deba</name><uri>https://www.blogger.com/profile/10655679724493724006</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1607215907"/><gd:extendedProperty name="blogger.displayTime" value="February 15, 2022 at 1:23 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5611008531992256511</id><published>2021-09-07T23:27:38.381-07:00</published><updated>2021-09-07T23:27:38.381-07:00</updated><title type='text'>data sum1 minus1;
set ss;
if id &gt;=0 then output...</title><content type='html'>data sum1 minus1;<br />set ss;<br />if id &gt;=0 then output sum1;<br />else output minus1;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/5611008531992256511'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/5611008531992256511'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1631082458381#c5611008531992256511' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/5804950009579103743'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07523794258968384787</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1398499398"/><gd:extendedProperty name="blogger.displayTime" value="September 7, 2021 at 11:27 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8238700354885360284</id><published>2021-07-22T22:24:26.794-07:00</published><updated>2021-07-22T22:24:26.794-07:00</updated><title type='text'>can we use firstobs and obs concept 

</title><content type='html'>can we use firstobs and obs concept <br /><br /></content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/8238700354885360284'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/8238700354885360284'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1627017866794#c8238700354885360284' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/7076217534093452598'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/03450840982992709830</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1493840840"/><gd:extendedProperty name="blogger.displayTime" value="July 22, 2021 at 10:24 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7076217534093452598</id><published>2020-08-05T23:18:30.540-07:00</published><updated>2020-08-05T23:18:30.540-07:00</updated><title type='text'>data want;
set ss;
retain positive negative 0;
if ...</title><content type='html'>data want;<br />set ss;<br />retain positive negative 0;<br />if id&gt;0 then positive+a;<br />else negative+a;<br />run;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/7076217534093452598'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/7076217534093452598'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1596694710540#c7076217534093452598' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/04161734793159358687</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-601928439"/><gd:extendedProperty name="blogger.displayTime" value="August 5, 2020 at 11:18 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5804950009579103743</id><published>2020-01-15T22:56:58.461-08:00</published><updated>2020-01-15T22:56:58.461-08:00</updated><title type='text'>data ss;
input id;
datalines;
1
2
3
4
5
-1
-2
-3
-...</title><content type='html'>data ss;<br />input id;<br />datalines;<br />1<br />2<br />3<br />4<br />5<br />-1<br />-2<br />-3<br />-4<br />-5<br />;<br />run;<br /><br />i want sum of positive value in one variable and negative value in another variable</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/5804950009579103743'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/5804950009579103743'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1579157818461#c5804950009579103743' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/15673535217706237064</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1181873721"/><gd:extendedProperty name="blogger.displayTime" value="January 15, 2020 at 10:56 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-9148339116781632482</id><published>2019-11-21T11:25:40.570-08:00</published><updated>2019-11-21T11:25:40.570-08:00</updated><title type='text'>I have looked all over for the process to just &qu...</title><content type='html'>I have looked all over for the process to just &quot;ignore&quot; duplicate rows in Spotfire. Everything I find it about writing long expressions and inseting new columns to remove duplicate rows. this is the simple and easy button solution Fantastic!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/9148339116781632482'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/9148339116781632482'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1574364340570#c9148339116781632482' title=''/><author><name>SAP</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="November 21, 2019 at 11:25 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8372609765678088586</id><published>2017-11-11T10:44:08.415-08:00</published><updated>2017-11-11T10:44:08.415-08:00</updated><title type='text'>Superb article</title><content type='html'>Superb article</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/8372609765678088586'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/8372609765678088586'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1510425848415#c8372609765678088586' title=''/><author><name>Manoj</name><uri>https://www.blogger.com/profile/03859107949375959333</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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-448788460"/><gd:extendedProperty name="blogger.displayTime" value="November 11, 2017 at 10:44 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1762597435326833076</id><published>2017-07-23T01:11:17.873-07:00</published><updated>2017-07-23T01:11:17.873-07:00</updated><title type='text'>Hi - I don&#39;t understand the last SQL query - c...</title><content type='html'>Hi - I don&#39;t understand the last SQL query - can you further explain?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/1762597435326833076'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/8899351495827912809/comments/default/1762597435326833076'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2016/10/sas-sql-use-distinct-in-case-when.html?showComment=1500797477873#c1762597435326833076' 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/2016/10/sas-sql-use-distinct-in-case-when.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-8899351495827912809' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/8899351495827912809' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 23, 2017 at 1:11 AM"/></entry></feed>