I have been running my SQL in SQL Server. I created a Proc SQL statement in SAS. The where statement for SQL Server specifies IS NULL and is not NULL for a individual varchar fields. What is the best way to add this criteria in SAS?
SAS treats them as missing. Note that you can still use NULL in your SQL queries but the MISSING() function is likely what you want to use. And conveniently the same for numeric/varchar.
where value is null;
where value is not null;
where missing(variable)
where not missing(variable);
@Maura001 wrote:
I have been running my SQL in SQL Server. I created a Proc SQL statement in SAS. The where statement for SQL Server specifies IS NULL and is not NULL for a individual varchar fields. What is the best way to add this criteria in SAS?
Try this: where MyVar is (not) missing
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.