SAS SQL Query Window User's Guide

Handling Missing Values

You can use the SQL Query Window to test for missing values in a data set. From the SQL QUERY TABLES window, select SAMPLE.EMPINFO from the list of Available Tables and add it to the list of Selected Tables. Select OK.

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

Select

View Where Conditions for Subset...

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

[IMAGE]

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.

[IMAGE]

Chapter Contents
Previous
Next
Top of Page