JMP User Community

Latest Discussions

jmp script to export data sheets to Excel with sheet names longer than 31 characters

Hi,I am trying to export some JMP data tables to Excel (one Excel file with separate tabs for each sheet). However, some of the data sheet names are longer than 31 characters which Excel does not support as tab names. If I try to use the 'Export' option in JMP it works nicely with names longer than 31 characters truncated. But if I try to use 'Create Excel Workbook ()' in a JMP script the software...
DD1

Discussions |
Apr 30, 2022 3:25 PM

2990 views | 6 replies
Script Run Sequentially

I am trying to create my Save Estimates from my survival platform, then grab the estimates in the newly created table. The problem is that it will not wait until the Survival table is created before executing the Output expression. I have tried finish, wait, different orders, etc... and I cannot get this to work, any suggestions? I have JMP 16.0 with MacBook. Names Default To Here( 0 ); Clear...
lisamaley

Discussions |
Apr 30, 2022 12:15 PM

1860 views | 5 replies
How do I parse large json from an API?

I am trying to create a data table from an API response but the JSON that is output won't process and I think the file is too big. It's about 20 MB and the final data table is ~7000 rows and ~115 columns. Is this just too big to parse? I also have the option of getting a csv file from the API or output as a text string. I work with the developers that wrote the API so we can make it output wha...
MQ_Smith

Discussions |
Apr 29, 2022 12:38 PM

1725 views | 3 replies
JMP 16.2 Equivalent to Excel PERCENTILERANK Function?

Would like to find the percentile of a number within a data set. What percentage of values are above/below a certain number? Other than eyeballing a CDF or Prob Dist chart is there an existing path to get this number or is this a JSL task?
WoHNY

Discussions |
Apr 29, 2022 12:12 PM

3182 views | 8 replies
Survival

I have done scripts before where I do not put columns into the script so that when the script is executed, it brings up the platform and lets them put the information in, such as: Fit Model( Y( ), Effects( ), Personality( "Standard Least Squares" ), Emphasis( "Minimal Report" ), Run( :height << {Summary of Fit( 1 ), Analysis of Variance( 1 ), Parameter Estimates( 1 ), Plot Actual by Predicted( 1...
lisamaley

Discussions |
Apr 29, 2022 10:13 AM

1015 views | 2 replies

Previous
Next

Latest Discussions

How do I parse large json from an API?

I am trying to create a data table from an API response but the JSON that is output won't process and I think the file is too big. It's about 20 MB and the final data table is ~7000 rows and ~115 columns. Is this just too big to parse? I also have the option of getting a csv file from the API or output as a text string. I work with the developers that wrote the API so we can make it output wha...
MQ_Smith

Discussions |
Apr 29, 2022 12:38 PM

1725 views | 3 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

701 views | 0 replies
Is there a function to convert a character to its ASCII equivalent?

Is there a function to conver a character to an ascii number? In the end I need to translate a character based column in data into its numerical equivalent. They always happen to be 1 or 2 digits. So effectively "A" becomes 1"Z" becomes 26"AA" becomes 27"AB" becomes 28 etc. So say DIE_COLUMN = "CA" I want to return 79 I've come up with the following thoroughly ugly formula... but if there was ...
LikelihoodFaces

Discussions |
Apr 28, 2022 11:36 AM

2533 views | 3 replies
PLS and latent variables structure

Hello, I'm using JMP Pro to conduct a Partial Least Squares analysis and I'm wondering if there is a way in JMP to explore the structure of the latent variables, like which variables have a high weight on each latent variable. Thanks!
Moukanni

Discussions |
Apr 28, 2022 10:57 AM

1296 views | 2 replies
How to detect outliers

Hi all, I would like to make a script to detect outliers based on my data population.Based on the image below, I tried to calculate mean of all pockets from 0 to 6 and applied method ((Mean +- (3*sigma)) to find outliers. By direct observation, Pocket 2 has a lot of outliers. However, in case the value of variation data points on Pocket2 is within ((Mean+-(3*sigma)), my method cannot detect them a...
PhamBao

Discussions |
Apr 28, 2022 9:00 AM

1158 views | 1 replies

Previous
Next

Latest Discussions

JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

701 views | 0 replies
How to create a graph builder box plot with mean values, and including the "group X" variable in the legend

I'm using JMP 16.2.0 and I'm trying to automatically generate a graph builder with box plots and their mean values with the group X variable as the color. I'm using a bar chart with style=floating to display the mean value (inspired by this topic)My current graph:This is almost what I want, except for a few things.1. I'd like the Group X variable (Recipe) to be visible in the legend as well. One w...
mvanderaa1

Discussions |
Apr 20, 2022 4:13 AM

2513 views | 0 replies
Error When Trying to Create User to Access the JMP Virtual Lab

While taking the Exploratory Data Analysis module, it is time to practice. However, when trying to access the JMP Virtual Lab, I cannot get past the "Create User" option. JMP VIRTUAL LABTo use the Virtual Lab, please select the Create User link below. If you would prefer to use software on your own machine, please select the Download Data link below.
Create User Download Course Data Clicking the C...
TielsForTheWin

Discussions |
Apr 14, 2022 10:48 AM

793 views | 0 replies
Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

842 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

597 views | 0 replies