JMP User Community

Latest Discussions

List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

5765 views | 9 replies
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

2300 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

3367 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

4816 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

6994 views | 7 replies

Previous
Next

Latest Discussions

List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

5765 views | 9 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

4816 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

3184 views | 2 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

1752 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

4113 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

1017 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

1142 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

1545 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

1737 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

1458 views | 0 replies