JMP User Community

Latest Discussions

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

1667 views | 4 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

804 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

4599 views | 5 replies
Column statistics, such as mean for only selected rows.

Hi. I qould like to have a jsl command to find either column mean, median, or sigma for the height column, but only where age is only 12 and 13. I tried select rows, but I dont seem to get the correct result. If i use or not use the select rows, it still gives me the same numbers. Data Table( "table" ) << Select where( :age== { 12, 13 }); Sigma = Col Std Dev( As Column( "age" ) ); median = Col...
LogitElephant69

Discussions |
Nov 8, 2024 11:47 PM

1765 views | 2 replies
Column/value type issue with formula

I am trying to get some data that we currently store in Excel into JMP. In Excel, we use a VLOOKUP function (the 'HIV alert limits' column correlated to the 'semester donations estimate' column) and then calculate the '% of standard' column (HIV total/HIV alert limits) to get a percent. In JMP, I have made the 'HIV alert limits' column with an IF formula. This formula works on a range and based ...
patriciafm811

Discussions |
Nov 8, 2024 7:52 AM

1446 views | 4 replies

Previous
Next

Latest Discussions

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

804 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

4599 views | 5 replies
Display Tree Indexing - how does it work?

Helpful Information from the community: Subscripting:Display Boxes with Subscripts Xpath: xPath coding help / (Xpath "family" tree)All OutlineBoxes with title condition By XPath (@helpKey)

All in One:I-Can-See-It-How-Do-I-Get-It (Discovery Summit 2024, @Mark_Bailey , @tonya_mauldin)
hogi

Discussions |
Nov 8, 2024 12:58 AM

1441 views | 4 replies
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

483 views | 0 replies
How can the following python library installation commands be implemented in python in a JMP environment?

Thanks Experts!pip install selenium-wire -i https://pypi.tuna.tsinghua.edu.cn/simple pip install blinker==1.7.0 -i https://pypi.tuna.tsinghua.edu.cn/simple pip uninstall h11 pip install h11 -i https://pypi.tuna.tsinghua.edu.cn/simple
lala

Discussions |
Nov 7, 2024 12:59 AM

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

483 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

677 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

722 views | 0 replies
Graph Builder: Ordering my overlay by descending order according to the total value of each overlay category

Hello community, I come to you with a difficult question. Please see the image below for reference. I am using JMP 18, and I am trying to create a bar chart to show PPB values by quarter for various categories. The trouble I run into is that I want the category that has the highest total value from the chart to be on the bottom of the stack. For example, in the image below the category memory shou...
AttributedMouse

Discussions |
Oct 22, 2024 1:37 PM

709 views | 0 replies
Could JMP show in a single graph a sensitivity analysis and the probability of occurrence of a result?

Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Marco2024

Discussions |
Oct 2, 2024 5:15 PM

705 views | 0 replies