looping the process capability function

jokerssd

i am trying to loop thru a bunch of column names selected by user(col_name)

then from those list, the code will run for each individual column 

 

the problem is i cant seem to make the JMP read the col_name[i] as a column ,it just read it as a string 

and state the column cannot be found in the data table 

/*****************************************************
*********************** Cpk *********************
*****************************************************/

cpk =expr( 
for (k=1,k<=n items(col_name),k++
	Process Capability(
		Process Variables( col_name[i]) ),
		
		Individual Detail Reports( 1 ),
		Capability Box Plots( 0 ),
		Goal Plot( 0 ),
		Capability Index Plot( 0 ),
		{choice[i] << Process Capability Analysis( Histogram( 0 ) )},
		Where( :Config == config[k] )
))
);

txnelson

I believe your only syntax issue is that you need an As Column() function around the col_name[i].

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );

dt:sex << set name( "Config" );
dt:height << set property( "spec limits", {LSL( 55 ), USL( 70 ), Show Limits( 0 )} );
dt:weight << set property( "spec limits", {LSL( 80 ), USL( 160 ), Show Limits( 0 )} );

config = {"F", "M"};

col_name = dt << get column names( string, continuous );


cpk = Expr(
	For( k = 1, k <= N Items( col_name ), k++,
		Process Capability(
			Process Variables( As Column( col_name[i] ) ), 
		
			Individual Detail Reports( 1 ),
			Capability Box Plots( 0 ),
			Goal Plot( 0 ),
			Capability Index Plot( 0 ),
			{choice[i] << Process Capability Analysis( Histogram( 0 ) )},
			Where( :Config == config[k] )
		)
	)
);

For( i = 1, i <= N Items( col_name ), i++,
	cpk
);

I am also a bit confused over your For Loop() using "k".  Are you sure you want to loop through 1 through N Items( col_name ).  It seems that col_name is being linked to the "i" variable?