JMP User Community

Latest Discussions

How to replace empty rows until next entry (and continue)?

Dear JMP community, (W10, 64-bit, JMP 15.0 Pro) I have a large data table that is imported from an excel file and I need to have empty rows of a column filled with the entries of the previous list. I am trying to write JSL to go from a column as on the left to the one on the right, as shown below: I'm thinking it should be pretty easy to code, but the issue I'm having is correctly stopping at t...
SDF1

Discussions |
May 29, 2020 4:28 AM

6443 views | 10 replies
How to use JSL to quickly filter out all the rows in a data table with multi-column values that are not empty?

If a data table has more than 100 columns.Given that columns 11 -- 100 are in numeric format, how can use JSL to quickly filter out all rows in column 11 -- 100 that are not null. Thanks!
lwx228

Discussions |
May 29, 2020 4:06 AM

4986 views | 9 replies
Open BMP file as a table?

Any suggestions on how to open\convert a BMP (bitmap image) file as\to a table?Ideally would like to have columns like X, Y, R, G, B with all the information, so that when plotted would resemble actual BMP.Might be some external converter first, then open a CSV file, might be a script that reads binary file and poarses into a tble, might be some built in function?
miguello

Discussions |
May 28, 2020 12:12 PM

2422 views | 2 replies
Control Chart Builder and skewed variables

Hi All. Thanks for reading my question and your time;I am very inexperienced about the Quality and Process tools. I want to use the Control Chart Builder for the compositional data measured in our lab for a Chinese product. This type of data is skewed some times for some elements, like CaO.Can I still use the control charts if the data is not normally distributed?By the way, I have the min and max...
Amir_H

Discussions |
May 28, 2020 9:36 AM

7991 views | 12 replies
Using JMP to Connect to Spark Tables using Data Bricks/JDBC Driver

Using JMP to Connect to Spark Tables using Data Bricks thru JDBC Driver I cannot find any documentation on how to do this... is this possible? how do I go about it?
raffinito_cvx

Discussions |
May 28, 2020 8:44 AM

2112 views | 1 replies

Previous
Next

Latest Discussions

Using JMP to Connect to Spark Tables using Data Bricks/JDBC Driver

Using JMP to Connect to Spark Tables using Data Bricks thru JDBC Driver I cannot find any documentation on how to do this... is this possible? how do I go about it?
raffinito_cvx

Discussions |
May 28, 2020 8:44 AM

2112 views | 1 replies
Wafer shot map and GDPW optimization script

Hi, In the semiconductor industry you usually need to optimize the number of dies you can squeeze on a wafer (GDPW). I wrote a script in JSL that calculates the best and worst possible number of good dies per wafer given a certain geometry. Especially for large dies, a small shift of the shot array by a few mm can improve the GDPW by up to 5%. In this script you define some input parameters such a...
PS

Discussions |
May 28, 2020 5:07 AM

4097 views | 2 replies
% Gauge R&R or Precision-to-Tolerance ratio

When reporting the Gauge R&R in version 13.1.0 the below report is available. When I open help, the below does not specify which is the % Gauge R&R number for the guidelines. Example of the Gauge R&R ReportNote: To generate the reduced Gauge R&R report, select File > Preferences > Platforms > Variability Chart > Reduced Gauge RR Report.In this example, the values in the Variation column are the sq...
caroljackson

Discussions |
May 27, 2020 12:53 PM

13678 views | 2 replies
Power Analysis in Design Evaluation (DOE)

Hi, Under the Design Evaluation (after the DOE is created), there is a tab called Power Analysis per below photo. I understood the Power represents the probability of detecting a significant effect (if there is). For example here, this design have a probability of 57.2% to detect effect of X1 if it is a significant effect. My questions:1. Understood the Coefficient is the "slope" or effect streng...
ChrisLooi

Discussions |
May 27, 2020 11:57 AM

10993 views | 2 replies
How to check for interaction effects in ANOVA

Hi there, this might be a rookie question. Nevertheless: I have performed a 2x2x2 between subjects experiment. I am running ANOVA's to test for main effects, but I also want to test for interaction effects. But how to do that? For example, what is the interaction effect of treatment X and Y together and/or the effect of gender? Any advice for how to solve this would be highly appreciated.
KatrineKunst

Discussions |
May 27, 2020 11:54 AM

12397 views | 3 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

3583 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

1629 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

1486 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1325 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1287 views | 0 replies