Welcome to the JMP User Community!

Latest Discussions

• Test for frequency data of related sample

  Hello, I was wondering if someone can please help me know what type of test i should apply on my frequency data. Here is situation:I have frequency data of 45 consumers, obtained through five answer boxes for 7 samples. Consumers were asked to taste the sample and write their response about taste in the five boxes below. Their response were categorized into 4 categories, like Abstract taste for 1s...

  sharmachetan

  Discussions |

  Mar 12, 2021 11:51 PM

  1309 views | 1 replies

• 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

  1501 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

  1637 views | 1 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

  1889 views | 1 replies

• BMI percentile calculations

  For patients < 18 years of age, their obesity is determined by age, gender specific BMI percentiles . CDC had codes to do this in SAS https://www.cdc.gov/nccdphp/dnpao/growthcharts/resources/sas.htm I am wondering if this is possible to do this in JMP. I currently have to depend on a SAS user to do this for me..

  Sandeep123

  Discussions |

  Mar 10, 2021 3:13 PM

  1392 views | 1 replies