Welcome to the JMP User Community!

Latest Discussions

• Formatting is not accepted (col << Format( "Fixed Dec", 10, 2 )) and still getting 3 decimal point as the output. What am I doing wrong?

  Hello dear community, I am assigning the two decimal point format to a column but when i extract this value it is still showing 3 decimal points. I would appricate your input. Here is an example:// Open Data Table: Antibiotic MICs.jmp // → Data Table( "Antibiotic MICs" ) Open( "$SAMPLE_DATA/Antibiotic MICs.jmp" ); // Standardize column attributes-The main idea is the format= Fixed Dec, 10, 2-show...

  Aziza

  Discussions |

  May 19, 2023 12:39 AM

  1569 views | 3 replies

• Get values in the list from SQL query

  Hi, Is there way I could insert the column values in the list than jmp table?
  
  I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table).
  For example, save the WorkCenter sql table values in the list= {};
  Any suggestions?
  
  Thanks,Jackie

  Jackie_

  Discussions |

  May 19, 2023 12:04 AM

  2343 views | 4 replies

• How can I get the sum of all different combinations of a group of columns?

  Hi,I am using JMP PRO v16I have a group of 10 columns with numerical values, and I want to try to get a sum of the scores in all possible combinations between these 10 columns (e.g., column A+ column B, column A+ column B + Column C, Column B + Column C and so on). Thank you so much for your help

  DivisiveFerret8

  Discussions |

  May 18, 2023 3:46 PM

  2690 views | 6 replies

• How to pass values to Min and Max for Axis via Set Property?

  The following works for myCol in dt. myCol is Numeric and ContinuousNames Default To Here (1); dt = Current Data Table(); dt:myCol<< Set Property("Axis", {Min(0.02), Max(10.05), Inc( 0.01 ), Minor Ticks( 1 )});However the following results in a JMP (v 16.2.0) crash. Where am I going wrong?ll = 0.02; ul = 10.05; dt:myCol<< Set Property("Axis", {Min(ll), Max(ul), Inc( 0.01 ), Minor Ticks( 1 )});Che...

  Neo

  Discussions |

  May 18, 2023 8:13 AM

  2265 views | 3 replies

• Gradescope Data Upload Script V5

  Current version for JMP--> slack updates      

  kinseydrake

  Discussions |

  May 18, 2023 6:21 AM

  3831 views | 11 replies