Remove Rows where 3 out of 5 column values are identical

[dcmocatta]

I having been trying to find a way to remove rows that have identical cells in some columns but not in others.

For example I want to find rows where values for columns PartNo, SerialNum and Site are identical but not Customer and Value. Then I want to delete one of these rows. In
this case I would be left with row 1,3 and 4-see below.

If the only way to do it is through SAS please include the script I need to open it from JSL.

Thanks

Part Nunber	Serial Num	Site	Customer	Value
1	2	3	a	1.5
1	2	3	b	2
3	4	5	c	3
2	3	4	d	5
2	3	4	e	6

[Reeza · Accepted solution]

Post this in the JMP forum instead, if you're using JMP.