How to Exclude Random Missing point before performing PCA.

[#1]

Hi,

How to exclude missing values from the dataset before analysis. These are random missing values due to instrument malfunction. I don't want to impute my data. I have explored the 'Explore Missing Value' but that didn't help because that changes the interpretation of my PCA results.

Is there any other way to do so?

Thank you,

Beginner_9

[#2]

How does your data look like? Can you exclude the whole row? If you can, select one of the missing values, right click on it, select matching cells and then right click on the row number and hide and exclude

You can also use Explore Missing Values for this. Select the columns with missing values you wish to exclude and then click Exclude Rows