Hello All, So I have a program where we randomly sample patients each month. I want to create a code where I can merge sample_patients1 (say this is the sample for month of April) merge it sample_pateients2 (this is for month of May) to ensure not same patients get sampled again in May. And if there are any duplicates then I want to know which patients are those. FYI - I am merging the 2 datasets by using 'PatientFileNo' which is unique for each patient. I am using this now but it is not working - data work.eligible; merge work.eligible (in=new) reference1 (in=ref keep=PRAMSFileNo); by PRAMSFileNo; if (new and (not ref)); run; */
... View more