I have a following matrix
matrix = {{1, 2, 3, 4, 5, 6, 7}, {2, 4, 6, 8, 10, 12, 14}, {3, 100, 9,
12, 15, 18, 21}, {4, 8, 12, 16, 20, 24, 28}, {5, 10, 15, 20, 100,
30, 35}, {8, 16, 24, 32, 40, 48, 100}, {9, 18, 27, 36, 45, 54,
63}};
I want to extract part of Matrix excluding rows that have 100 (I used 100 to represent missing observation in my data-set) as an element. I can get my results using the following codes:
result=Select[mat, #[[2]] != 100 && #[[5]] != 100 && #[[7]] != 100 &]
However, in my real data, I have a matrix with over 200 columns and I don't know the columns that have 100 as an element.
How can I obtain my results? If possible please let me know how I can get part of matrix excluding all columns that have 100 as an element. In this case my final matrix should be
Thank you in advance.