topic Re: For Each() syntax in Discussions

For Each() syntax

StarfruitBob — Thu, 08 Jun 2023 16:44:35 GMT

Hello,

I'm looking to expand the number of values that can be used in the For Each() function. In the scripting index and handful of examples I've found within JMP community and JMP itself, combined, I've only seen a single value and index used: For each( { val1, index}, ... ). I'd like to use: For each( { val1, val2, ..., valn, index}, ...) . When I increase the number of values in the curly braces, a "too many arguments" error pops up.

Strangely, this error message states that the row number of the error corresponds to the total number of rows in the matrix that is passed into the For each() function, not the actual row number of that function in the script. I can confirm it's the number of values I'm attempting to use, and not the number of rows in the matrix I'm passing into the function, by changing the number of values to val1 & index only, which then works.

The matrix that is passed in has an equal number of columns as the number of values I want to pass into the For Each() function.

Any tips? Is this possible?

Re: For Each() syntax

jthi — Wed, 04 Jan 2023 17:26:11 GMT

For Each documentation in Scripting Index does cover this somewhat. Example for Across gives the best idea for syntax

Names Default To Here(1);
// Across multiple containers
x = {"a", "b"};
y = {"d", "c"};
For Each({{a, b}, index}, Across(x, y), Show(a||b, index));

Re: For Each() syntax

StarfruitBob — Wed, 04 Jan 2023 17:44:54 GMT

I've fiddled with the syntax as in the Scripting Index, but the same error still holds true. This must mean that there's something I'm not understanding with my particular setup. I need to test some more things and will post here on my findings and/or additional questions. Thank you, @jthi !

Re: For Each() syntax

StarfruitBob — Wed, 04 Jan 2023 18:37:16 GMT

I think this is another piece to the puzzle:

The Across() formatting for multiple containers is in use. With the number of values I have it makes sense, but this also requires Across(). Currently, I'm saving a data table to a matrix with

matrix1 = dt1 << Get as Matrix();

How is Across() properly populated to either work with that, or a data table correctly, since the number of items in Across() needs to equal the number of containers (values) in the curly braces?

Re: For Each() syntax

vince_faller — Wed, 04 Jan 2023 19:09:48 GMT

What are you actually trying to do? Or are you JUST trying to understand the syntax?

Re: For Each() syntax

StarfruitBob — Wed, 04 Jan 2023 19:27:53 GMT

I have 3 tables:

dt1: measured values & prediction formulas
dt2: target values (currently saved as matrix):

matrix1 = dt2 << Get as Matrix();

dt3: table to record coefficients from regression formula from (Prediction) Profiler tool

What I'm hoping to do is to use For Each() to iterate through dt2, use the corresponding prediction formula in dt1, and then record the corresponding coefficients that the (Prediction) Profiler generates. I'm sure I can do this with a standard For() loop, but was advised that For Each() would be a better option.

Re: For Each() syntax

vince_faller — Wed, 04 Jan 2023 21:24:49 GMT

Is this just to get absolute values of the prediction? I'm confused sorry.

Names default to here( 1 );
dt1 = open("$SAMPLE_DATA\Big Class.jmp");
fm = dt1 << Fit Model(
	Y( :height, :weight ),
	Effects( :age, :sex, :age * :sex ),
	Personality( "Standard Least Squares" ),
	Emphasis( "Effect Leverage" ),
	Run(
		:height << {Summary of Fit( 1 ), Analysis of Variance( 1 ),
		Parameter Estimates( 1 ), Lack of Fit( 0 ), Scaled Estimates( 0 ),
		Plot Actual by Predicted( 1 ), Plot Regression( 0 ),
		Plot Residual by Predicted( 1 ), Plot Studentized Residuals( 0 ),
		Plot Effect Leverage( 1 ), Plot Residual by Normal Quantiles( 0 ),
		Box Cox Y Transformation( 0 )},
		:weight << {Summary of Fit( 1 ), Analysis of Variance( 1 ),
		Parameter Estimates( 1 ), Lack of Fit( 0 ), Scaled Estimates( 0 ),
		Plot Actual by Predicted( 1 ), Plot Regression( 0 ),
		Plot Residual by Predicted( 1 ), Plot Studentized Residuals( 0 ),
		Plot Effect Leverage( 1 ), Plot Residual by Normal Quantiles( 0 ),
		Box Cox Y Transformation( 0 )}
	)
);
fm << Prediction Formula; //  

dt2 = new table("Targets", 
	<<New Column("age", <<Set Values([12, 14])), 
	<< New Column("sex", character, <<Set Values({"M", "F"}))
);

Eval(EvalExpr(dt2 << New Column("Pred Formula height", formula(Expr(dt1:Pred Formula height << Get Formula)))));
Eval(EvalExpr(dt2 << New Column("Pred Formula weight", formula(Expr(dt1:Pred Formula weight << Get Formula)))));

Re: For Each() syntax

StarfruitBob — Wed, 04 Jan 2023 21:30:52 GMT

@vince_faller , it's all good! Once a prediction formula is generated from a dataset (within dt1), I then want to use the ideal solution (within dt2) and work backwards to grab the coefficients needed to obtain this ideal value (saved in dt3). The prediction profiler displays the coefficients of the values necessary to do this, so I'd need to grab the values from the boxes.

I have a test using the For() loop going on as we speak, in the background. If it works, I can scrap using For Each() entire for this project. Although, now that I'm encountering issues, it makes me even more encouraged to understand why.

Re: For Each() syntax

MikeD_Anderson — Wed, 04 Jan 2023 21:43:00 GMT

There's a different structure to the arguments if you're trying to loop through matrices. If you look under the little pull down menu in the scripting index, there are examples of the different configurations the For Each() loop can take.

Best,

Re: For Each() syntax

StarfruitBob — Wed, 04 Jan 2023 21:48:44 GMT

Thank you, @MikeD_Anderson . I've already spent over a day going through each of these options, but the error I mentioned in the original post is what's blocking me.

Re: For Each() syntax

MikeD_Anderson — Thu, 05 Jan 2023 15:02:47 GMT

I think the piece you're missing in the examples is that the values you want to pull have to be in the form of a single value or a list. So For each( { val1, val2, ..., valn, index}, ...) wouldn't work because there's too much stuff in the argument list. But For each( { {val1, val2, ..., valn}, index}, ...) might work better. That's also in line with the example that @jthi provided earlier.

Re: For Each() syntax

StarfruitBob — Thu, 05 Jan 2023 22:39:57 GMT

Hello,

I've already investigated the double curly braces, but I'm running across the "too many argument" error as in my original post. I believe this because I haven't specified the correct number of containers in Across(). I do not know how to properly fill out Across().

At this time, my For() loop alternative is fleshing out very nicely and should replace the need for the For Each() function. However, I'd still like to learn how to use it properly, but perhaps I'll resurrect this thread at a different time. My focus is needed elsewhere for a while.

Thank you all for the discussion!