How to exclude certain observations in a merge step?

Maisha_Huq — Mon, 20 Oct 2014 20:03:04 GMT

Hi:

In a merge step, I'd like to exclude certain observations from being matched or merged. How would I code this?

Thanks!!

Re: How to exclude certain observations in a merge step?

ballardw — Mon, 20 Oct 2014 20:28:59 GMT

If the condition is simple such as a specific value the easiest may be a WHERE clause dataset option

data merged;

merge a (where=(age > 25))

b (where=(LastName ne 'Smith'))

;

by id;

run;

If multiple conditions using functions are needed you'll likely need to subset the data separately.