Error in loop to standarize numeric columns

gallardet

Hi. I have written a script to create new numerical columns from the formula to standardize but I get an error when evaluating the formula. What do I do wrong?
Thank you.

The script:

 

Names Default To Here( 1 );
dt = Current Data Table();
numericColNames = dt << get column names( string, numeric );
For( i = 1, i <= N Items( numericColNames ), i++,
New Column( Char( numericColNames[i] ) || "_Stand",&nbsp;
Numeric,&nbsp;
Continuous,&nbsp;
Formula( Col Standardize( :numericColNames[i] ) ) )
);

 

The error:

 

Name Unresolved: numericColNames 1 times At rows: {1} Operation: numericColNames, :numericColNames

 

txnelson

A column name like 1900 can confuse JMP, because it may not know if it should treat it as a number or a column name.  So one needs to specifically indicate that it is a column name by using the :Name() function...see the reworked script below

Names Default To Here( 1 );
dt = Current Data Table();
numericColNames = dt << get column names( string, numeric );
numericColNames = {"1900"}
For( i = 1, i <= N Items( numericColNames ), i++,
	Eval(
		Substitute(
				Expr(
					New Column( Char( numericColNames[i] ) || "_Stand",
						Numeric,
						Continuous,
						Formula( Col Standardize( __col__ ) )
					)
				),
			Expr( __col__ ), Parse( ":Name(\!"" || numericColNames[i] || "\!")" )
		)
	)
);