JMP User Community

Latest Discussions

How do use JSL to quickly compare two sets of range columns in order to get the minimum of each column?

The title is a bit hard to understand. Take this big class as an example:
1. First, summarize the average values of "height" and "weight" by age.
2. Then summarize the median of "height" and "weight" by age.
3. Then compare the mean and median of "height" and take their minimum.
Finally, compare the mean and median of "body weight" and take their minimum. I'll use the following code and finally loop t...
lwx228

Discussions |
Jun 4, 2020 3:49 PM

2881 views | 4 replies
HTML import as data table issue

I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!". when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...
danielharding0

Discussions |
Jun 4, 2020 2:01 PM

2745 views | 4 replies
Unstacking a Stacked Excel Cell or Parsing Free-form Text to Generate Multiple Rows

We all run into some version of this: Excel table formatted to look nice, no thought given to analyzability.In the free-form text cell, it looks like this: m/d: text [alt+enter]
m/d: text [alt+enter]
m/d: text [alt+enter]
m/d: text [alt+enter]
...
m/d: text [alt+enter] When the data are exported to JMP, the cell gets collapsed into: m/d: text m/d: text m/d: text ... m/d: text.
I want to parse that long ...
markschahl

Discussions |
Jun 4, 2020 11:47 AM

3062 views | 3 replies
How to get partitioned sum of squares in ANOVA results of fit model

Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.
ricardor

Discussions |
Jun 4, 2020 5:30 AM

1632 views | 1 replies
Pareto Graph - changing cumulative percent formatting label

Does anyone know if it is possible to change the formatting of the cumulative % label in the pareto plot? This was made using the Failure.jmp sample data table and Analyze --> Quality and Process --> Pareto Plot as shown below
wendytseng

Discussions |
Jun 3, 2020 11:24 AM

2787 views | 1 replies

Previous
Next

Latest Discussions

HTML import as data table issue

I have been using the open() function for a HTML file. I'm now dealing with a column that has values such as "<2.4!". when I use the open() function, it imports those values as "" in the data table. However, when I do it using prompts in JMP, after opening the html file, I'm able to open the html file using 'Import table as Data Table' and the correct value of "<2.4!" is imported. Is there a way ...
danielharding0

Discussions |
Jun 4, 2020 2:01 PM

2745 views | 4 replies
How to get partitioned sum of squares in ANOVA results of fit model

Not just CTSS, SSmodel and SSE, I mean SS for individual predictors. How do I get it from fit model results? Thank you.
ricardor

Discussions |
Jun 4, 2020 5:30 AM

1632 views | 1 replies
DATA WIDE TO LONG FORMAT

Hi allI have data in wide format i.e col with three variables: predicted, upper and lower and respective rounding options like round up of predicted, upper and lower, round down of predicted, upper and lower etc. which I want to reorganize it in long format i.e some constant rows like date and all of the value has to be reformatted into longer.I have attached the " have" and "want" data.Any h...
sweetycha

Discussions |
Jun 2, 2020 12:12 PM

4158 views | 1 replies
Add rows every x rows

Dear community, i've got a huge table and would like to add one row every 4 rows (4 rows data, adding 1 row, moving the rest of the data downwards, then adding 1 row after 4 rows of data aso).I have no clue how to achieve that with a script. Can anyone kindly help me with this topic?
Sandra

Discussions |
Jun 2, 2020 11:52 AM

3856 views | 7 replies
Autorunning the JMP script periodically

Hi, I'm trying to automate my everyday task. I want the following script to run periodically and save the output. Can JMP auto select from the drop down list and save the output?For ex. Selecting a Age then selecting a Name and then saving the output for all the age from 12 - 17 Thanks
Jackie_

Discussions |
Jun 2, 2020 8:54 AM

2192 views | 4 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

4451 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

2067 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

1907 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

1573 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

1525 views | 0 replies