Merge with condition

[robertrao]

Hi,

I have two datasets and "variable name" TIME differs in both

I want to merge by ID and TIME and want to delete if its a duplicate occuring  in both.

How can this be the log?????????when only 14 records were common then I was expecting the WANT dataset to have (93+68=161)-14=147???????????

DATASET1 has 93 records

DATASET2 has 68 records

WANT has 133 records

TEST has 14 records

Please correct me???

data want test;

merge dataset1(in=a)   dataset2( in=b rename=(time1=time));

by ID TIME;

if a and b then output test;else output want;

run;

DATASET1                                     
ID     TIME                                  
101   27JUN2013:11:24

DATASET2
ID             TIME1
101       27JUN2013:11:24

[Fugue · Accepted solution]

If there are 14 records in common, then the total of non-matches will be (93-14)+(68-14)=133.