08-08-2013 05:19 PM
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;
Need further help from the community? Please ask a new question.