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

  • substitute() for each row() for each column erroring out of bounds

    I need to search and replace strings across an entire data table. I referenced this solution, hoping for something elegant, but it's complaining about row 11 in my 10-row table.  Code running on JMP Pro 16.1allCols = file << get column names(string); file << group columns("col group", myCols); myCols = file << get column group("col group"); for(cols = 1, cols <= n items(myCols), cols++, file << b...

    tsandidge tsandidge
    Discussions |
    Mar 3, 2022 8:43 AM
    1372 views | 2 replies
  • How to sum scores across multiple columns with condition?

    I have a data set that includes 1600 subjects and more than 100 variables/questions. I need to calculate the total score across the 33 question items (Q1 thru Q33) ranging from 0 to 4 for each subject where the score of each question >= 2 excluding 0 and 1. Any help/suggestions/directions are greatly appreciated. Thank you Hella PS. I am using JMP Pro 16.2

    helalmob helalmob
    Discussions |
    Mar 3, 2022 8:40 AM
    1650 views | 2 replies
  • How to make high-quality plot for scientific article in JMP?

    How to make high-quality plot for scientific article in JMP?
    P.S. I need at least 600 dpi

    Ted Ted
    Discussions |
    Mar 3, 2022 7:38 AM
    4640 views | 5 replies
  • JSL Help to split/stack data

    Hello All,   I'm running JMP Pro 16.1.0 and in need of some JSL help.   I have a data table that is generated from importing a CSV file and has the following structure (the actual number of columns is much larger, but the table maintains this structure):  I am trying to figure out how to correctly change the structure into the typical format for a specifications table to be like this:  Eventually,...

    SDF1 SDF1
    Discussions |
    Mar 3, 2022 7:18 AM
    2274 views | 3 replies
  • How to assign Multiple values to SQL variable

    Hi, I'm trying to input multiple values from the jmp file into SQL variable. Something doesn't seem to work User will input the following file and the columns values are stored in the variable specVal .I declared @ SPEC = ^specVal^ (Contains 3 values ) in SQL  Something doesn't seem to be correct.   Names Default To Here( 1 ); Clear Globals(); Clear Log(); specVal = ""; NW = New Window( "DLT Data...

    Jackie_ Jackie_
    Discussions |
    Mar 3, 2022 6:44 AM
    8066 views | 4 replies

Latest Discussions

  • Line break in JMP- How to retain when exporting graph to PPTX

    I am exporting graphs that have a line break in the graph title, but the line break is not applied to my PPT slide title. Is there a way to fix this in JMP, or do I just chalk it up to another unfortunate JMP-to-PPT mismatch? Graph builder graph title : Title Line 1Title Line 2 When exported to PPT:Title Line 1Title Line 2  

    Raybob Raybob
    Discussions |
    Mar 3, 2022 5:52 AM
    1553 views | 2 replies
  • JMP Graph Builder Script to SAS

    Hi All,Is it possible to generate SAS code from a Graph Builder script?Thanks

    Aziza Aziza
    Discussions |
    Mar 2, 2022 5:55 AM
    1012 views | 2 replies
  • Reorganizing A Table by Items Within A Column

    Hello, I have a system that calibrates data and outputs the information as so:Tire IDTreadDepthDraguSpsi2326Inner0.6185840.1177740.41731421.155492326Outer0.7408410.4170790.41731421.155492327Inner0.3290650.2189030.36507125.655732327Outer0.4780550.2149530.36507125.65573 The Tire ID is read twice, once for the inner tread readings, and once for the outside. Is there a script I can use to reorganize i...

    Arocha1 Arocha1
    Discussions |
    Mar 2, 2022 3:47 AM
    1373 views | 3 replies
  • 如何用脚本获取同一个文件夹中多个文本文件的行数合计?

    大家好!指定路径中多个文本格式的文件、都是数字格式的数据。设定有不同行数、都有制表符间隔的三列。 如何用脚本获取这些文本文件的行数合计?谢谢! 

    lala lala
    Discussions |
    Mar 2, 2022 1:06 AM
    1220 views | 2 replies
  • 3d surface plot - change from cube shape to cuboid

    Hi there, Is there any way to change the graph space of the 3d surface plot from a cube to a cuboid? I want to visualise a long surface so the cube makes the plot look disproportional. Many thanks

    Alicia Alicia
    Discussions |
    Mar 1, 2022 4:14 PM
    1350 views | 1 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
    596 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
    765 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
    587 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
    1390 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
    788 views | 0 replies
view all discussions