PROC SQL实现独热编码更新后结果全为0的问题求助
PROC SQL实现独热编码更新后结果全为0的问题求助
大家好,我现在尝试用PROC SQL实现独热编码,根据la_education列的单元格值,把la_education_graduatea和la_education_notgraduatea这两个列分别更新为1或0。代码编译的时候没有报错,但运行后结果里这两个列全是0,看起来更新操作根本没生效,想请教下各位大佬问题出在哪里?
我的代码如下:
PROC SQL; /* Update the 'la_education_graduatea' column */ UPDATE DMLIB601.LOAN_APPROVAL_SORTED_DS SET la_education_graduatea = CASE WHEN UPCASE(TRIM(la_education)) eq 'GRADUATE' THEN 1 ELSE 0 END WHERE la_education IS NOT MISSING AND TRIM(la_education) NE ''; /* Update the 'la_education_notgraduatea' column */ UPDATE DMLIB601.LOAN_APPROVAL_SORTED_DS SET la_education_notgraduatea = CASE WHEN UPCASE(TRIM(la_education)) eq 'NOT GRADUATE' THEN 1 ELSE 0 END WHERE la_education IS NOT MISSING AND TRIM(la_education) NE ''; QUIT;
备注:内容来源于stack exchange,提问作者Terri . K Woon
相关产品推荐
相关产品推荐

