JMP User Community

Latest Discussions

Set the correct scale of a graph

Hi Community!

I have a script in which i create many distributions and then i print the Lower and Upper TI lines on the histograms. The problem is that sometimes the Lower and Upper TI are outside of the visualized region and i need to manually change the scale of every graph. On the opposite, i tried to store in variables the Lower and Upper TI values and to use them to set the scale of the histog...
ConstructHorse2

Discussions |
Nov 11, 2024 11:31 PM

1609 views | 5 replies
How to interchange columns using JSL?

Hi all, I have a CSV file that is being used in JMP. However, I need to interchange columns 1 & 2 with Columns 7 & 8. How to do it using JSL. It looks something like this: Original File123456789 Interchanged columns783456129
UserID16644

Discussions |
Nov 11, 2024 6:27 PM

981 views | 3 replies
Formula to check if any of a list of items is contained in the rows of a column

JMP for Mac Version 17.2.0 (701896) I have a column "Data" with rows of number_number like this:1_33_76_5... I want to test this column to see if some of the rows contain values from a list of values and then flag or label the rows which do. I know I could construct an elaborate formula like this:If( :Die X_Y == "3_9" | :Die X_Y == "3_4", 1, 0 )But that's very laborious for long lists of differe...
datanaut

Discussions |
Nov 11, 2024 2:14 PM

3524 views | 11 replies
How do I use the Col Maximum Formula with a "where" condition

Hi, I have a problem where I want to formulate a new column as a benchmark to all other countries. If there are more rows for the country, I want to take the max value of it as the benchmark. See the example below for clarification. Data kind of looks like this:
Country Value period A 10 201301 A 30 201301 ...
apploarcher

Discussions |
Nov 11, 2024 2:03 PM

21640 views | 19 replies
Script command to check whether a selection criteria returns >0 selected rows

I'm looking for a scripting command that checks whether a selection contains >0 selected rows. The issue: subsetting a table of selected rows when none are selected, stops the script and returns an error message. I circumvent this problem by creating a column that sets selected rows to 1, then take col sum and run the if command (if col sum > 0, subset, don't subset). But that's clunky and for loo...
Monomorphist

Discussions |
Nov 11, 2024 1:23 PM

1195 views | 4 replies

Previous
Next

Latest Discussions

How to interchange columns using JSL?

Hi all, I have a CSV file that is being used in JMP. However, I need to interchange columns 1 & 2 with Columns 7 & 8. How to do it using JSL. It looks something like this: Original File123456789 Interchanged columns783456129
UserID16644

Discussions |
Nov 11, 2024 6:27 PM

981 views | 3 replies
How do I pass in a variable number of variables to a function as an array?

I am hoping to make some functions I have a little more reusable as an example, I am creating a summary table with specific columns from my data set. I would like to pass in the columns list as an argument to allow me to have one "GetSummary" function rather than a "GetExperimentsSummary" and "GetCompoundsSummary" , but as these need different numbers of columns I need to be able to package the li...
chappe

Discussions |
Nov 11, 2024 9:46 AM

582 views | 1 replies
Wait(0) vs Wait(n) vs Run vs Finish

I have very large, and constantly growing data tables so I have issues with formulas not finishing. I wish JMP would just build in a mechanism to stop scripts from continuing until each line has finished but perhaps there is a reason for not doing this I'm not thinking of. I typically use a wait(n) command (e.g. wait(30);) however as the dataset grows I'm constantly having to update countless inst...
RVhydrA

Discussions |
Nov 11, 2024 3:59 AM

4000 views | 5 replies
How to get CV% for an unbalanced Precision study

Hello JMP community, I have some data for Precision study with an unbalanced design. As shown below, there are ten runs performed with reagent lot 2 and 3 on two instruments (A and B). The fully automated instrument has three docks (locations) for the 96-well plate. The same sample was tested with 3 replicates in each of the ten runs by one operator. The goal is to calculate CV% for intra-run, int...
Jinweidu80

Discussions |
Nov 11, 2024 1:36 AM

1211 views | 3 replies
wilks lambada

Hi I am trying without luck to run this test. I have a species (string) plus two data columns. I am getting no results. Can anyone advise?
gw21

Discussions |
Nov 10, 2024 11:15 AM

476 views | 1 replies

Previous
Next

Latest Discussions

column and table selection

The new Messages in Workflow Builder are great.
Is there a possibility to pick a column from he current data table - or an open table?

hogi

Discussions |
Nov 7, 2024 10:31 AM

380 views | 0 replies
Data Visualization in Virtual Reality

Has anyone considered or have any interest in visualizing JMP plots (e.g., 3D scatter, surface) in virtual reality? I know there are several immersive VR programs (Arthur, Virtualitics, NVIDIA Omniverse) that can handle data and images generated from other program and I was wondering if anyone has made any attempts to do the same with JMP. Would love to hear back from anyone interested.
PieBird215

Discussions |
Nov 7, 2024 9:58 AM

593 views | 0 replies
Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

537 views | 0 replies
JMP 18 Addins on Server - Change in Location

FYI from JMP tech support: If you are running JMP on a server, note that JMP 16 addins do not work for JMP 18 because the file paths have changed. JMP is no longer part of SAS so the file path changed from C:\ProgramData\SAS\JMP\addIns to C:\ProgramData\JMP\JMP\addIns

Changing your file path to C:\ProgramData\JMP\JMP\addIns will make addins visible for JMP version 18.
pmroz

Discussions |
Oct 29, 2024 5:58 AM

584 views | 0 replies
How do I replace a prediction expression in a fit model with a specific expression?

Hi, I am completing a DOE and I have ran a fit model using the JMP software to define a design space based on desirability of certain variables, however one of the desirability variables is a simple ratio of two of the construct model effects, however when running the model, the model is defining its own prediction expression for this variable rather than using the formula in the data table. Does ...
supermackie93

Discussions |
Oct 24, 2024 5:40 AM

505 views | 0 replies