Help using Base SAS procedures

Merge with condition

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

Merge with condition

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


Accepted Solutions
Solution
‎08-08-2013 06:13 PM
Super Contributor
Posts: 307

Re: Merge with condition

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

View solution in original post


All Replies
Solution
‎08-08-2013 06:13 PM
Super Contributor
Posts: 307

Re: Merge with condition

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 141 views
  • 0 likes
  • 2 in conversation