Welcome to the JMP User Community!

Latest Discussions

• How can I copy a new table data copy with column names to after the last column of another table?

  For example, the Boston Housing.jmp Summary calculation produces a new table that wants to copy all the column names and data from the new table to the first row after the last column of Boston Housing.jmp.Thank you very much!   dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" ); dt << Summary( Group( :chas, :tax ), Mean( :mvalue ), Subgroup( :radial ), Freq( "None" ), Weight( "None" ) ) ……？？  

  lwx228

  Discussions |

  Aug 30, 2018 12:56 AM

  6172 views | 4 replies

• Adding two columns in a table when one of columns can be blank

  Hi, I have added bunch of data tables (Combined data table, attached) and found out the column Y and SPC_Y are indeed the same variable (Name change during the test). So I need to combine these columns. I wrote the following script and the added column (Y+SPC_Y) is blank.       dt=current data table(); // Two Columns Name that are the same Y and SPC_Y dt<<new column("Y+SPC_Y", continious); f...

  AT

  Discussions |

  Aug 29, 2018 5:59 PM

  6631 views | 4 replies

• Determine if time is between certain hours

  Casual jmp 12 userHow do I have jmp determine if a time is between certain hours on any day?I want to create a column to show (Y/N) if the time when data was taken is between 12:00 AM and 7:00 AM.  So the below data points would be Yes then No.Data taken at random times and transferred into jmp as shown in the examples below.     Data (Example)         Between 12 and 7? (Desired result)11/11/2017 ...

  Elby

  Discussions |

  Aug 29, 2018 12:11 PM

  4497 views | 1 replies

• Getting control limits from column property

  I found this topic earlier for pulling the spec limits from the column properties.https://community.jmp.com/t5/Discussions/Get-column-Property-and-store-as-list/td-p/50885 I need to do similar however with the control limits as well.  For this however the same principle doesn't work.CTRL = Column(colname) << Get Property( "Control Limits" );LCL = CTRL["LCL"];Returns: Name not found. in access or e...

  sbiedrzycki

  Discussions |

  Aug 29, 2018 10:48 AM

  6779 views | 4 replies

• How to make dummy variables in effects type coding instead of 0/1 coding?

  I want to add a dummy variable for every crop I use. I this link I found out how to make them but the dummys are in 0/1 coding. (https://community.jmp.com/t5/JMP-Academic-Knowledge-Base/Make-Indicator-Dummy-Variables/ta-p/22636). I would like to change these 0/1 coding in effects type coding (-1,0,1) but I don't know how.Is there somebody who knows a solution?In the attachment you find a part of m...

  smartens

  Discussions |

  Aug 29, 2018 6:08 AM

  13674 views | 5 replies