Welcome to the JMP User Community!

Latest Discussions

• How to re-scale graph and generate Min, Max and Standard Deviation?

  Hi Guys,Need your expertise to solve this problem.First of all, I generate data analysis by using JMP script. However, I got 4 data group which are Site 1,2,3 and 4. For each site, i would like to display the min, max and standard deviation value. Do you have any idea how to display that value on this graph by using script?Secondly, I set scale for this graph by using high and low limit to check t...

  WanCine

  Discussions |

  Nov 25, 2020 8:22 AM

  3539 views | 3 replies

• How to extract data from an Excel file on Sharepoint?

  Hi all, I have a script setup to open an Excel file, extract the required data, run some analysis, save the analysis as an interactive HTML (for access by a non JMP user), and close JMP down. It all works fine in my pilot script and as a non-coder I’m especially pleased to have figured it all out. The challenge now is that this must work between two completely separate companies. Both companies ha...

  kom

  Discussions |

  Nov 25, 2020 2:58 AM

  9589 views | 3 replies

• Taylor Series Linearization to Calculate Variance in NHANES

  Hello, 
  Looking at the NHANES data that incorporates demographic weightings and population stratum & PSU, is there a way to do a survey design in JMP? There is SAS code attached from the CDC below as well as R & Stata code. 
  
  https://wwwn.cdc.gov/nchs/nhanes/tutorials/Module4.aspx
  
  Code: 
  SASPROC SURVEYMEANS data=one varmethod=taylor nomcar; STRATA sdmvstra; CLUSTER sdmvpsu; WEIGHT WTMEC4YR; DOM...

  MikeDereviankin

  Discussions |

  Nov 24, 2020 2:44 PM

  1769 views | 1 replies

• Adding line to split data on graph builder

  Hi,  I have the following data set below where red data points are some fails that I would like to screen out. Right now the way I am doing this is roughly calculating a trend line (see image below) and finding its equation. Then I create a new column and use JMP formula to basically check if data point is below line and if it is it updates the new column with a 1 and if it is above it marks new c...

  tarkan_bih

  Discussions |

  Nov 24, 2020 10:05 AM

  5320 views | 9 replies

• JSL to add event handler

  I'm trying to add an event handler column property using the following code but it isn't working.  I can manually apply the property, but can't figure out a script based method.  Can this be done by JSL?   // Create hyperlink for URL column :Current Firmware URL << Add Column Properties( Event Handler, Function( {thisTable, thisColumn, iRow}, Web( Char( thisTable:thisColumn[iRow] )...

  terapin

  Discussions |

  Nov 24, 2020 9:05 AM

  2542 views | 3 replies