https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344549#M79184 Anything is fine.. Mon, 27 Mar 2017 09:12:50 GMT Abhi1212 2017-03-27T09:12:50Z https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344533#M79179 <P>I have 2 data set Test and Prod. I have to compare both and get the list of common shipment which is available in test and prod but the rate value differs and then I need the list of shipments which is not matching.</P><P>Please help me with a code.</P> Mon, 27 Mar 2017 07:50:35 GMT https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344533#M79179 Abhi1212 2017-03-27T07:50:35Z https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344536#M79180 <P>And this has to be done with a merge statement or are you allowed to use proc compare?</P> Mon, 27 Mar 2017 07:58:18 GMT https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344536#M79180 PeterClemmensen 2017-03-27T07:58:18Z https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344549#M79184 Anything is fine.. Mon, 27 Mar 2017 09:12:50 GMT https://communities.sas.com/t5/SAS-Programming/Playaround-with-Merge/m-p/344549#M79184 Abhi1212 2017-03-27T09:12:50Z