Welcome to the JMP User Community!

Latest Discussions

• JMP csv import automatically converting hex to dec

  Hello, I have a csv file with one of the columns containing data such as 0x62, 0x68, etc. When importing the csv into JMP using JSL open(infile), it is found that JMP automatically converts the column into a Numeric datatype, changing 0x62 to 98 (decimal) in the process. Manually importing the csv not using script, the same issue (auto-converts). It only happened to one of the computers, other com...

  ylee

  Discussions |

  Jan 13, 2020 5:46 AM

  4349 views | 4 replies

• How do I Print current date as image (jpeg file) and save on a network share drive

  Hello, I am creating bunch of variability plots in a for loop and saving each plot with a unique name using the code below. However, I want to either be able to 1) add a current time stamp (when script runs) to each of these plots or 2) instead of displaying date on each plot, just save a seperate jpeg file that just has date time stamp. Can anyone suggest how can I do that.     dt = Current Data ...

  newbie_4

  Discussions |

  Jan 12, 2020 5:11 PM

  4191 views | 3 replies

• How do I do a count formula

  I have a data set that had 19 million rows.  Within that data set I want to count the number of instruments a customer has.  I have the customer data in one column and the instruments in another column.  My goal is to select customers that only have 1 instrument.   Thanks 

  VR

  Discussions |

  Jan 10, 2020 4:56 PM

  3502 views | 2 replies

• Running script from command line on MAC

  Not a mac person.  Does anyone know how to run a jsl script from command line on a mac?  I specifically mean WITHOUT "//!" at the top of it.     I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl

  vince_faller

  Discussions |

  Jan 10, 2020 2:26 PM

  1666 views | 0 replies

• Fill empty cells with last valid value

  Hello, I have the following problem. My dataset is composed by a list of rows, each representing one item produced by a machine. Normal items are not measured, but from time to time some "measurement items" are produced and the propetries measured. The assumption is that all the parts not measured will have properties similar to the latest measurment. How can I fill the empty cells using this logi...

  lburtone

  Discussions |

  Jan 10, 2020 7:53 AM

  16373 views | 4 replies