topic Re: problem with the where function to check for missing values in SAS Programming

problem with the where function to check for missing values

Ngo99 — Sun, 24 Apr 2022 09:05:43 GMT

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.

Re: problem with the where function to check for missing values

Kurt_Bremser — Sun, 24 Apr 2022 09:38:27 GMT

@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.

Re: problem with the where function to check for missing values

Patrick — Sun, 24 Apr 2022 10:13:57 GMT

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;