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

  • Slope and intercept functions

    I was very surprised to fint that JMP does not have a slope or intercept function. Can this relly be so?It would be great if functions such as Slope(xMatrix, yMatrix), Intercept(xMatrix, yMatrix), Col Slope(xCol, yCol, By Vraiables) and Col Intercept(xCol, yCol, By Vraiables) were added (and diagnostics functions such as R2, SE etc,), yeilding simple RMS linear regression coefissients.I know I can...

    JesperJohansen JesperJohansen
    Discussions |
    Apr 28, 2017 10:09 AM
    25969 views | 7 replies
  • Can not open excel file

    I have a folder with dozens of excel files, all of them are 2010, all were made from the same template file.  However, on some of them I get the following error when I try to open them in my script"There was an error opening the file in the Excel Wizard. Files older than Excel 97 might fail to open. Using the Open All Sheets preference should work in this case.{320}"If I try to open the offending ...

    rleeper rleeper
    Discussions |
    Apr 28, 2017 6:24 AM
    13144 views | 2 replies
  • How to store data in a list?

    Hi everyone, I face a problem on how to store the subset data table into a list, below is my code : dt = Open (<path of file>); p= {"G_40", "F_45", "E_57", "F_85", "H_90"}; For( i = 1, i <= N Items( p ), i++, dt << Select Where(Starts With( dt:ftf, p[i] ) ) ; tempDT = dt << Subset( output table name( "Subset" ), selected rows( 1 ), selected columns( 0 ), "invisible"); ); I plan to store tempD...

    jade jade
    Discussions |
    Apr 27, 2017 5:20 PM
    22900 views | 8 replies
  • JMP12 Add-In Folder Moved (Local=>Roaming)

    As I'm migrating some of my JSL scripts from JMP11 to JMP12, they are Add-In's, I've noticed they would not work.  The root cause is that JMP12 is now using the \Roaming folder, where as JMP11 and before used the \Local folder.  Does anyone know why JMP12 Add-In's are now using the Roaming folder?  Same Windows 8 in each case, same PC: JMP11: C:\Users\<myname>\AppData\Local\SAS\JMP\AddInsJMP12: C:...

    djhanson djhanson
    Discussions |
    Apr 27, 2017 2:17 PM
    5395 views | 3 replies
  • Calculate Moving Average Using Last 3 Time Periods

    I have a set of data with three columns; Customer, TimePeriod, and Quantity. TimePeriod is in the format of yyyymm. I'm trying to determine a formula to calculate a "rolling average" over the last 3 time periods, across all customers.   For example, In my row labeled 201704, I want a formula to return the average Quantity for all records from 201703, 201702, and 201701. The TimePeriod can occur mu...

    Risslemc Risslemc
    Discussions |
    Apr 27, 2017 9:46 AM
    10488 views | 8 replies

Latest Discussions

  • JMP12 Add-In Folder Moved (Local=>Roaming)

    As I'm migrating some of my JSL scripts from JMP11 to JMP12, they are Add-In's, I've noticed they would not work.  The root cause is that JMP12 is now using the \Roaming folder, where as JMP11 and before used the \Local folder.  Does anyone know why JMP12 Add-In's are now using the Roaming folder?  Same Windows 8 in each case, same PC: JMP11: C:\Users\<myname>\AppData\Local\SAS\JMP\AddInsJMP12: C:...

    djhanson djhanson
    Discussions |
    Apr 27, 2017 2:17 PM
    5395 views | 3 replies
  • Calculating Sample Size for survival analysis

    Hi, I'm trying to calculate a sample size for survival analysis in Oncology. If I assume a constant hazard ratio and I have an estimate of overall survival (OS) and if I'm assuming that I need, say 80% power, how do I calcualate sample size in SAS JMP?    Any ideas?   Thanks, Rakhi 

    rakhi_baj rakhi_baj
    Discussions |
    Apr 27, 2017 7:55 AM
    4759 views | 1 replies
  • PCA - how to find component scores (X,Y coordinates) for each point on plot?

    I'm using JMP 13.0, on a Mac to run Princple Component Analysis (PCA) on environmental data.   It's working fine, however I can't seem to find any option to display the X,Y coordinates (PCA scores) for each point on the plot. My plot contains ~50 data points, from several different treatment groups. I'm hoping to calculate a mean value and standard deviation, for PC1 and PC2, for each treatment gr...

    Jasmax Jasmax
    Discussions |
    Apr 26, 2017 6:10 PM
    3821 views | 1 replies
  • Refresh axis for Graph Builder

    Hi, Is there a way to refresh a graph builder axis using jsl?  The last line in my code (...<max()<<min();// ) is resulting in multiple values on an axis, see vertical axis in attached picture.   I use the setwidth(0) on distribution for cases where I end up needing to reset the axis width based on number of digits. setwidth(0) sets it automatically. i'm not sure how much it helps on graph builder...

    mikedriscoll mikedriscoll
    Discussions |
    Apr 26, 2017 12:05 PM
    6332 views | 7 replies
  • How do I reference data from column A to column B? (I honestly can't find the answer)

    Hi there, I know this is probably very easy for most but I've been searching through the JMP discussion pages, and also google searches just to simply do the following.  I want all the data in my "Age" column to be "referenced" or the same, as another column called AgeGroups since in this column I have made age ranges for the data values (16 to 24, 25-30 etc..). I've seen plenty of similar discuss...

    slamer2000 slamer2000
    Discussions |
    Apr 24, 2017 3:50 AM
    9139 views | 3 replies

Latest Discussions

  • Linearity and Bias Report

    In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%.  We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.

    Aravindan Aravindan
    Discussions |
    Apr 18, 2017 12:54 AM
    4260 views | 0 replies
  • CCC Optimal

    Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,

    Lamine Lamine
    Discussions |
    Mar 17, 2017 5:25 AM
    3313 views | 0 replies
  • Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

    My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...

    kevinwtbolger kevinwtbolger
    Discussions |
    Feb 26, 2017 9:30 AM
    3334 views | 0 replies
  • Data Binding Associative Arrays

    I recently had need to create some slightly complex data structures and started to play with associative arrays a little more.  These are similar to dictionaries in other languages.  Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding.  Essentially it makes it so both the dictionary and the variable refer to the s...

    msharp msharp
    Discussions |
    Feb 14, 2017 1:53 PM
    4392 views | 0 replies
  • How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

    For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...

    MIKE MIKE
    Discussions |
    Dec 14, 2016 8:48 AM
    4714 views | 0 replies
view all discussions