SAS CMISS Function Example

What is it?

• The CMISS function returns the count of missing Variable Characters e.g. (Varchar) values from a list or dataset.
• Alternatively there is a similar function used for numeric values; NMISS
• Does not work in Macro Variables; Macro Variabiles will require additional syntax e.g. (.)

Syntax:

• CMISS(Varchar, Varchar, ..., Varchar_n);

SAS CMISS:

 SAS CMISS Example:

Data work.my_data_file;     Result_1 = CMISS('A', 'B', '');     Result_2 = CMISS('A', 'B', '55');     Result_3 = CMISS('!', '%');     Result_4 = CMISS('', ' ', ' '); Run;

What's happening in the script above?

• The above script has 4 examples, that demonstrate the missing, blank or empty values from the set, list, array wrapped by the CMISS function

CMISS Function In SAS Examples:

Variable	Input	Output	Description
Result_1	'A', 'B', ''	1	Returns the number of missing varchar values; 1
Result_2	'A', 'B', '55'	0	Returns the number of missing varchar values; 0
Result_3	'!', '%'	0	Returns the number of missing varchar values; 0
Result_3	'', ' ', ' '	3	Returns the number of missing varchar values; 0

See also; NMISS Function