data test;
set d9;
len1=klength(联系手机);
len2=length(联系手机);
customer_id_1=ksubstr(联系手机,1,len1);
run;
data test;
set test;
len3=length(customer_id_1);
run;
data test_1;
set test;
if len2^=len3;
/*keep customer_id customer_id_1;*/
run;
data test;
set d9;
len1=klength(联系手机);
len2=length(联系手机);
customer_id_1=ksubstr(联系手机,1,len1);
run;
data test;
set test;
len3=length(customer_id_1);
run;
data test_1;
set test;
if len2^=len3;
/*keep customer_id customer_id_1;*/
run;
本文标题:检测导入数据是否字段完整
本文链接:https://www.haomeiwen.com/subject/ibszkqtx.html
网友评论