MERGE statement has more than one data set with repeats of BY values

[Tom]

So the Freq table shows what happened with your merge.

ANNUAL    8,461
BOTH     12,650
EXECCOMP    696

Total 21,807

For example it is showing that there were 696 observations from the executive comp table that did not match the annual table.

For each individual observation you can reference the SOURCE variable you created to see whether it got information from ANNUAL , EXECCOMP or BOTH.

[sastuck]

@Tom The source variable is very helpful. How can I tell SAS that I only want to keep rows with "BOTH" in the source variable?

Thanks!

[sastuck]

By original file do you mean the original csv that I imported? I think I messed up my data . . . should I start with a clean program?

[art297]

Yes. I think that would be a good idea!

Art, CEO, AnalystFinder.com