重新编码多个列不起作用COLS = DEMAND << GET COLUMN NAMES;
FOR EACH ROW( FOR (I = 5, I <= N ITEMS(COLS), I++, IF(ISMISSING(COLS[I]), COLS[I]=0)));
我有20多列我需要从空重新编码为0。 我似乎无法获得循环工作,所以我显然遗漏了一些东西。 有人可以帮忙吗?
Re:重新编码多个列不起作用我认为你必须将表示名称的字符串转换为列引用。您需要添加empty []以便JMP知道索引该行。
COLS = DEMAND << GET COLUMN NAMES;
For Each Row(
For( I = 5, I <= N Items( COLS ), I++,
If( Is Missing( As Column( COLS[I] )[] ),
As Column( COLS[I] )[][] = 0
);
);
);
Re:重新编码多个列不起作用我必须对您的代码进行的唯一调整是
<SPAN class="token function">As Column</SPAN><SPAN class="token punctuation">(</SPAN> COLS<SPAN class="token punctuation">[</SPAN>I<SPAN class="token punctuation">]</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">[</SPAN><SPAN class="token punctuation">]</SPAN><SPAN class="token punctuation">[</SPAN><SPAN class="token punctuation">]</SPAN> <SPAN class="token operator">=</SPAN> <SPAN class="token number">0</SPAN>
至
<SPAN class="token function">As Column</SPAN><SPAN class="token punctuation">(</SPAN> COLS<SPAN class="token punctuation">[</SPAN>I<SPAN class="token punctuation">]</SPAN> <SPAN class="token punctuation">)</SPAN><SPAN class="token punctuation">[</SPAN><SPAN class="token punctuation">]</SPAN> <SPAN class="token operator">=</SPAN> <SPAN class="token number">0</SPAN>
但它奏效了!谢谢