Welcome to the JMP User Community!

Latest Discussions

• JMP Basics - how to assign column values

  hi, i am new to JMP. i have a data set that defines the co-ordinates of a sqaure. Column X contains co-ordinates x-dierction and column Y has the co-orniates in y direction. I want to name the corners B,C,D,E clockwise and the cenetr of the square A in the data table only and dont want to create any graph/pictureCan anyone help with a JSL script?

  jrintaz

  Discussions |

  Apr 29, 2017 4:27 AM

  7586 views | 3 replies

• Max value of each row across multiple columns JMP10

  When I run below script in JMP 10, I get an error message that says - argument should be matrix{1} in access or evaluation of 'Loc Max' , Bad Argument ... Looks like data table indexing is a feature in JMP13. What would be the work around in JMP10?dt = New Table( "Untitled",
  New Column( "a", Numeric, Set Values( [1, 33, 1] ) ),
  New Column( "b", Numeric, Set Values( [2, 2, 2] ) ),
  New Column( "c", Num...

  ravi_sasjmp

  Discussions |

  Apr 29, 2017 3:56 AM

  4300 views | 1 replies

• List of Missing Values

  I am writing a script that determines positional information using lists. It repeats several times for different groups of data, but some of the groups do not contain what I am looking for. This results in a list of missing values {., ., ., ., ., .}.  When there are values in the list, I use List[Loc Nonmissing(List)] to get only the nonmissing values from my list and then N Items to count how man...

  aallman

  Discussions |

  Apr 28, 2017 2:42 PM

  6673 views | 3 replies

• 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

  Discussions |

  Apr 28, 2017 10:09 AM

  25947 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

  Discussions |

  Apr 28, 2017 6:24 AM

  13138 views | 2 replies