script to find and replace a numeric value with a missing value in the whole table
Hi,I would like a code that would find and replace the number 999 in the whole table into a missing value.TIA
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi,I would like a code that would find and replace the number 999 in the whole table into a missing value.TIA
Recently, I have noticed that JSL is reporting unknown message for valid code. Below is the latest example (unknown messages highlighted): Names Default to Here(1);
Delete Symbols();
databaseFile = Pick File(
"Select Music Collection File",
"$DOCUMENTS",
{"Music Collection|csv"},
1,
0
);
albumTable = Open(databaseFile);
albumTable << Delete Rows(N Rows());
:Name("Artist/Album") << Set Name
...
I have a data table with first column filled with part_IDs (other columns have got other info about corresponding to each part) and a working function which loads test data for a given (single) part_ID from the database. I would like to have the following functionality via a modal window.1. Have the user select the part_IDs in the data table using a wild card. For example, the part_IDs are of the...
Hello, What is the difference between the "correlation between the estimated regression coefficients (corr(b1, b2))" and the "correlation between the explanatory variables (corr(X1, X2))"? I found that, for example, corr(X1, X2) could be positive while corr(b1, b2) is negative. I think I understand corr(X1, X2), but I don't understand why we need to know corr(b1, b2), how it relates to corr(X1, X2...
I am trying to get information on both a whole book and also by chapter. Is there a quick of doing that besides running the analysis twice? (For instance I would like to know how often a word occurs in a book and also in a chapter.) I am also trying to find out if certain words occur in proximity to other words. Is there a quick test for this? (For instance does "work" occur within 7 words of "inj...
Hello, What is the difference between the "correlation between the estimated regression coefficients (corr(b1, b2))" and the "correlation between the explanatory variables (corr(X1, X2))"? I found that, for example, corr(X1, X2) could be positive while corr(b1, b2) is negative. I think I understand corr(X1, X2), but I don't understand why we need to know corr(b1, b2), how it relates to corr(X1, X2...
I am trying to get information on both a whole book and also by chapter. Is there a quick of doing that besides running the analysis twice? (For instance I would like to know how often a word occurs in a book and also in a chapter.) I am also trying to find out if certain words occur in proximity to other words. Is there a quick test for this? (For instance does "work" occur within 7 words of "inj...
Hello, I have a question regarding center points for a 2-level full factorial design with 3 continuous factors. As we are fairly resource constrained, we would be including 8 runs without repeats and then adding a center point (duplicated) to test for curvature and estimate the variability associated with our experiment. The goal of our experiment is to evaluate the robustness of our process and ...
Bonjour à tous, J’ai créé un Dashboard sur JMP, ce Dashboard utilise différentes bases de données Excel.Le Dashboard s’exécute via un script JMP.Cependant, j’aimerais pouvoir améliorer encore ce script. Le problème est que lors de l’exécution du script j’ai 2 problèmes : 1 - Devoir faire l’affectation manuellement à chaque fois des tables correspondantesDans mon script du Dashboard, chaque fichier...
Hello, I'm trying to change the variables name in loading scatter plot but I can't. The variables included in PCA analysis are from two linked data tables. I'd like to change the columns name to new abbreviation names. Thank you very much in advance.
Sometimes in a GraphBuilder it's difficult to select multiple entries in the legend, especially along the idea:- select a first entry- press shift *)- while clicking on another entry.If everything works fine, at the end both entries plus the entries in between will be selected. But there are cases where either the first selected entry or all entries are deselected at the end.
Is there a feature beh...
hi,I have got an add-in from https://community.jmp.com/t5/JMPer-Cable/Who-what-why-and-how-Tools-for-modeling-and-visualizing/bc-p/624293#M842 to implement floodlight analysis through Johnson-Neyman Plot. according to the table of the example from the linkage above; what does "_c" mean? such as "meaning_c" and overwhelming_c"? focus on my own study, I got a moderator called "SE" which is a contin...
Which GoF statistic is best to use (Pearson or Deviance) when the results disagree? Is one better suited for Probit than the other? I'm using JMP Pro 17.0.0
The context of my data is from an e-commerce website. I am measuring the number of errors made based on different independent variables: Filtering technique (Alphabetical, Relevance and Search) and Number of Items added (Add one at a time, or add multiple items to cart at once). As the number of errors made is 0 most of the time, I have opted to use the Zero Inflated Poisson Regression. When I per...
I am looking for an example of how to connect to oracle data with JMP 16 via oci. I have seen notes indicating that it is a far faster connection.
Jump into Graphing Date: Tuesday, September 16Time: 1:00 – 2:30 p.m. ETDuration:&nbs...
Elaborate on Elaborate: Advanced Interactive Reporting & AI-Enhanced Development In this...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
REGISTER HERE *** Note that this webinar starts at a different time than the other Fall 2025...