Welcome to the JMP User Community!

Latest Discussions

• Calculating mean for a set of columns in jsl

  I have a set of column names in a list called list_1, now I want to calculate the mean for each column, but the thing is I do not want to include all the rows in the column when calculating the mean, i have another pre-defined variable that selects specific rows. How do I calculate the mean of the column by selecting the specified rows instead of stepping down through all the rows?for example i wa...

  zhouye0

  Discussions |

  Apr 19, 2016 9:41 AM

  14801 views | 1 replies

• Conditional Select Where

  I have the below JSL code to select and subset data where there are fewer than 25 rows per 'tag', save the subset, and remove the subset from the main working dataset. This works fine where there are tags with fewer than 25 rows, but I need it to be robust and work where there are no tags with fewer than 25 rows - in which case it should ignore lines 4-6 and continue to line 7 to save the main wor...

  rijking

  Discussions |

  Apr 19, 2016 2:22 AM

  11890 views | 4 replies

• DOE All Possible Combinations

  Hello all,I have a relatively problem that I can't seem to crack within the DOE platform. I've done it before, but now I can't recall how precisely.I am collecting two measurements (Valence and Intensity) across 4 samples. I want to control for the order the samples are presented.  I want to create a table with all possible order of samples (preferably 2 sets, so each combination appears twice).I ...

  benson_munyan

  Discussions |

  Apr 18, 2016 7:26 AM

  7551 views | 4 replies

• How to use JSL to do Multiple Series Stack

  I am trying to script a repeated task I do, where I use JMP to do Stack -> Multiple Series Stack -> Contiguous, and then select the columns. But, I cannot find any documentation on how to do a multiple series stack in JSL, I can only figure out how to stack into one column.How is a Multiple Series Stack performed in JSL? Thanks!

  markschwab

  Discussions |

  Apr 15, 2016 1:07 PM

  9402 views | 2 replies

• help with jsl to convert table column from datetime yyyy/mm/dd hh:mm:ss to work week?

  Hi All,I am looking for help to convert a table column from date time to work week, can you help me with a script to accomplish this conversion?My data format is: 2016/03/21 8:59:27.921 PM and I'd like to convert this to calendar work week. I am using JMP 12.Thank you!

  rrtx_mike

  Discussions |

  Apr 15, 2016 6:48 AM

  10780 views | 2 replies