JMP User Community

Latest Discussions

jsl - How to open the most recent file with a specific naming convention?

Hi everyone,How do I script jsl to open the newest file in a directory that contains a specific naming convention? I have the following code which will open the newest file in the directory:( OpenNewestFile = Files In Directory( "C:\users\me\MyDocuments\" ); {t,p}={0,1}; for(i=1, i <= n items(OpenNewestFile),i++, ti=Last Modification Date("C:\users\me\MyDocuments\" || OpenNewestFile ); If(ti>...
rrtx_mike

Discussions |
Apr 3, 2025 2:17 PM

4661 views | 3 replies
Importing Data from txt file with lines of data every 10th row

New jmp user here. I have a large text file with data on every 10th row starting on line 6. My column headers are on line 4 and I want to use fixed width fields, but it shifts the first 3 headers to the right when I select my own column width.
cschultz32

Discussions |
Apr 3, 2025 1:19 PM

120 views | 5 replies
Script to Colour Passing or Failing Cells

Anyone ever generate a script to colour cells that pass dt = Current Data Table(); // Get all numeric columns colList = dt << get column names( numeric, string ); foundCols = ""; // Loop across the columns and generate the test pass/fails Try(For( i = 1, i <= N Items( colList ), i++, spec = Column( dt, colList[i] ) << get property( "Spec Limits" ); //Establish the Notes Value from the Parent...
SpannerHead

Discussions |
Apr 3, 2025 12:30 PM

110 views | 3 replies
Detection Limit in Definitive Screening Design

I'm running a DSD DOE in JMP18 Pro with 2 categorical factors (Factor A (level A1, A2), Factor B (level B1, B2) and 2 continuous factors (Factor C, Factor D). My goal is to select the better Level in each Factor A, and B (e.g., either A1 or A2, B1 or B2) including any two-way interaction terms for all factors and estimate the quadratic terms in Factor C, D. I chose to add 8 more runs with blocks t...
D_P2025

Discussions |
Apr 3, 2025 11:20 AM

107 views | 6 replies
Why does the Sum of Squares under "Effect Tests" not add up to the overall model's Sum of Squares?

Hi all, I fitted a simple model with one continuous and one nominal variable using Standard Least Squares. Now I am wondering why the sums of squares seem to mismatch under Analysis of Variance and Effect Tests. I am on JMP 18.0.1. 3.16 and 0.01 do not give the overall model's SS of 3.37. It's like some 0.2 are missing. Could anyone please explain why that is? This particularly puzzles me bec...
Bashburz1

Discussions |
Apr 3, 2025 10:38 AM

48 views | 1 replies

Next

Latest Discussions

jsl - How to open the most recent file with a specific naming convention?

Hi everyone,How do I script jsl to open the newest file in a directory that contains a specific naming convention? I have the following code which will open the newest file in the directory:( OpenNewestFile = Files In Directory( "C:\users\me\MyDocuments\" ); {t,p}={0,1}; for(i=1, i <= n items(OpenNewestFile),i++, ti=Last Modification Date("C:\users\me\MyDocuments\" || OpenNewestFile ); If(ti>...
rrtx_mike

Discussions |
Apr 3, 2025 2:17 PM

4661 views | 3 replies
Importing Data from txt file with lines of data every 10th row

New jmp user here. I have a large text file with data on every 10th row starting on line 6. My column headers are on line 4 and I want to use fixed width fields, but it shifts the first 3 headers to the right when I select my own column width.
cschultz32

Discussions |
Apr 3, 2025 1:19 PM

120 views | 5 replies
Why does the Sum of Squares under "Effect Tests" not add up to the overall model's Sum of Squares?

Hi all, I fitted a simple model with one continuous and one nominal variable using Standard Least Squares. Now I am wondering why the sums of squares seem to mismatch under Analysis of Variance and Effect Tests. I am on JMP 18.0.1. 3.16 and 0.01 do not give the overall model's SS of 3.37. It's like some 0.2 are missing. Could anyone please explain why that is? This particularly puzzles me bec...
Bashburz1

Discussions |
Apr 3, 2025 10:38 AM

48 views | 1 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 3, 2025 8:24 AM

62 views | 2 replies
Nested Lists

I have somehow generated a nested list of columns due to them having been initially grouped. I would like to remove the nesting to have a continuous list of columns I can act on. Instead of {{:A, :B, :C}, (:D, :E, :F}}, I would like to get to {:A, :B, :C, :D, :E, :F}
SpannerHead

Discussions |
Apr 3, 2025 8:24 AM

140 views | 5 replies

Next

Latest Discussions

JMP 18 Set Script difference to JMP 17

Hello, I have recently updated to JMP 18 and I am noticing a difference to the set script function when used in an application script. On JMP 17 I could right click the created box and click Set Script to modify the script directly. On JMP 18 though when I try and do the same thing the script is not in the script editor and I have to revert back to the application. Is this a preference t...
ralphtedesco

Discussions |
Apr 2, 2025 9:12 AM

55 views | 0 replies
How do I get the psqlodbc driver installed on MacOS?

I'm trying to get the psqlodbc driver (https://odbc.postgresql.org/) installed on an M2 Macbook Pro in order to have JMP connect to a PostgreSQL database within my organization. I was wondering where I can find some documentation on how to do so.

So far, this link (https://odbc.postgresql.org/docs/unix-compilation.html) is all I've found and the commands under its installation instructions involve...
BackwardOctopus

Discussions |
Mar 31, 2025 10:20 AM

101 views | 0 replies
Scale IDs in Add Graphics Script not working

I created a script to draw graphs from JSON objects, which works well, but when I tried to overlay one graph on another using two Y axes, I could not get it to work; it always used the left Y axis. I thought I was doing something wrong, but I finally realized that even the example in the Scripting Guide does not work as it should. This example is supposed to use the right Y axis, labeled "Test,"...
mmarchandFSLR

Discussions |
Mar 27, 2025 5:13 AM

75 views | 0 replies
デザインスペースの領域が一致しません。

JMPの練習のため、論文のデータを用いて解析・再現をしています。その中で3つの不純物に対してPlackett-Burman計画によるスクリーニング・中心複合計画による最適化を実施し、予測モデルを作成しました。論文中に記載されている予測モデル式はいずれも同様のものが作成できました。論文中では最適化の過程でプーリングをしていますが、モデルを合わせたデザインスペース作成のため、すべてのパラメーターを含むモデルを使用したと記載があります。これに従い、プーリングしない状態、すなわちすべてのパラメーターを含む状態で予測モデル式を作成し、デザインスペースを作りました。しかし、不純物が0.1%以上となるデザインスペースのエリアが一致せず、私の作成したものの方が広くなっています。デザインスペース作成に用いた予測モデルの式は記載がないため不明ですが、原因はどこにあるのでしょうか。つた...
keita_

Discussions |
Mar 23, 2025 10:48 PM

85 views | 0 replies
Problems with Reproducibility

I teach using JMP and I became aware of some reproducibility problems in the following cases: 1) My students who use different operating systems like windows and MacOS get different results from models that require randomization like NN even if they use the same random seed like 123. This problem is frustrating because assignments that use a random seed for reproducibility reasons are supposed t...
onurseref

Discussions |
Mar 23, 2025 9:28 AM

122 views | 0 replies