470443_en-US

liliconcom

jsl: how to plot using a list of groups?

following up from this post: https://community.jmp.com/t5/Discussions/Script-to-loop-thru-and-group-columns-by-name-dynamically/m-p/470274#M71439

 

I'm grouping 10k+ columns into groups by StepID, but now trying to plot them all.

 

I can't quite figure out how to tell it to plot by the list of all the groups. any advice?

 

 

/*plotting a basic Fit YbyX just to get pValues. Formatting and style done on final plot*/
ow1 = Oneway(
 Y( dtAggWide<<GET column="" group=""></GET>

ScriptingRe: jsl: how to plot using a list of groups?

You can most likely do it with something like this (you need EvalEvalExpr):

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << Group Columns("group1", {"height", "weight"});

Eval(
 EvalExpr(
  dt << Oneway(
   Y(Expr(dt << Get Column Group("group1"))), 
   X(:age)
  )
 )
);

See Insert one expression into another using Eval Insert, Eval Expr, Parse, and Substitute for more information and examples about Eval(EvalExpr())

Re: jsl: how to plot using a list of groups?

I'm sorry, i'm struggling here. 

I'm not sure why nesting the evalexpr?

is there not a way to replace the 

Y( dtAggWide<<GET column="" group=""></GET>

with a list of column groups?

 

I previously created this list, how can I swap this RecipeStepIndex into the Y groups

//Build and prefill an Array of names of the RecipeStepId
Summarize( dt, RecipeStepIndex = by( :RecipeStepId) );//get list of unique RecipeStepID's

 

Re: jsl: how to plot using a list of groups?

 

OK, so I've got this, but I'm not sure how I can keep looping and creating new terms inside the Y( section.

any advice?

 

colgroupNames = dt << get column groups names;<BR /><BR />/*plotting a basic Fit YbyX just to get pValues. Formatting and style done on final plot*/<BR />ow1 = Oneway(<BR />Y( dtAggWide<<GET column="" group=""></GET>, dtAggWide<<GET column="" group=""></GET>, dtAggWide<<GET column="" group=""></GET>),<BR />X( :ChamberId ),<BR />//By(:),<BR /><BR />//All pairs Tukey HSD test<BR />All Pairs(<BR />1,<BR />Confidence Quantile( 0 ),<BR />Difference Matrix( 0 ),<BR />LSD Threshold Matrix( 0 ),<BR />Connecting Letters Report( 0 ),<BR />Ordered Differences Report( 1 )<BR />),<BR />//invisible, //use this to speed up.<BR />);dtAggWide = current data table();
dtAggWide << set name( "AggWide");

RecipeStepIndex ={"10.0.0.0.0.0", "11.0.0.0.0.0", "12.0.0.0.0.0"} // column groups names. Each group has 100+ columns.

//trying to create a series of charts using the groups, looping through the groups
ow1 = Oneway(
 Y(  for( i = 1, i<=Nitems( RecipeStepIndex), i++,
   dtAggWide<<GET column="" group=""></GET>