Your case expression has no logical expression. It should look something like this:
proc sql;
select distinct
Make
, CASE (/* Logical Expression */ Type )
WHEN 'SUV' THEN 'N'
ELSE 'Y'
END
from sashelp.cars
;
quit;
or like this:
proc sql;
select distinct
Make
,CASE
WHEN (type='SUV') THEN 'N'
ELSE 'Y'
END
from sashelp.cars;
quit;
e
... View more
