Welcome to the JMP User Community!

Latest Discussions

• Convert Date/Time (down to the millseconds) into a Variable

  Hello,I am trying to convert a date/time down to the milliseconds in order to insert into an SQL statement that I am using in my JSL script. The typical method I use to do so usually creates the variable (date) with single quotes around it. However, when attempting the same method to my date/time which includes milliseconds it adds two single quotes to each end of the variable. Could someone assis...

  Sully

  Discussions |

  Mar 12, 2021 5:40 AM

  2010 views | 1 replies

• How do I delete columns in a data table with their names containing "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the column containing only "." (NOT empty)

  I have a large dataset on hand and want to delete all columns whose name contain "UL" or "LL" or "UCL" or "LCL" or "USL" or "LSL" and the whole column only contains "." but not empty except the column name. (images are shown below) I did not know how to do this after searching Google and read the JMP manual. Thanks for help on this.    

  mengzy1974

  Discussions |

  Mar 12, 2021 12:56 AM

  2324 views | 1 replies

• How to trigger a button to open "Save File Windows Explore" via JSL?

  I am trying to get help from community members to see that if a "Save File Windows Explore" can be triggered as below screenshot after a button-clicking event? Is there anyone who has an idea? Thanks in advance.      

  baiyun

  Discussions |

  Mar 11, 2021 11:13 PM

  4463 views | 6 replies

• How do I create a counting variable based on another column & transpose a table?

  Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...

  acm

  Discussions |

  Mar 11, 2021 4:13 PM

  2492 views | 1 replies

• Process Capability - Summary report: color of process stability column

  I made a process capability analysis of 7 processes. Although the 7th process is very unstable with stability index = 1,30 in the summary report it is labeled as green where is should be red as in the process performance report, see below. Is it possible to adjust the color of the Stability Index (SI) column to red according to the SI target?  

  frankderuyck

  Discussions |

  Mar 11, 2021 2:03 PM

  4423 views | 5 replies