Hi - I have a dataset which is having the reconciliation results of two datasets dst1 and dst2.    dst1 app_id name  100      mark 101      steve 102      John   dst2 app_id  name 100       mark 101       Philip 102       John   result dataset: DST3 dst1_appid dst2_appid recon_appid dst1_name  dst2_name  recon_name 100             100            Match           mark            mark            Match 101             101            Match           steve           Philip            Unmatched 102             102            Match           John            John             Match   I want to get a summary report of DST3. like below:  Column Name   Overall status  No of Matches No of Mismatches Recon_appid     Match              3                      0 Recon_name     Unmatch         2                      1   Can i use proc report to create this type of report ?  Also, would i be able to create a report where if i click to expand the overall status i will be able to know the details numbers. how can i approach this problem and what tools i can use from SAS. ... View more

Hi , I am using the below query to join multiple tables using proc sql. Is it possible to perform the same in a data step ?  Could you please help me translate this in data step?    proc sql; create table work.cte as select distinct el.flag, el.balance, el.daysdelinq, c.country, c.postcode, a.balance, a.cl, a.daysdelinq as daysdelinq_2, a.schufaindicator, a.finaccno as acct, c.customerno, el.row_no from work.pes_row el, pxm.accounts a, pxm.accxref aref, pxm.contacts c where el.finaccno = a.finaccno and a.acc = aref.acc and aref.customerno = c.customerno and a.finaccno in (select finaccno from work.acc_list_cards); quit;   Thank you ... View more

Hi    I have 3 datasets each has infomation on reconciliation in the below format.    Dataset 1: ID_source ID_target   ID_recon    name_source name_target name_recon 1                1               Matched     John               John             Matched 2                2               Matched     King                King             Matched 3                3               Matched     Simon             Simon          Matched     Dataset 2: ID_source ID_target   ID_recon    name_source name_target name_recon 1                1               Matched     John               John             Matched 2                2               Matched     King                King             Matched 3                3               Matched     Simon             Tom             Unmatched   Similarily, Dataset3 with the similar reconciliations. I want to create a summary report which tell me percentage of match for each dataset. Something similar to below:    Dataset                   Percentage of match Dataset1                 100% Dataset2                  84% Dataset3                  92%   Could you please help me how to solve this and how to approach this.    ... View more