JMP User Community

Latest Discussions

Filter the most frequent value in multiple columns

Hi everyone, My goal is to select only the rows that have the most common values (character type) in each column. For instance, my table has four columns: A, B, C, and D. The values that appear the most in columns A, B, C, and D are A1, B2, C3, and D4, respectively. How can I write a JSL code that filters the rows by these values and creates a new table with the filtered data? Thank you. Thanks
Dzungtran

Discussions |
Sep 29, 2023 11:47 PM

1291 views | 2 replies
date differences in two datasets

Hi, I have two datasets on a cohort of patients. One has dates of test “a” and the other has dates of test “b”. the number of tests a and b on a subject vary (i.e., some have a lot of a and few b or visa versa) I need to find all instances where tests a and b are within a timeframe (90 days for this project). How could I automate the comparison of all combinations of test a and b to find the te...
jsolo01

Discussions |
Sep 29, 2023 11:41 PM

2416 views | 7 replies
Does JMP label the centroid in a mixture design?

Center points in small design spaces can often be identified in the data table by inspection. This becomes much more difficult for mixture designs with large numbers of components (>=5), especially when linear constraints are superimposed. When design points match classical designations (e.g., vertices, centroids, binary double blends, axial check points, etc.), does JMP have the ability to lab...
wvknowles

Discussions |
Sep 29, 2023 7:18 PM

990 views | 2 replies
When I save figure as SVG, text rotation is lost.

Hello all -I'm running JMP Pro 16.1.0 and I have an issue that is driving me insane. I have a fairly complex figure with tons of data. I need to add some text labels to it so I can describe different periods of time. The text needs to be rotated so that it will fit in the space and read well. I read on a post that Text Annotations cannot be rotated counterclockwise, but plain old text text can. ...
HydroBug

Discussions |
Sep 29, 2023 4:06 PM

2054 views | 4 replies
When exporting graph as image the background of the graph box remains white even when set as "transparent" in the report preferences.

Hello all -I am working with JMP Pro 16.1.0. When exporting my graph as an image file, the background of the graph box remains white even when I have set the background as "transparent" in the report preferences. Below is an example when I exported an SVG file: the titles and axes export as transparent, but the graph box continues as white. I tried exporting as various types of image files in hap...
HydroBug

Discussions |
Sep 29, 2023 12:16 PM

2164 views | 3 replies

Previous
Next

Latest Discussions

date differences in two datasets

Hi, I have two datasets on a cohort of patients. One has dates of test “a” and the other has dates of test “b”. the number of tests a and b on a subject vary (i.e., some have a lot of a and few b or visa versa) I need to find all instances where tests a and b are within a timeframe (90 days for this project). How could I automate the comparison of all combinations of test a and b to find the te...
jsolo01

Discussions |
Sep 29, 2023 11:41 PM

2416 views | 7 replies
Does JMP label the centroid in a mixture design?

Center points in small design spaces can often be identified in the data table by inspection. This becomes much more difficult for mixture designs with large numbers of components (>=5), especially when linear constraints are superimposed. When design points match classical designations (e.g., vertices, centroids, binary double blends, axial check points, etc.), does JMP have the ability to lab...
wvknowles

Discussions |
Sep 29, 2023 7:18 PM

990 views | 2 replies
Can I save each page of a graph(from graph builder) into one separate image file?

I generated lots of pages from one graph. This is from graph builder. I like to save each page as one image file. Is this possible in JMP? Thanks,
Dave
davidmingyin

Discussions |
Sep 29, 2023 9:35 AM

3750 views | 6 replies
Recoding column with both char and num

I am working on a dataset with > 1M rows, with a column 'Reported Results'.In this column, approx. 3000 rows contain a '<' or '>' (always followed by a value, e.g. <100), all other rows are numeric. When importing the datafile, JMP marked the Data Type for this column as Character.I tried converting the 5000 rows, containing a '<' or '>', by using Column Recode. I saved the script to File (see att...
WernerL

Discussions |
Sep 29, 2023 8:54 AM

4082 views | 9 replies
Reproducing JMP Genomic Scripts in JMP Pro

Hi, I am transitioning from running microarray data in JMP Genomics to JMP Pro. I routinely use the predefined JMP Genomics scripts such as:Analytical Processes/Workflows/Basic/Basic Expression Workflow orAnalytical Processes/Expression/Normalization/Data Standardize procedures.I was able to reproduce the STD normalization steps of the Normalization script but not the Basic Expression workflow.One...
JeandO

Discussions |
Sep 29, 2023 6:54 AM

2494 views | 1 replies

Previous
Next

Latest Discussions

What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

848 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

561 views | 0 replies
Use JMP Locale Settings( 0 ) not working on macOS

It seems the following command does not work for JMP MacOS. Use JMP Locale Settings( 0 ) Is there a general script to deal with the following scenario? Or do we need to put conditionals depending on the OS of the user? // Configuring JMP to save CSV as commas and not If( (Num( "3.14" ) == 3.14), is_EN_num_format = 1, //"English numeric format" is_EN_num_format = 0 //"Non-english"); )...
FN

Discussions |
Sep 15, 2023 10:21 AM

674 views | 0 replies
Inherited Plot settings

Hi,
I noticed some strange behavior in Graph Builder which is caused by the fact that formatting like

One example:
If the top-most plot (#1) has some specific settings and this plot is removed, instead of removing the settings with the subplot, the settings are then applied to the plot which is now @ "top" (old #2 -> new #1).So, old plot #2 will inherit the color settings and the manually changed axi...
hogi

Discussions |
Sep 14, 2023 11:11 PM

654 views | 0 replies