Hi Reeza, Thanks for the Reply, yes i would like to replicate row_number() over (partition by var1,var2 order by var1, var2, var3) ,for which i'm yielding wrong results when i try to replicate in Data Step with order by and first.var concepts. Thanks ... View more

Hello Reeza,   how and where to define the STORE variable in the macro?   Thanks in advance ... View more

hello DataFlux_SME, Can you please provide me with the example program? ... View more

hello Tom,   The discrepancies should be shown subject wise by comparing the data from Client and Vendor ... View more

Hello Tom,   We have two data sets here, client and vendor files. We have to compare both and give the discrepancies as shown below like wise, we have to compare client-vendor and vendor-client (from both sides) and show the discrepancies data set.   client data set:   subject    visit    date_of_exam    modality 101    baseline    1-Jan-89    CT 101    week07    30-Apr-89    MRI 101    week13    5-May-89    PET 101    week27    12-Jun-89    ECHO 101    week27    12-Jun-89    MUGA   vendor dataset:   subject    visit    date_of exam    modality 101    baseline    5-Jan-89    CT 101    WEEK07    30-Apr-89    CT 101    week13    10-May-89    DUAL-CT 101    WEEK27    12-Jun-89    ECHO   Discrepancy Report: (Output Data set 😞   SUBJECT VISIT    DATE_OF_EXAM    MODALITY    TYPE_OF_DESCRIPANCY    DESCRIPTION 101    baseline    5-Jan-89                      CT            DATE OF EXAM DISCRIPANT    CLIENT HAS 01-JAN-89 101    week07    30-Apr-89                     CT             MODALITY DISCREPANT    CLIENT HAS MRI 101    week13    10-May-89                  DUAL-CT    MISSING IN CLIENT DATABASE    RECORD MISSING IN CLIENT(IF MORE      THAN                  ONE                                                                    VARIABLE IS DISCREPANT IT SHOULD BE SHOWN AS MISSING) 101    week27    12-Jun-89                    MUGA    MISSING IN VENDOR DATABASE    RECORD MISSING IN VENDOR   Please help me with this   Thank you   ... View more