JMP User Community

Latest Discussions

Setting values to a cell

Hello all,It's been some time since I did any programming in JSL, so I'll be asking some basics questions which I did not find in the manuals.1. How, using a JSL, I can set a specific value to a specific Col/Row?2. I need to do that in a For loop. Let's say I need to run a loop from 1 to number of rows, and assign (for now) the same number to each Row of a Specific column. How do I do that this wa...
miguello

Discussions |
Aug 29, 2016 7:04 AM

13505 views | 2 replies
Hexadecimal to decimal

I have a column that has number in the format of 0x1, 0x5, 0xe - how do I convert these hexadecimal to decimal?Thanks!
miguello

Discussions |
Aug 29, 2016 5:07 AM

17358 views | 3 replies
Cycle detected for data column

Hello, AllI am making a model that requires some "loop feedback", and it is giving me this error:Do you know how to get around it?I do not have this problem in Excel using the same formulaeThank you,-JoseUPDATE:I was able to make it run, but it will only execute the formula on one row at the time.I am attaching the table script for reference.You will see that two columns are dependent from each ot...
gutloja

Discussions |
Aug 28, 2016 10:56 AM

7482 views | 4 replies
Is there a way to save a subsetted table back to the originating / primary table (similar to save script) ?

As above
John_K

Discussions |
Aug 28, 2016 10:32 AM

11086 views | 3 replies
Match columns on table update using string

Hello,I'm trying to update one data table with columns from another table, using matching columns criteria defined by a string.In the example below, dt1 is my main table, and dt2 is a sort of config file containing the column to add (i.e. "ROUTE"), while all other columns are used in matching to dt1. Since dt2 is user-defined, I can't know these other column names ahead of time, hence the need to ...
rhakim_gmail_co

Discussions |
Aug 27, 2016 5:55 AM

10799 views | 3 replies

Previous
Next

Latest Discussions

Cycle detected for data column

Hello, AllI am making a model that requires some "loop feedback", and it is giving me this error:Do you know how to get around it?I do not have this problem in Excel using the same formulaeThank you,-JoseUPDATE:I was able to make it run, but it will only execute the formula on one row at the time.I am attaching the table script for reference.You will see that two columns are dependent from each ot...
gutloja

Discussions |
Aug 28, 2016 10:56 AM

7482 views | 4 replies
control chart with multiple items how to save summaries in one table

I have a control chart (cc) window with multiple items (i.e. each item has a control chart). In jsl, when I use cc<< Save Summaries, it pops up a summary table for each item. How can I save all summaries in one table with item name identified? Thank you.
qy6b0

Discussions |
Aug 25, 2016 5:29 PM

8190 views | 5 replies
Extract list from Get List Check-command

Using the Get List Check command I get the following:LC = col << Get List CheckThe Log will showLC = List Check({"Argon", "Krypton", "Air"});How do I extract the list from inside the List Check()-statement? I want to end up with a variable containing the list.LC_list = {"Argon", "Krypton", "Air"}
martin_snogdahl

Discussions |
Aug 24, 2016 2:35 AM

4458 views | 1 replies
Automatic Recalc

Is is possible to select Automatic Recalc in Preferences? I have looked for it but cannot find it there. Auto Recalc is a very useful feature in some other software packages I use and it would be great in JMP.
Steven_Moore

Discussions |
Aug 23, 2016 4:52 PM

11160 views | 6 replies
Add script to ButtonBox in jmp report

Dear communityI think my problem is a simple one, but all the same I could use some help. I am using the profiler platform with the added simulator to create a monte carlo simulation of a response with several factors: MyProfiler = Profiler( Y( :Response) ); MyProfiler << Simulator( Factors( Factor 1 << Random(Normal()), Factor 2 << Random(Normal()) ); I want to add some functionality to ...
martin_snogdahl

Discussions |
Aug 19, 2016 7:14 AM

13094 views | 5 replies

Previous
Next

Latest Discussions

Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4868 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3884 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5153 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3593 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3570 views | 0 replies