Welcome to the JMP User Community!

Latest Discussions

• Calculating median when comparing two continuous variables in a multivariate analysis

  Dear JMP Board, 
  
  I am currently working on a biomedical dataset comparing doses and blood levels of four different medication. My PI instructed me in short to compare the data for each blood level and dose across different subgroups (male, female; pre-, post-pubescent etc.). Practically spoken he told me to use a multivariate analysis to calculate a p vale within groups (Y = Dose + blood level data...

  mmkaz

  Discussions |

  Oct 12, 2021 1:56 AM

  1507 views | 2 replies

• Entering dates into data table from dialog box

   I'm looking to enter a date into a specific row in a data table after the user inputs it from a dialog box (ex: into row 5). Is there a way to do this? Thanks Names default to Here(1); dt = New Table( "Untitled", New Column( "Date 1", Numeric, "Continuous", Format( "yyyy-mm-dd", 12 )), New Column( "Date 2", Numeric, "Continuous", Format( "yyyy-mm-dd", 12 )), ); q = New Window( "En...

  EMB

  Discussions |

  Oct 11, 2021 2:34 PM

  1249 views | 2 replies

• Remove rows that have missing values in a changing range of columns

  I have a data table where I want to remove the rows that have no values in all the columns for a variable range of columns.For example, for the data table below:dt =SampleProduct TypeCol1Col2Col3Col4Col510001A0.01220.02230.015460.874223.1210003B     10004A0.1230.1240.12400.971223.78 I would want to drop the row with sample '10003' because it's entries in Col1 - Col5 are empty. I know this post is ...

  cxu04

  Discussions |

  Oct 11, 2021 2:03 AM

  4039 views | 4 replies

• need jsl formula to account for empty cell in conditional if statement

  Hi - I am new to jsl scripting and am trying to construct a jsl statement as follows: if column A is empty, column C = empty,else if column A < 500 and column B = 200, column C = 0,else if column A>500, column C = 1.How would I frame a jsl formula to do this?  Thanks! 

  learning_JSL

  Discussions |

  Oct 10, 2021 6:21 AM

  6571 views | 10 replies

• Open Files in Directory based on a List of Variable Filenames

  Hi all, I have a list of filename. This list of filename is variable and change from to time. I want to match these file name to the files available in a directory. If match , open the files. I write below code and run it. It does not work.Need guidance here.  folder = "C:\savefile\"; filename ={"Jan", "Feb", "Mar"}; filelist= Files In Directory(folder); For(i=1, i<= N items(filename), i++, ...

  bzanos

  Discussions |

  Oct 9, 2021 6:29 PM

  2924 views | 4 replies