tag:blogger.com,1999:blog-7958828565254404797.post8899351495827912809..comments2024-03-18T23:27:20.269-07:00Comments on ListenData: SAS SQL : Use Distinct in CASE WHENDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-7958828565254404797.post-14603890560449908752022-02-15T01:23:19.521-08:002022-02-15T01:23:19.521-08:00Great content overall. Thanks to the Author.
One r...Great content overall. Thanks to the Author.<br />One request, could you please add details about PROC REPORT and PROC TEMPLATE here?debahttps://www.blogger.com/profile/10655679724493724006noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-56110085319922565112021-09-07T23:27:38.381-07:002021-09-07T23:27:38.381-07:00data sum1 minus1;
set ss;
if id >=0 then output...data sum1 minus1;<br />set ss;<br />if id >=0 then output sum1;<br />else output minus1;<br />run;Anonymoushttps://www.blogger.com/profile/07523794258968384787noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-82387003548853602842021-07-22T22:24:26.794-07:002021-07-22T22:24:26.794-07:00can we use firstobs and obs concept
can we use firstobs and obs concept <br /><br />Anonymoushttps://www.blogger.com/profile/03450840982992709830noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-52866571664931889342020-12-23T06:21:26.712-08:002020-12-23T06:21:26.712-08:00This comment has been removed by the author.Vikramhttps://www.blogger.com/profile/16707366443556062879noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-70762175340934525982020-08-05T23:18:30.540-07:002020-08-05T23:18:30.540-07:00data want;
set ss;
retain positive negative 0;
if ...data want;<br />set ss;<br />retain positive negative 0;<br />if id>0 then positive+a;<br />else negative+a;<br />run;Anonymoushttps://www.blogger.com/profile/04161734793159358687noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-58049500095791037432020-01-15T22:56:58.461-08:002020-01-15T22:56:58.461-08:00data ss;
input id;
datalines;
1
2
3
4
5
-1
-2
-3
-...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 variableAnonymoushttps://www.blogger.com/profile/15673535217706237064noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-91483391167816324822019-11-21T11:25:40.570-08:002019-11-21T11:25:40.570-08:00I have looked all over for the process to just &qu...I have looked all over for the process to just "ignore" 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!SAPnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-83726097656780885862017-11-11T10:44:08.415-08:002017-11-11T10:44:08.415-08:00Superb articleSuperb articleManojhttps://www.blogger.com/profile/03859107949375959333noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-17625974353268330762017-07-23T01:11:17.873-07:002017-07-23T01:11:17.873-07:00Hi - I don't understand the last SQL query - c...Hi - I don't understand the last SQL query - can you further explain?Anonymousnoreply@blogger.com