Welcome to the JMP User Community!

Latest Discussions

• 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

  9050 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

  1597 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

  4856 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

  2351 views | 3 replies

• How does JSL automatically get data for each cell in the selected range of the cursor?

  For example, "Big class.jMP "has selected column 1, and column 2 has already selected row 6
  How can write JSL to automatically write the cell values of the selected range into a variable?It looks like this:
  s1="TIM"
  s2=12 Thanks! 

  lwx228

  Discussions |

  Nov 24, 2020 2:32 AM

  1502 views | 2 replies