thanks for the reply boss. did not realize your logic ..but now fine. ... View more

thanks for the reply boss. Earlier did not get your answer but now...understand your logic ... View more

Thanks a ton . I got the expected result after applying round function with your logic. i confused a lot with proc compare and put logs but after applying round function,but no where found the information to apply round... ... View more

i am not yet tested your code  But  can you let me know what to do in this below case. My log: amount=944.68   /* dataset varible and its value */ indatasetA=1 indatasetB=0  /* these are in-varibles for 2 datasets*/ amount=944.68   indatasetA=0 indatasetB=1   my question: here it should be  indatasetA=1 indatasetB=1  but why considering those values as different?   Later  compared  with proc  and got so many as below ,same value but difference is there, thats why i am failing to implement my logic,in this case what to do? proc compare Obs || sumamount sumamount Diff. % Diff ________ || _________ _________ _________ _________ || 12 || 200.39 200.39 2.842E-14 1.418E-14 ... View more

I have to compare 2 datasets(A and B) and would like to know common records in Both,Exclusive to first and exclusive to second.  Please somebody provide the logic Note: ->1.Dataset A contains duplicate records and Dataset B also contains duplicate records. -->2.if dataset A cotains 3 records(duplicate) and dataset B contains only 2 of duplicate records , i should get like exclusive to A has one record. -->3.if dataset B cotains 3 records(duplicate) and dataset A contains only 2 of duplicate records , i should get like exclusive to B has one record.   I struggled a lot because(put log) amount=944.68 indatasetA=1 indatasetB=0  /* these are in-varibles for datasets with put */ amount=944.68 indatasetA=0 indatasetB=1  /* these are in-varibles for datasets with put */   proc compare Obs || sumamount sumamount Diff. % Diff ________ || _________ _________ _________ _________ || 12 || 200.39 200.39 2.842E-14 1.418E-14   ... View more

thanks for the reply. if you think it is possible to get this type of output please provide sample data which can give this type of result. data set A=284 records data set B=284 records A Except B=281 B Except A=281 A intersect/intersect all B=0 ... View more

Thanks for the reply. I can't copy my data here.if you think based on data it is possible to get this type of output,please  provide sample data to suit this output. Don't mind.   data set A=284 records data set B=284 records A Except B=281 B Except A=281 A intersect/intersect all B=0     ... View more

3 C record in dataset A 3 times and 2 times in dataset B I need answer that  dataset A has one extra record for 3 C.   purpose: there is db migration happened, i have pulled records from both dwh into sas and have to compare .. now would like to know 1.only in dataset A(3 c should come here once) 2.only in dataset B(4 D should come here) 4 Both/common in A and B(3 C should come here twice)     ... View more

first second /*dataset names */ a b a b /* varible names */ 1 a 1 a 2 b 2 b 2 b 2 b 3 c 3 c 3 c 3 c 3 c 4 d /*desired output should be */ both onlyA onlyB a b a b a b 1 a 3 c 4 d 2 b 2 b 3 c 3 c please let me know,whether i have given clarity or not?? ... View more

Thanks for reply, with set we can combine 2 datasets into one. But how can I know exclusive to firt dataset and second dataset and intersected records?? Please provide logic. ... View more

Thanks for reply, with set we can combine 2 datasets into one. But how can I know exclusive to firt dataset and second dataset and intersected records?? Please provide logic. ... View more