SAS按字段检查字段，并在0时输入字段名称

作者: 甲基蓝
发布时间: 2024-12-17 08:58:45 (1月前)
转自：

2 条回复

0#
回复此人
撩心 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 该 <code> VNAME </code> function将返回与数组引用对应的变量的名称。 </p> <pre> <code> data Have; input REFERENCE_DATE L_CONTRACT L_CONTRACT_ACTIVITY L_LFC L_CONTRACT_CO_CUSTOMER L_CONTRACT_OBJECT L_CUSTOMER L_CUSTOMER_RETAIL L_DPD L_GL_ACCOUNT L_GL_AMOUNT L_EXTRA_COST L_PRODUCT; datalines; 450 1 9 8 6 0 4 3 0 0 0 0 0 ; data want; length vars_with_zero $1000; set have; array L L_CONTRACT -- L_CUSTOMER_RETAIL; * accumulate the names of the variables that have a zero value; do _n_ = 1 to dim(L); if L(_n_) = 0 then vars_with_zero = catx(' ', vars_with_zero, vname(L(_n_))); end; run; </code> </pre> </DIV>

编辑

登录后才能参与评论