data missing

Batista

Hi! I came up with a problem with the missing data when building a dataset.

I have a column with a million rows that are patient ID and a column with disease they have. I need to make  column named hypertension. So i go to the raw JMP file and "analyze >>> text explorer" and search for the word hypertension. After that I subset this search and I have a column header Hypertension and clinical Id and 1 for yes. But the problem is that way the zeros are patient without hypertension but also the one that data are missing. How to you deal with missing data?

Mark_Bailey

You can select the rows with missing values (right-click on one example and choose Select Matching Cells). Then select Rows >> Exclude before using Text Explorer.