Welcome to the JMP User Community!

Latest Discussions

• Formula to extract date from character column

  Hi, I use SAS EG and JMP. In the past I used Base SAS for PC. I am getting frustated at how seemingly simple tasks do not have simple solutions in JMP. Now for example see the attached jmp table which contains a column with character data. I need to create a column with the dates as a numeric variable. In SAS I would write:date=input(substr("Column 1",1,10),ddmmyy10.);but what should the formula b...

  poulravn

  Discussions |

  Oct 30, 2012 8:33 AM

  10364 views | 4 replies

• Extract USL & LSL for all tests of my data table

  Hi all,I just start working on Jump 10.I am trying to extract from a data table all USL & LSL for all the tests and then I would like to create a new table bluit as:  Test number | Test name | LSL | USL.Any ideas to help me please ? Or any tutorials ?Thanks in advance.Rgds,CedricB

  cedricb

  Discussions |

  Oct 29, 2012 7:26 AM

  5983 views | 2 replies

• Finding patterns between temprature and faults

  Hi,I am looking to find patterns/trends between the number of faults we get in our systems and the the ambient temprature. I am using JMP to do this and like to know what is the best way of doing this. I have a year's worth of data and not sure what is the best way to analyse this.Does anybody know?thanks
  

  monty

  Discussions |

  Oct 28, 2012 11:54 AM

  2969 views | 2 replies

• How can I combine 2 columns into one?

  
  I would like to combine two columns into one. My data looks like the table below where "." represents missing data. I would like to make a column which resembles Column C.Column AColumn B.2013.20142016.2017.Column C2013201420162017

  hacketkm

  Discussions |

  Oct 23, 2012 9:10 AM

  11791 views | 3 replies

• creating a text box and reference data using JSL

  iam trying to create a text box that asks where it asks for "Enter the required Code" . The user enters the code and clicks on 'Search' button. Then the code entered has to be searched in the script.example:-kw1=""; dial_wind =New Window("Select Profit Center",
  Text Box(""),
  Text Box("Enter you profit center code."),
  Text Box(""),
  keyword1 = Text Edit Box("",<< set width (200), <<script(kw1=keyword1<...

  fr2007

  Discussions |

  Oct 22, 2012 4:33 AM

  10709 views | 1 replies