cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.

Welcome to the JMP User Community!

Ask questions, get answers, meet other JMP users
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Learning Resources

Latest Discussions

  • How to set values for last 30 rows of a column?

    Hi guys, I'm a complete scripting newbie here so please have patience with me .  I have a data set with multiple columns and am trying to make a script that will automatically select the last 30 rows of a column and change the content from "baseline" to "CLCR". Please see my attempt: dt = Current Data Table(); dt1 = dt << Select Columns( :CLCR ); dt1 << select where( Row() > N Rows( dt ) - 30 ); d...

    kkrog kkrog
    Discussions |
    Feb 24, 2022 1:07 AM
    1496 views | 1 replies
  • Conditional If then to return values for ranges

    I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number  19,20,21,22,23,24,25,26,27 etc.)

    ByrdQuestions ByrdQuestions
    Discussions |
    Feb 23, 2022 3:11 PM
    1452 views | 2 replies
  • Tab character in text line

    Is it possible to use a "tab" character inside a cell? I have a report that needs to be read by a computer that requires a "tab" inside the txt file to properly run.

    mikesh mikesh
    Discussions |
    Feb 23, 2022 12:18 PM
    2081 views | 3 replies
  • where to find the formula of confidence bands in normal quantile plot?

    Hello everyone,I am checking normality using normal quantile plot. But I got different plots from JMP and Minitab using the same data. The bands in JMP are wider than in Minitab. It seems that JMP and Minitab use different algorithm to calculate the confidence bands. Where can I find the details/formulas about normal quantile plot? Thanks in advance

    acton acton
    Discussions |
    Feb 23, 2022 11:45 AM
    1487 views | 2 replies
  • Does updating the version of JMP wipe preferences from previous versions?

    I have a buddy that was using JMP v. 15 and upgraded to 16 and lost all preferences.  This is on a windows version.  Is this typical?  I have not noticed this behavior myself, but I primarily use the Mac version.  TIA.

    statman statman
    Discussions |
    Feb 23, 2022 11:43 AM
    1684 views | 4 replies

Latest Discussions

  • How to set values for last 30 rows of a column?

    Hi guys, I'm a complete scripting newbie here so please have patience with me .  I have a data set with multiple columns and am trying to make a script that will automatically select the last 30 rows of a column and change the content from "baseline" to "CLCR". Please see my attempt: dt = Current Data Table(); dt1 = dt << Select Columns( :CLCR ); dt1 << select where( Row() > N Rows( dt ) - 30 ); d...

    kkrog kkrog
    Discussions |
    Feb 24, 2022 1:07 AM
    1496 views | 1 replies
  • Conditional If then to return values for ranges

    I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number  19,20,21,22,23,24,25,26,27 etc.)

    ByrdQuestions ByrdQuestions
    Discussions |
    Feb 23, 2022 3:11 PM
    1452 views | 2 replies
  • All possible models - what criteria are used to determine the order of independent variables retained by a model?

    16.1.0Hi All,   I've been experimenting with the All Possible Models option within the stepwise linear regression module.  I was wondering what determines the order of the independent variables (IV) listed? Does the order infer some measure of effect/sensitivity, if so is there a way to identify what the relative sensitivity is? Thanks in advance. Cheers
    Clint

    RegressionOwl23 RegressionOwl23
    Discussions |
    Feb 23, 2022 11:21 AM
    956 views | 1 replies
  • HELP--update function not bringing all values over despite 100% certainty I am matching

    Hi--I am very familiar with the UPDATE function and use is often. I am trying to bring over a column of data from a new set into my master set. Both datsets have the SAME subject IDs (and same amount, N=110 in both).  When I update, it only brings over 52 of the values. The rest are missing and I am absolutely stumped because I know I used update correctly and matched correctly

    plfazeli plfazeli
    Discussions |
    Feb 23, 2022 10:12 AM
    1280 views | 3 replies
  • problem with colors for the capability

    hi,  I use JMP 16.2.0.First, I have the colors inside the table like this: but if I change the format of the numbers, the colors disappear like this:  How can I retreive the colors? best regards  

    Françoise Françoise
    Discussions |
    Feb 23, 2022 7:50 AM
    1201 views | 3 replies

Latest Discussions

  • 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 hogi
    Discussions |
    Feb 3, 2022 4:19 AM
    598 views | 0 replies
  • Setting Guardbands on Test Limits Using EMP

    Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...

    Jbritsch04 Jbritsch04
    Discussions |
    Feb 2, 2022 8:49 AM
    769 views | 0 replies
  • How to introduce lower bounds for simulated data in Profiler platform

    Hi JMP community,   (JMP Pro 16.0.0)   I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...

    SDF1 SDF1
    Discussions |
    Feb 1, 2022 11:09 AM
    589 views | 0 replies
  • Query Builder filtering on date stored in Varchar(20)

    Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO]      ,[DESPA...

    HansD HansD
    Discussions |
    Jan 25, 2022 6:12 AM
    1391 views | 0 replies
  • M1 Macbook Pro JMP Capabilities

    Hi all, 
    I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...

    MikeDereviankin MikeDereviankin
    Discussions |
    Jan 21, 2022 1:52 PM
    789 views | 0 replies
view all discussions