JMP User Community

Latest Discussions

Create a loop to add column properties to columns that contain a specific header

Hello, Being still new with JSL, I'm still struggling with the implementation of certain concepts namely looping. Any way, I'm trying to create a script which would add to any column in a table in which the header contains "Norm" a number of specific column properties.dt=current data table(); a = "Norm"; col = dt << get column names( string ); nc = N Items( col ); For( i = 1, i <= nc, i++, If( Con...
Sburel

Discussions |
May 13, 2020 7:45 AM

2040 views | 2 replies
What's the relation between "coefficient estimate" in the model and "effect size" in the power analysis?

Hi,  When using the "Fit Model" platform, I get a table of with the parameter estimates for the model. Parameter Estimates   Term Estimate
Intercept                                 -2.064624
x1                                            7.0881103
x2                                            11.977504
(x1-0.98875)*(x2-1.04406)      2  So the model coefficients are 7.088... for x1, 11.977... for x2 and...
matthias_bruchh

Discussions |
May 13, 2020 6:14 AM

3128 views | 3 replies
JMP Tabulate by list of column names in JSL

Hello, I have table and I want to tabulate it by column "student", column "subject" and column "class" but column "Subject" and column "class" is not necessary to available in the data.If it has column "subject" but not column "class" then it should tabulate by column "student" and column "subject".If it has column "class" but not column "subject" then it should tabulate by column "student" and co...
Rajat

Discussions |
May 13, 2020 6:06 AM

5121 views | 6 replies
Creation of a new column based on grouping of other columns

Hi All,I am trying to create a new column "Status" which will return "Active" or "Replaced" based on the following specification (attached part of the table with "Status" column as illustration of expected result). Each TOOL and Site can replace different Sub_Tool during time and runs several units with its time stamp. The most recent Sub_Tool for the specific Tool and Site should receive Active ...
DZ_932

Discussions |
May 13, 2020 2:56 AM

16940 views | 5 replies
points and lines in a graph

hi, how to do so that the points are not slightly offset ? best regards
Françoise

Discussions |
May 12, 2020 11:35 PM

4964 views | 5 replies

Previous
Next

Latest Discussions

Creation of a new column based on grouping of other columns

Hi All,I am trying to create a new column "Status" which will return "Active" or "Replaced" based on the following specification (attached part of the table with "Status" column as illustration of expected result). Each TOOL and Site can replace different Sub_Tool during time and runs several units with its time stamp. The most recent Sub_Tool for the specific Tool and Site should receive Active ...
DZ_932

Discussions |
May 13, 2020 2:56 AM

16940 views | 5 replies
Difference between two Cpk analysis tool

Hi all, I have generated random data from Johnson Sl distr. and saved it in a column. Now, when I use these two Cpk analysis tolls, I get diff. results:1. Analyze> Quality and Process> Process capability2. Analyze> Fit > Capability analysis (I have tried all of the options for long term, moving range, ...)For both method I chose Johnson Sl distr. and the same USL.So, how come I get diff. results? ...
mkhoddam

Discussions |
May 12, 2020 10:27 AM

5443 views | 9 replies
Evaluation of the existing model

Hi All,I had created a predictive model and recently my colleagues at QC had to change one of their ingredients, which is one of the many variables in the model, to continue batching their products. I want to evaluate the existing model instead of fine-tuning it because there is not enough data yet and changing it will lower the accuracy. They have new measured responses, using the new ingredient,...
Amir_H

Discussions |
May 12, 2020 8:46 AM

5513 views | 7 replies
Concatenate strings to create variables within a formula

Hi, beginner JMP user here, I would like to create a new column "Tag Range" which has the formula in it "Tag.ULIMIT-Tag.LLIMIT". Tag.ULIMIT and Tag.LLIMIT are columns in my data table. I can create the column by explicitly defining the column names in the formula as below, but I would like to replace these with the variables "UpperLIMIT" and "LowerLIMIT". (ultimately, I would like to run a script ...
spudton

Discussions |
May 12, 2020 5:41 AM

2622 views | 1 replies
Tabulate configuration support

Hi, I'm trying to create new score card for our group,the score card seems to work great, I just wanted to add the option for the user to have only the first grouping columns (:owner), and if he press on a relevant button then the net grouping column will appear (:buckets), is their an option to do it?also, it seems that the ROUND() function does not work in this setting, any other option?thanks f...
Hamal22

Discussions |
May 12, 2020 4:21 AM

2039 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

4549 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

2116 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

1953 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

1613 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

1566 views | 0 replies