topic Re: Proc SQL Varchar fields in SAS Programming

Proc SQL Varchar fields

Maura001 — Mon, 07 Feb 2022 23:26:02 GMT

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?

Re: Proc SQL Varchar fields

Reeza — Mon, 07 Feb 2022 23:56:15 GMT

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?

Re: Proc SQL Varchar fields

SASKiwi — Tue, 08 Feb 2022 00:01:12 GMT

Try this: where MyVar is (not) missing