tag:blogger.com,1999:blog-7958828565254404797.post3951143632290185649..comments2024-03-18T23:27:20.269-07:00Comments on ListenData: SAS SQL : Comparing two tablesDeepanshu Bhallahttp://www.blogger.com/profile/09802839558125192674noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7958828565254404797.post-19251282756866359862020-07-31T07:20:37.548-07:002020-07-31T07:20:37.548-07:00data One;
input
a b c;
cards;
1 2 3
2 3 4
3 4 5
ru...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;Anonymoushttps://www.blogger.com/profile/12664079669219732959noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-60238338454253152522018-06-14T19:51:09.171-07:002018-06-14T19:51:09.171-07:00Can you please post the results of the query as yo...Can you please post the results of the query as you have been doing in other sections? ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-71673935881312779352017-11-18T02:48:20.856-08:002017-11-18T02:48:20.856-08:00This comment has been removed by the author.simply sujithttps://www.blogger.com/profile/14430913285889574189noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-46467702842263694772017-06-17T12:30:16.562-07:002017-06-17T12:30:16.562-07:00please send your suggestions as i need the solutio...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!!!Favouritismhttps://www.blogger.com/profile/03079094424616068449noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-90760625797830917282017-06-17T12:27:28.590-07:002017-06-17T12:27:28.590-07:00e.g i have two datasets
One:-
a b c
1 2 3
2 3 4
3...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 />Favouritismhttps://www.blogger.com/profile/03079094424616068449noreply@blogger.comtag:blogger.com,1999:blog-7958828565254404797.post-67355160707803011042017-06-17T12:24:01.635-07:002017-06-17T12:24:01.635-07:00I also want to compare two datasets but want to ou...I also want to compare two datasets but want to output those attributes for which the values are different only. Favouritismhttps://www.blogger.com/profile/03079094424616068449noreply@blogger.com