problem with the where function to check for missing values

[Ngo99]

hi, I am trying to check for missing values in the dataset.

Below is the code I used to check for missing values:

PROC PRINT data = WORK.IMPORT;
WHERE ID = ' ' OR name = .;
RUN;

Below is the error message after running the code:

ERROR: WHERE clause operator requires compatible variables.

[Kurt_Bremser]

---

@Ngo99 wrote:

hi, I am trying to check for missing values in the dataset.

Below is the code I used to check for missing values:

PROC PRINT data = WORK.IMPORT;
WHERE ID = ' ' OR name = .;
RUN;

Below is the error message after running the code:

ERROR: WHERE clause operator requires compatible variables.

---

I seriously doubt that a variable called "name" will be numeric. Check for the data types of the variables and use the proper missing values.

[Patrick]

To define a where clause syntax that deals with both numerical and character variables you could use the missing() function as below:

WHERE missing(ID) or missing(name);

or alternatively the cmiss() function:

where cmiss(id,name)>0;