JMP User Community

Latest Discussions

UPDATE JOIN SQL statement with JMP tables

Hi, I would like to update via SQL statement the :age column in dt1 with the values of dt2. dt1 = Open( "$SAMPLE_DATA/Big Class.jmp", output table("t1")); dt2 = subset(dt1); dt2:age[1] = 99; Query( Table( dt1, "t1" ), Table( dt2, "t2" ), "\[ UPDATE t1 SET t1.age = t2.age FROM t1 INNER JOIN t2 ON t1.name = t2.name ]\" );I got an syntax error near "." Thanks
TWE

Discussions |
Aug 30, 2020 11:23 PM

2008 views | 2 replies
How to find the mode of multiple columns and partial rows?

For example, add new columns with "Big Class. JMP ", and find the mode of the data in the same row of the "height"、"weight" columns and the five rows above. Thanks! mode(Range(:weight[Index(Row()-5,Row())], :height[Index(Row()-5,Row())]))
lwx228

Discussions |
Aug 30, 2020 5:47 PM

2828 views | 6 replies
Partition Modelling: What dictates Minimum Size Split?

I am not a de facto statistician but have gained much experience in biostatistics over many years, thanks largely to using the standard version of JMP (currently v13). I certainly cannot imagine using anything else and regularly promote it.I am presently progressively defining partitions in a variety of continuous variables to optimise outcome in a binomial categorical variable (fail versus pass)....
34South

Discussions |
Aug 30, 2020 2:02 PM

4234 views | 4 replies
k-fold cross-validation with bootstrap forests model and standard least squares regression

Hi,
Is it possible to use k-fold cross-validation with bootstrap forests model and standard least squares regression in JMP?
I have done the k-fold cross-validation with neural networks model, and I am looking for some methods which could use the same cross-validation, so that I can do model comparisons.
Thank you.
Adele

Discussions |
Aug 29, 2020 7:11 PM

6337 views | 7 replies
How to save a file with name as a variable in For loop to save multiple files

Hi, I am trying to save files in a for loop, the problem is how to put a variable into the file saving procedure, However, it looks the file save part is not working. I didn't use any clear global to make sure filename has be assigned with the original value. Is there any problem with my saving part? Thanks // filename is a variable assigned below, For( j = 1, j <= N Row( sdt ), j++, filename...
Stokes

Discussions |
Aug 28, 2020 4:29 PM

2853 views | 2 replies

Previous
Next

Latest Discussions

Partition Modelling: What dictates Minimum Size Split?

I am not a de facto statistician but have gained much experience in biostatistics over many years, thanks largely to using the standard version of JMP (currently v13). I certainly cannot imagine using anything else and regularly promote it.I am presently progressively defining partitions in a variety of continuous variables to optimise outcome in a binomial categorical variable (fail versus pass)....
34South

Discussions |
Aug 30, 2020 2:02 PM

4234 views | 4 replies
How to save a file with name as a variable in For loop to save multiple files

Hi, I am trying to save files in a for loop, the problem is how to put a variable into the file saving procedure, However, it looks the file save part is not working. I didn't use any clear global to make sure filename has be assigned with the original value. Is there any problem with my saving part? Thanks // filename is a variable assigned below, For( j = 1, j <= N Row( sdt ), j++, filename...
Stokes

Discussions |
Aug 28, 2020 4:29 PM

2853 views | 2 replies
Box Plots Shifted in Graph Builder

For some reason I can't figure out, my box plots are appearing on either side of the ordinal x-axis line in this graph building chart. I can see the boxes well enough but why off-center (left of the grid line on the LHS and right of the grid line on the RHS)? Running on Mac, JMP® 14.2.0 Thanks!
datanaut

Discussions |
Aug 28, 2020 7:30 AM

4585 views | 5 replies
How to get lowest two row values in grouped data ?

Hi, Lets say we have data like this and want to get lowest two row values. Group by Age and Sex, get the two lowest height values. How can we do this in JSL? Thanks
joshua

Discussions |
Aug 27, 2020 11:44 AM

1561 views | 1 replies
Selecting rows and then further selecting based on that

I have a data table where I can select rows based on one columns result. I would like to then expand that selection based on a value contained in the previously selected rows. I tried dt = Current Data Table(); dr << select where( :ctrlrange > 0.23 ); h = Column( dt, "reagentkit_id" ) << get Values; dt << select where( :reagentkit_id == h ); That didnt seem to work as JMP froze. The dat...
UberBock

Discussions |
Aug 27, 2020 9:13 AM

3450 views | 8 replies

Previous
Next

Latest Discussions

order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

899 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

1005 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1318 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1564 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1315 views | 0 replies