Customizing Your Session and Using Advanced Features

Handling Missing Values

You can use the SQL Query Window to test for missing values in a data set. This example generates a list of employees whose education level is not known.

From the SQL QUERY TABLES window, select SAMPLE.EMPINFO from the Available Tables list and add it to the Selected Tables list. Select OK.

In the SQL QUERY COLUMNS window, select NAME and Education level from the Available Columns list and add them to the Selected Columns list.

Select View Where Conditions for Subset.

In the WHERE EXPRESSION window, select Education level from the Available Columns list. Select Is Missing from the OTHER Operators list.

[Using the Is Missing operator]

Select OK to return to the SQL QUERY COLUMNS window.

Select Tools Run Query Run Immediate to display a list of employees whose education level is missing from the data set.

[Query output]

Top of Page