09-09-2014 03:34 PM
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.
|Part Nunber||Serial Num||Site||Customer||Value|
Need further help from the community? Please ask a new question.