SAS - SQL- IS NULL

nIf a column in a table is optional, we can insert a new record or update an existing record without adding a value to this column. This means that the field will be saved with a NULL value.

Query:

üSELECT Proname, unitprice FROM ORDtbl
WHERE  Location IS NULL

üSELECT Proname, unitprice FROM ORDtbl

    WHERE Location IS NOT NULL