JMP User Community

Latest Discussions

JSL script - After update table, run the embedded formula

Hi,I am trying to update my existing table on column name "Capacity". As you can see in the picture below, once the Capacity column is updated, "Predicted_Shipment_1" column need to change the value according to the fomula embedded inside. However, once I run the script below, the value in "Predicted_Shipment_1" column does not change according to the updated Capacity column. Is there anything wro...
ReginaHong

Discussions |
Oct 30, 2018 12:14 AM

5849 views | 2 replies
enter value in specific cell

Hello,new little problem.I would like to enter a value in a specific cell by1) row name2) column namefor exampleI would like to enter value 25 in cell row (from col1) = 4 col = SYNCol1SYNMIS11021532045678best regardsLionel
KinKame

Discussions |
Oct 29, 2018 2:27 PM

23058 views | 10 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3253 views | 0 replies
Populate a table using table variables

I am trying to populate a table using the table variables. ( sample table attached)The first 3 columns of the table are created from the table variable name and the 4th column is the table variable value row 1 : target[0].target__reflectance_pc = 3 :Ambient_level W/m2 = 0 :zone_id_r =1 :Result = 400row 2 : target[0].target__reflectance_pc = 3 :Ambient_level W/m2 = 0 :zone_id_r =2 :Re...
David_Morrow

Discussions |
Oct 29, 2018 7:38 AM

5048 views | 2 replies
Date: Date Type, Modeling Type and Format -> How to fix MMM/YYYY

Data in format MMM/YYYY (001/2019, 002/2019, ...012/2019) is being imported as Date Type Character, Modeling Type Nominal.
I'm trying to get JMP to recognize this as a date. The final format isn't import per se. I show a format below just as an example.

I've tried scripting two ways to fix with no luck. The column name is "MMM/YYYY" [fail #1] names default to here(1); dt = current data table();...
BSwid

Discussions |
Oct 28, 2018 2:10 PM

5449 views | 2 replies

Previous
Next

Latest Discussions

Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3253 views | 0 replies
how to adjust Bivariate plot x axis scale with weekly date/time data

Hello everyone: This is my first posting. I am still a neophite with JSL and I've been trying to solve my problem for couple of days. Here is the problem setup... I have a datafile that I need to analyze every Friday. This datafile consists of a date/time log of some values captured real time. So every Friday, this datafile has a new date range. I wrote a script to plot this data in a bivariate pl...
abpc1

Discussions |
Oct 27, 2018 7:13 PM

3098 views | 1 replies
Need help getting a MATLAB structure as a JMP data table

I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
thamilton

Discussions |
Oct 25, 2018 6:47 PM

2686 views | 1 replies
How to use max among several column with "get rows where" condition

It seems an easy question but I'm struggling to solve it...I have this kind of data table : It goes until 64 which is the parameter "dim" in my script.I'm looking for the maximum and minimum of all median_range_mm 1, 2 , 3 ... until 64. But I don't want JMP to look at rows where target_status is different of 5 or 9.As you can see, when target status is 10 it overranges at 39996.It is easier to ...
Rob128

Discussions |
Oct 25, 2018 1:47 AM

3979 views | 3 replies
closing all data tables but leave one open for further analysis

Hi All This is a follow up on the post: https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739 However, I have encountered an error on my script while running JSL Debgger. DontClose = ("dt4"); // Example names of tables you want to leave // Loop backwards through the list, so the table numbers do not change For( i = N Table(), i >= 0, i--, If( Contains(...
ivomdb

Discussions |
Oct 24, 2018 5:13 AM

14609 views | 7 replies

Previous
Next

Latest Discussions

Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3253 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3680 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2514 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3511 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2508 views | 0 replies