Remove Rows where 3 out of 5 column values are identical

Accepted Solution Solved
Reply
N/A
Posts: 1
Accepted Solution

Remove Rows where 3 out of 5 column values are identical

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 NunberSerial NumSiteCustomerValue
123a1.5
123b2
345c3
234d5
234e6



Accepted Solutions
Solution
‎09-09-2014 03:36 PM
Super User
Posts: 19,167

Re: Remove Rows where 3 out of 5 column values are identical

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

View solution in original post


All Replies
Solution
‎09-09-2014 03:36 PM
Super User
Posts: 19,167

Re: Remove Rows where 3 out of 5 column values are identical

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 171 views
  • 0 likes
  • 2 in conversation