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
If there are 14 records in common, then the total of non-matches will be (93-14)+(68-14)=133.
If there are 14 records in common, then the total of non-matches will be (93-14)+(68-14)=133.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.