is null statement producing wierd numbers

[vcujackson]

and giftlook1 ^= 'ng' or giftlook1 = ' '
or giftlook1 is null
this is part of a statement that is designed to eliminate a giftlook1 coded as 'ng'. Sometimes the giftlook field is blank or null. When I plug in

and giftlook1 ^= 'ng' or giftlook1 = ' '

I get close to what I want. When I plug in the
or giftlook1 is null

I get much larger numbers. The idea is to eliminate giftlook1 if it is null or blank.

Is there something wrong with the the way I am using null in this example

 

[Quehay]

There's no "is null" statement in SAS except in SQL statements.

Is this data step or PROC SQL?

 

[vcujackson]

proc sql