proc sql中的case when相当于if
proc sql;
create table c3 as
SELECT
case
when Airport_Code is missing then "Unknown"
else Airport_Code
end as Airport_Code,
case
when Claim_Type is missing then "Unknown"
else Claim_Type
end as Claim_Type,
case
when Disposition is missing then "Unknown"
else Disposition
end as Disposition,
case
when Claim_Site is missing then "Unknown"
else Claim_Site
end as Claim_Site
from claim_clean;
quit;