You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.04.16 07:08:01