Welcome to the JMP User Community!

Latest Discussions

• How to SUM rows with variable column names?

  I have a table with a variable number of columns.  I want to add a column that SUM's all of the columns in a row no matter how many / few appear.I tried this:TotRow = Trans << Get Column Names(Numeric); TR = N Items(TotRow); Trans << New Column( "Total Time", Numeric); For Each Row(:Total Time[]=Sum(Column(TotRow[1::TR])[])); But it only SUMS the first row and not the rest.  The number of colum...

  rleeper

  Discussions |

  Oct 13, 2014 4:48 AM

  14325 views | 5 replies

• JSL scripting: can I automate the SendToByGroup command?

  Most JMP platforms have a "By" option which performs the analysis separately for each level of a variable. I am particularly interested in the Distribution and the Fit Model (GLM) platforms.The Scripting Index (accessible through the help menu) gives this example:
  Names Default To Here( 1 );
  dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
  Distribution(
      By( :Sex ),
      SendToByGroup(
          {:sex == "F"}...

  jumper

  Discussions |

  Oct 10, 2014 9:35 AM

  9090 views | 2 replies

• How to append data from one table to another?

  I have a JMP file that I wish to update from an Excel file every month.  When I run the Source script from the original data table, I get a new table with the new data attached.  HOWEVER, all the scripts I want to run to do the analysis on the updated table are in the orignial table.  Can I move the scripts to the new table?  Actually, I don't even want a new table.  Can't JMP just append data to ...

  Steven_Moore

  Discussions |

  Oct 9, 2014 8:48 AM

  18007 views | 4 replies

• How to properly censor data

  Hello everyone.I want to use the jmp software for analysing biological data. I observed how many eggs some worms laid over 40 days after birth. Some did not start to lay eggs. I want to use the survival analysis of jmp to have a look at the timing of the first eggs different groups of worms produced (instead of dying they start laying eggs). My question is how I can censor those who did not lay eg...

  daniel

  Discussions |

  Oct 9, 2014 6:25 AM

  13127 views | 2 replies

• calculate grouped percentages

  Hi,I used TABLES>SUMMARY to group a table by year and position to get N rows. I want to calculate % by year (COL 3) in below table. But when I select % Total statistic it gives me % of all observations(I get COL 4). I don't see a % Total statistic on the group variable. Can anyone tell how I can calculate COL 3 of below table?      YEARPOSITIONN ROWS % by year% Total2002Catcher708.244.182002Design...

  noone_santosh

  Discussions |

  Oct 8, 2014 8:20 AM

  3500 views | 1 replies