JMP User Community

Latest Discussions

how can i save a JMP file as a name with time string?

how can i save big class.jmp as a name with time string? Thankse.g. dt = Open("$SAMPLE_DATA/big class.jmp"); Hope the script can identify the work week, and the day of week and add automatically on the name, thanks Result i want:save name as:big class-ww12.1big class-ww12.4big class-ww12.5
Theresa

Discussions |
Mar 16, 2020 5:33 PM

4737 views | 5 replies
Proportions Testing

There is a calculator for proportions testing but is there a quick way to check a proportions hypothesis. Say I want to calculate the 95% Confidence interval for 75 of 100 parts passing as well as compare that to a typical 80% FPY value is there a way to do that easily? Currently only solution is to create a sheet of 1s and 0s to get the CI and then change the values to nominal to test probabilit...
pickerins

Discussions |
Mar 16, 2020 1:59 PM

3203 views | 2 replies
How can I create a Power Curve in JMP?

Hello!Please, explain how I can create a Power Curve in JMP? I want to graph the power curve for 7 values of mean and I know the null hypothesis.
Fatemeh_2020

Discussions |
Mar 16, 2020 5:35 AM

3448 views | 2 replies
Creating a Pass Fail Map in JMP

I have inspected a wafer with 9 units on it. It is a 3X3 array of units (9 samples or parts) on wafer. I have their Column Row number and pass fail results in a table. A sample table is attached. I was wondering if it is possible to create a pass fail map graph (attached) where pass units are highlighted in green and failed units are highlighted in red. I would like to create a JSL script to do th...
rverma

Discussions |
Mar 16, 2020 2:52 AM

3517 views | 1 replies
Standardized plot in graph builder with spec limits

When I drag and drop multiple coulumns with diffrent spec limits in the Y or X axis, JMP makes something like a standardized plot with point or boxplots.It's a very nice feautre, but I could not find the documentation how the blue (spec) and gray (reference frame) lines are calculated. Thanks!
Mauro_Gerber

Discussions |
Mar 15, 2020 11:21 PM

5643 views | 6 replies

Previous
Next

Latest Discussions

JMP script - Color or Mark by Column

I have a JMP table with a column called Order that contains letter values like A, B, C, D, E, etc., and another column called Number that contains number values like 1, 2, 3, 4, etc. Manually operating on this table, I could do the following:-- Right click at the upper left of the table and select Color or Mark by Column-- Select Order from the list of columns, then leave Colors = JMP Default and...
fbm73

Discussions |
Mar 15, 2020 4:16 PM

2744 views | 1 replies
how to find and replace all instances of specified characters within a given column

This is a very simple question. I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of specified characters within that column. For example, I have a column called GROUP, and certain rows in GROUP contain values like "A05 or "B17 and I would like to replace all " characters in GROUP so that the entries become A05 and B17 instead of "A...
fbm73

Discussions |
Mar 15, 2020 5:37 AM

8844 views | 4 replies
How to copy Directories from one place to another?

Hi,I have run into a problem all of a sudden. I wish to copy files and directories and I am not able to do that anymore.I use Copy File() and Copy Directory().Somehow Copy Directory() doesn't recognize my paths anymore or occasionally fails.So, I would like to know:1. How to copy a directory (say D:/copyme) inside another directory (D:/destination) ? So that I have D:/destination/copyme as the fin...
AD1

Discussions |
Mar 13, 2020 4:33 AM

3164 views | 4 replies
PLS modeling - "0 factors" is advised

Hi everyone !

Here's my situation: I have a dataset of 58 batches in line, and 213 columns corresponding to my parameters Xs (ex: Glucose at culture day 1, Glucose at culture day 2 etc...) . I have couple of data missing here and there depending on the X and the batches but on the overall the dataset is quite fine.Now I want to use PLS to put all my Xs and try to understand which of them impact my ...
Elofar

Discussions |
Mar 12, 2020 12:22 AM

4469 views | 5 replies
Delete cell values based on a column condition and merge rows with same timestamp using JSL

Hi, I have following "TestData":1. I want the cell value to be null when the status is down. for example ("A status " cell value is "down" the value in Column "A" should be null instead of "1334". should do the same for B , C and D Columns.2.Delete all the columns that has "status" in the column name. Output should be something like this:3. Now all the same timestamp rows should be merged. expect...
himajamuppalla

Discussions |
Mar 11, 2020 4:11 PM

2063 views | 1 replies

Previous
Next

Latest Discussions

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

2263 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

2064 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

1693 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

1624 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1718 views | 0 replies