Recoding multiple columns not working

PNash

COLS = DEMAND << GET COLUMN NAMES;
FOR EACH ROW( FOR (I = 5, I <= N ITEMS(COLS), I++, IF(ISMISSING(COLS[I]), COLS[I]=0)));

I have 20+ columns that I need to recode from empty to 0.  I can't seem to get a loop to work, so I'm clearly missing something.  Can anyone help?

Mark_Bailey

I think you have to convert the character string representing the name to a column reference. You need to add empty [ ] so that JMP knows to index the row.

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
		);
	);
);