Welcome to the JMP User Community!

Latest Discussions

• programming functionals (or functions that generate functions)

  I have a problem where the solution I want is to use a function to generate a different function. Here's a toy example. I expect it to return [3,4,5]. it doesn't work as I hoped because apparently the passed argument (offset) isn't available to the anonymous function that is returned. My guess is that there is a way to do this with substitution, but I couldn't figure it out. funWrapper = Function(...

  Mittman

  Discussions |

  Apr 2, 2021 6:16 PM

  4032 views | 8 replies

• How to repeat values in a column when they are strings

  Hi everyone!
  
  I've used this script below for numerical values If( Is Missing( :Name( "For Calc - Data1" ) ), Lag( :Name( "Data1" ), 1 ), :Name( "For Calc - Data1" ) )
  With the resulting table looking like this For Calc - Data1Data11212 12 123333 33     However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...

  user8421

  Discussions |

  Apr 2, 2021 1:49 PM

  1400 views | 1 replies

• How do I join two tables based on timestamps that don't exactly match?

  Hi everyone! I am having an issue where I have Data Table 1 as shown below with a timestamp column and various columns of data TimestampColumn AColumn B02/08/2021 11:45 AMA1B102/08/2021 1:39 PMA2B202/08/2021 11:37 PMA3B302/13/2021 12:01 AMA4B402/13/2021 4:00 PMA5B502/13/2021 10:22 PMA6B602/18/2021 9:00 AMA7B702/18/2021 12:01 PMA8B802/21/2021 9:15 AMA9B902/21/2021 11:50 AMA10B1002/21/2021 3:00 PMA1...

  user8421

  Discussions |

  Apr 2, 2021 11:20 AM

  6456 views | 5 replies

• Code Folding is catching too many lines

  I have set "if" blocks to be foldable,  and I have been using them like this    If (1==1, // comment abc    <foldable code block 1 > ); If (1==1, // comment xyz    <foldable code block 2 > );   But often, the first block will catch later blocks and fold them all together.   The code work without a problem, but is is sometimes hard to find the code, it is lost in the folds. Is there a solution to t...

  mann

  Discussions |

  Apr 2, 2021 8:36 AM

  2493 views | 5 replies

• How to transform matrix into 2D data table?

  Input: Summarize(g=by(age, sex), c=count()); show(g, c); output: g:{{"12", "12", "13", "13", "14", "14", "15", "15", "16", "16", "17", "17"}, {"F", "M", "F", "M", "F", "M", "F", "M", "F", "M", "F", "M"}} c:[5,3,3,4,5,7,2,5,2,1,1,2] How to make the result into a data table with column as sex and row as age? Like pivot table?

  

  Discussions |

  Apr 1, 2021 1:33 PM

  4335 views | 4 replies