重新編碼多個列不起作用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>
但它奏效了!謝謝