Interestingly, with PROC SQL's FEEDBACK option the log incorrectly states that a single blank was interpreted as a null string, whereas the log of a DATA step correctly describes the opposite interpretation of a null string in a WHERE condition:
648 proc sql feedback;
649 create table selsql as
650 select var from example
651 where findw(var,'unsold',' ','i');
NOTE: Statement transforms to:
select EXAMPLE.var
from WORK.EXAMPLE
where FINDW(EXAMPLE.var, 'unsold', '', 'i');
NOTE: Table WORK.SELSQL created, with 2 rows and 1 columns.
652 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.13 seconds
cpu time 0.12 seconds
653
654 data selds;
655 set example;
656 where findw(var,'unsold','','i');
657 run;
NOTE: There were 2 observations read from the data set WORK.EXAMPLE.
WHERE FINDW(var, 'unsold', ' ', 'i');
NOTE: The data set WORK.SELDS has 2 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
... View more
