topic Re: passing variables to variability chart in Discussions

passing variables to variability chart

rahulsmils — Fri, 23 Sep 2016 15:24:21 GMT

Hi all,

I am new to jmp. So please overlook syntax.

I am trying to plot a variability chart as below:

Variability Chart(

X( :age :height :gender ),

......

----------------

age, gender , height are data columns

I want to make arguments to X variable and store it separately.

Something like declaring first

Xarg_list=[:age :height :gender ]

and then using:

Variability Chart(

X=Xargs_list;

......

----------------

So If I want to add new column of weight or delete any column in list of arguments I just need to change Xargs_list

Xarg_list=[:age :height :gender :weight];

Any help with forming correct syntax is welcome.

Thanks

Re: passing variables to variability chart

txnelson — Mon, 12 Feb 2018 19:36:45 GMT

Here is an example that provides the functionality you are seeking.

Names Default To Here( 1 );
 
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
 
xlist = {"age", "sex"};
 
dt << Variability Chart(
       Y( :height, :weight ),
       X( Eval( xlist ) ),
       Max Iter( 100 ),
       Conv Limit( 0.00000001 ),
       Number Integration Abscissas( 128 ),
       Number Function Evals( 65536 ),
       Analysis Type( "Choose best analysis (EMS REML Bayesian)" ),
       Std Dev Chart( 1 )
);

It appears that you are not aware that you can get JMP to produce the scripts that you desire, by just interactively running the platform you want, and then clicking on the red triangle and go to "Script" and to request to save the script to the Script Window. It gives you a leg up in creating your scripts.

Re: passing variables to variability chart

rahulsmils — Sat, 24 Sep 2016 20:14:19 GMT

Thanks, actually i figured out a way to do this by grouping columns into a column group first and then using get column group command to get the items.

However there when doing get column groups the order of columns changed from my original assignment.

I will try this one to see if it retains order.

Thanks !

Re: passing variables to variability chart

Trung — Mon, 12 Feb 2018 19:37:32 GMT

hi Jim,

can you help me to figure out the concern below?

I have 2 data table: table 1 and table 2

i want to run script variability chart for table 2, but need to have variable to get value from table 1,

below is the example script detail, but it doest not work, please help to review and correct it

A={};
Open(table1);
A[i]=column name(i); // want to use A[i] as variable to get value from table 1 ( for for loop to get)
Open(table2);
Variability Chart(
Y(show(A)),    // this one does NOT work, please help
X( :Product, :Mequip, :Source_Lot, :lot_id ))
));

thanks,

regards,

Trung

Re: passing variables to variability chart

txnelson — Sat, 21 Oct 2017 12:42:36 GMT

Trung,

The Show() function displays values to the log window. It does not place the values into the JSL code. I believe what you want is to use the Eval() function to evaluate the elements in the list "A".

Eval( A )

Re: passing variables to variability chart

Trung — Mon, 12 Feb 2018 19:38:05 GMT

hi Jim,

thanks for your prompt feedback,

i try to take simple script as below but it still doest not work, please advise more

A=column name(13);
New window("my report", obj = context box(
Variability Chart(
Y(eval(A)),   // not come out with exact text "
X( :Product, :Mequip, :Source_Lot, :lot_id ))
));
 
 
//it is okay if i change as below
New window("my report", obj = context box(
Variability Chart(
Y(:column name(13)),   //  it is working
X( :Product, :Mequip, :Source_Lot, :lot_id ))
));

Re: passing variables to variability chart

txnelson — Sun, 22 Oct 2017 14:55:33 GMT

Trung,

The reason the Eval() did not work, is that you changed the structure of your code. In your first example, you placed the column name into a list:

A = {};
A[i] = Column Name(i);

In your second version of the code, you changed the variable "A" to a scaler variable

A=column name(13);

Please take the time to read the Scripting Guide, so you can discover the different code structures within JSL, and how to implement them. It will make your path into JSL much easier and faster.

Help==>Books==>Scripting Guide

Re: passing variables to variability chart

Trung — Mon, 12 Feb 2018 19:38:47 GMT

thanks Jim, i just figured out why it did work,

below is the mistake

Variability Chart(
Y(eval(A[i])),  // A[i] is not work
X( :Product, :Mequip, :Source_Lot, :lot_id ))

thank you for your advice, i am just new to JMP too, i will learn more on Scripting Guide.

thank you very much.

Best regards,

Trung

Re: passing variables to variability chart

wu — Tue, 15 Jan 2019 17:16:51 GMT

Appreciate if you advise the following two questions:

(1). In the following of Bivariate plot, the line By(eval(bylist[2])), didn't work;

how to go around by uisng dynamic variables?

(2). I used lines: r=obj<<report; r[outlinebox(3)]<<close all like this;

To minimized the outlinebox, is there way to remove them from the plots, so the Bivariate plot only showed plots without other outlineboxes.

Thanks.

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
xy_list = {"weight","height"};
bylist={"sex","age"};
groupbylist={"sex"};
obj=dt << Fit Group(Bivariate(
Y(Eval(xy_list[2] )),
X(Eval(xy_list[1])),
By(eval(bylist[2])); // this line didn't work, has to use By(:age);
Group by(eval (bylist)),
Fit Spline(0.1,Standardized, {Line Width(3)}),
Std Dev Chart(0 ),
SendToReport(
Dispatch(
{},
"Bivar Plot",
FrameBox,{Framesize( 200, 200 ),YAxis( Show Major Grid ),
Row Legend(:sex,Color(1), Color Theme("JMP Default"),Marker(0), Marker Theme(""),
Continuous Scale(0), Reverse Scale(0), Excluded Rows(0))})
),Show Points( 1 )
),<<{Arrange in Rows(4)},);
r=obj<<report;
r[outlinebox(3)]<<close all like this;

Re: passing variables to variability chart

ms — Tue, 15 Jan 2019 17:08:56 GMT

1) It should work as is with comma instead of semicolon after By(...) argument.

2) Try this to delete all outlineboxes except the ones holding the graphs

(r << xpath("//IfBox/OutlineBox")) << delete;

Re: passing variables to variability chart

wu — Tue, 15 Jan 2019 18:43:05 GMT

Thanks.
Could you understand how this script works:
(r << xpath("//IfBox/OutlineBox")) << delete;

Re: passing variables to variability chart

txnelson — Tue, 15 Jan 2019 19:28:21 GMT

The xPath() function is described in the Scripting Index

Help==>Scripting Index...........search for xpath

But in @ms example, the xPath() function looks through all of the display output to find all of the examples where an IfBox() is followed by an OutlineBox(), and returns all found examples, to which the <<delete message is passed to them, and that closes the Outline Boxes. Look into the Scripting Guide for information on how to work with the Display Tree output in JMP

Help==>Books==>Scripting Guide

Re: passing variables to variability chart

wu — Mon, 25 Feb 2019 20:21:27 GMT

How to pass a variable value to the char option of
x=1; Std Dev Chart( x );
Thanks.