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
... View more