Many to one merges work fine with data step MERGE statement.
But you have to tell it what variable(s) to use to match them.
That is done with the BY statement.
You should have seen a note in the log warning that you forgot to include the BY statement.
Note that both datasets need to be sorted by the BY variable(s).
... View more