JMP User Community

Latest Discussions

Select rows with maximal values in one column

I can use summary to find the maximums (multiple due to groups) in one column. However, I also want to look up in which rows in the original table the maximums occur.

Is there an easy solution? Thanks for your help!
new-jmper

Discussions |
Aug 3, 2020 9:52 AM

22159 views | 12 replies
How to save the sas7bdat files made when a study is added in JMP Clinical?

I just upgraded to JMP Clinical 7 from 5. I used to be able to add a study from a folder of xpt files, and JMP Clinical would write as the sas7bdat version of each xpt file back into the same folder on my computer. This was useful when the original xpt files had dates in SAS format not readable in JMP; the sas7bdat files would have JMP-readable dates. Using JMP Clinical 7, I can see the sas7bdat...
NoName

Discussions |
Aug 3, 2020 7:48 AM

4292 views | 5 replies
How to recover deleted .jmp file?

I accidentally click "delete" for a .jmp file when opening up the JMP software. May i know how to recover it? Thank you.
bp2020

Discussions |
Aug 3, 2020 6:28 AM

4828 views | 5 replies
Unexpected error during script

Hello, I'm writing a script to deconvolute a json file.Once in jmp, the resulting table is composed of groups of columns labelled such as study.xyz, study.cro, groups.xyz, groups.id, test.xyz, test.name,... I'm trying to create a series of tables for each of the groups such as study/groups/test.I have a script that does that well when each subset is handle separately but for some reasons it stops...
Sburel

Discussions |
Aug 2, 2020 9:56 AM

3985 views | 6 replies
Text Edit Box Inside a For Loop

Hi, I want to generate text edit boxes using a For Loop. I was wondering how could I get text from each text box and use it later (I need to use it later in a Select Where function) Here is my script. It can generate the display boxes but seems can not get the text from them. There is an error message.prefix = []; win = New Window("Start", <<Modal, <<ReturnResult, vlb = Vlistbox(), Fo...
hahahaqing

Discussions |
Jul 31, 2020 7:36 AM

1607 views | 1 replies

Previous
Next

Latest Discussions

Text Edit Box Inside a For Loop

Hi, I want to generate text edit boxes using a For Loop. I was wondering how could I get text from each text box and use it later (I need to use it later in a Select Where function) Here is my script. It can generate the display boxes but seems can not get the text from them. There is an error message.prefix = []; win = New Window("Start", <<Modal, <<ReturnResult, vlb = Vlistbox(), Fo...
hahahaqing

Discussions |
Jul 31, 2020 7:36 AM

1607 views | 1 replies
Overlay different plot type for different data set

I want to have a scatter plot for dataset 1 and line plot for dataset 2 in a single plot or graph builder. It is more like the way we can change the plot type for different dataset in excel, when both dataset are plotted in a single graph. Any idea how to do that in graph builder
mrq

Discussions |
Jul 30, 2020 10:17 AM

2675 views | 3 replies
How to design a DOE covering 3 systems, 8 factors and 6 products resulting in one optimal setting?

I'm designing a DOE design with 7 variables that are all continuous. My expectation is 2 of these factors will probably have an optimum curve that is not linear, I also expect interactions between my variables. I have 3pc of the system I'm testing on and my system needs to be able to handle 6 different products - my problem is that I need to find one compromise in settings that provide the optima...
MiaS

Discussions |
Jul 30, 2020 10:13 AM

1520 views | 1 replies
Split plots

I am helping a colleague analyze some data, and he set up his experiment in a simple manner, but one in which I have never seen. He had reef corals in aquaria and wanted to see under which conditions they grow best. Normally, you would have many tanks, each with its own set of conditions, but he used huge tanks (to make them more "reef-like") in which conditions varied WITHIN tank. I am specifical...
abmayfield

Discussions |
Jul 30, 2020 8:23 AM

11218 views | 9 replies
I have a script, and I want to add some values to my data in a specific row and column. There are no unique values to where I could use an if statement to signify the row. Are there any other options to do this?
GardDog

Discussions |
Jul 30, 2020 6:10 AM

1319 views | 1 replies

Previous
Next

Latest Discussions

XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1486 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1691 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1421 views | 0 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1288 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1309 views | 0 replies