Hi All,
I have a bit of a difficult problem that I thought someone else might be able to suggest some possible alternatives and post some code that might work for me.
Some background, I have 2 datasets. "A" is a list of purchases, "B" is a list of credits for purchases (ie product returns).
What I would like to be able to do is remove items from dataset "A" where it has a matching record in dataset "B".
Dataset A
Cust Prod Cost
ABC1 123X $57
ABC1 998C $107
ABC1 998C $107
ABC1 567D $500
Dataset B
Cust Prod Cost
ABC1 998C $107
Resulting Dataset
Cust Prod Cost
ABC1 123X $57
ABC1 998C $107
ABC1 567D $500
As you can see there are 2 records that could have been matched between "A" and "B", however only one was removed because there was only one record in "B".
If anyone has some thoughts how this can be approached in SAS 9.1 that would be greatly appreciated.
Thanks in advance
DW
Changed the subject to indicate that this had been solved.
Message was edited by: DWW