proc sql中的case相当于if

Yomoosun

于 2020-05-14 09:59:56 发布

阅读量532

点赞数

分类专栏： SAS编程文章标签： sas

本文链接：https://blog.youkuaiyun.com/sfpython/article/details/106113692

版权

SAS编程专栏收录该内容

16 篇文章

订阅专栏

本文详细介绍了在ProcSQL中使用CASEWHEN语句的方法，等效于IF条件语句，通过具体示例展示了如何处理缺失值，将NULL或缺失的机场代码、索赔类型、处置方式和索赔地点统一替换为Unknown。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;