Hi Gurus,
When i connect to Database server like Oracle, i know that it treats Null value differently from SAS, Do you think it fixs the problem if i assign every variable (which is in where clause) is missing ?
Thanks
Unlike SAS most database system will use a tri-level logic with respect to missing values. In SAS a boolean test is either true or false. In DBMS the result can be unknown or null which is treated as neither true nor false.
For example in SAS a numeric missing value is less than any actual number and you can test for equality between missing values. So missing values would be included in tests like these:
age < 10
age ne 10
age = baseline_age
But in most DBMS you need to explicitely include the NULL values in your testing.
age < 10 or age is null
age ne 10 or age is null
age = baseline_age or (age is null and baseline_age is null)
Hi LinusH,
I want to include those Null value, but when i set
select ColA ColB from table where ColA!=1,
then the result exclude all null value, in case i want it
Unlike SAS most database system will use a tri-level logic with respect to missing values. In SAS a boolean test is either true or false. In DBMS the result can be unknown or null which is treated as neither true nor false.
For example in SAS a numeric missing value is less than any actual number and you can test for equality between missing values. So missing values would be included in tests like these:
age < 10
age ne 10
age = baseline_age
But in most DBMS you need to explicitely include the NULL values in your testing.
age < 10 or age is null
age ne 10 or age is null
age = baseline_age or (age is null and baseline_age is null)
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: