How to Use the CMISS Function in SAS (With Example)

You can use the CMISS function in SAS to count the number of missing values in each row of a dataset.

Here is one common way to use this function in practice:

data new_data;
    set my_data;
    total_missing = cmiss(of team -- assists);
run;

This particular example creates a new dataset called new_data that includes a column called total_missing that counts the number of missing values in each row between the columns named team and assists.

The following example shows how to use this syntax in practice.

Example: Use CMISS in SAS to Count Number of Missing Values in Each Row

Suppose we have the following dataset in SAS called my_data that contains information about various basketball players:

/*create dataset*/
data my_data;
    input team $ points assists;
    datalines;
Cavs 12 5
Cavs 14 7
Warriors 15 9
. 18 9
Mavs 31 7
Mavs . 5
. . 3
Celtics 36 9
Celtics 40 7
;
run;

/*view dataset*/
proc print data=my_data;

Notice that several rows have missing values.

We can use the CMISS function to count the number of missing values in each row:

The following examples show how to use each method in practice with the following dataset in SAS:

/*create new dataset that counts number of missing values in each row*/
data new_data;
    set my_data;
    total_missing = cmiss(of team -- assists);
run;

CMISS function in SAS