How to exclude certain observations in a merge step?

[Maisha_Huq]

Hi:

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

Thanks!!

[ballardw]

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.