Welcome to the JMP User Community!

Latest Discussions

• 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

  4327 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

  6709 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

  26111 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

  13180 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

  Discussions |

  Apr 27, 2017 5:20 PM

  22937 views | 8 replies