JMP User Community

Latest Discussions

how to convert column names to a list of strings

Hi, I would like to convert column names to strings but I do not know how. dt = Open( "$SAMPLE_DATA/Decathlon.jmp" ); col_names = dt << Get Column Names(); Show(col_names);this leads tocol_names = {Name, Country, Score, Name("100m"), Long Jump, Shot Put, High Jump, Name("400m"), Name("100m hurdles"), Discus, Pole Vault, Javelin, Name("1500m")};I would like to have something like this instead:c...
newbie_alex

Discussions |
Apr 25, 2020 5:28 PM

18934 views | 20 replies
How to separate box plot groups with a straight line?

Hello Everybody,I manage to align data points to corresponding box plots but depending on data there can be more boxes in one group. For interpretation purposes I would like to draw additional lines on the plot that will visually separate each "F" group, like in the right hand picture attached. I would appreciate for hints how to do that. Best regards.
lukasz

Discussions |
Apr 25, 2020 10:52 AM

1946 views | 2 replies
JMP and R connection issue

I just saw a cool webinar today on using some features in R that are not available in JMP via JSL. I am specifically talking about t-SNE: Data visualization with t-SNE and UMAP . I am running JMP 14 on Mac OS 10.13 (High Sierra) and, according to the add-in link above, the R version to get is 3.3.3, so I downloaded that, restarted, and followed this: https://www.jmp.com/support/help/en/15.1/index....
abmayfield

Discussions |
Apr 24, 2020 12:34 PM

11412 views | 9 replies
Setting legend color pallet on graph builder

I have a script that creates a graph builder output with a dataset that has a variable number of items in the legend and variable number of frames. I'm able to get the frame tree structure then format them but unable to format the legend. I think I'm close but something is not functional in the very last line.Here's an example script.Names Default To Here( 1 ); dt = Open("$SAMPLE_DATA/Solubility...
SamKing

Discussions |
Apr 24, 2020 10:39 AM

2112 views | 2 replies
Create a subset based on date filtering

Hello all,I have a JMP data table on which I want to create a script to create a subset based on a timeframe I want to keep flexible.Looking on the community I found the following piece of script (reported here below) which is good for me, I'm only missing the part of code where, after selecting the start date and end date the subset is created in a new datatable.Someone can help me?Thanks. dt = c...
js1985

Discussions |
Apr 24, 2020 3:21 AM

1674 views | 1 replies

Previous
Next

Latest Discussions

JMP and R connection issue

I just saw a cool webinar today on using some features in R that are not available in JMP via JSL. I am specifically talking about t-SNE: Data visualization with t-SNE and UMAP . I am running JMP 14 on Mac OS 10.13 (High Sierra) and, according to the add-in link above, the R version to get is 3.3.3, so I downloaded that, restarted, and followed this: https://www.jmp.com/support/help/en/15.1/index....
abmayfield

Discussions |
Apr 24, 2020 12:34 PM

11412 views | 9 replies
Create a subset based on date filtering

Hello all,I have a JMP data table on which I want to create a script to create a subset based on a timeframe I want to keep flexible.Looking on the community I found the following piece of script (reported here below) which is good for me, I'm only missing the part of code where, after selecting the start date and end date the subset is created in a new datatable.Someone can help me?Thanks. dt = c...
js1985

Discussions |
Apr 24, 2020 3:21 AM

1674 views | 1 replies
Multidimensional Scaling Plot

Hallo, Wie waren die Farben in Multidimensiona Scaling Plot? nach dem Beispiel des Links https: //www.jmp.com/support/help/en/15.1/? os = win & source = application & utm_source = helpmenu & utm_medium = a ... , eingestellt? Danke für Ihre Hilfe.
Mi

Discussions |
Apr 23, 2020 11:35 PM

3063 views | 7 replies
Scripting Graph Builder - Box Plot to Points?

Hello, I am finding scripting to the Graph Builder a brutal experience (I have been scripting JMP for some time). It doesn't seem to be intuitive, nor can I seem to find the specific help I need. So I'm waving my white flag and asking the group. My script grabs the correct columns (which vary in count) and creates a Graph Builder with two nested X levels all properly. The problem is that although...
FJMoesler

Discussions |
Apr 22, 2020 4:58 PM

2800 views | 6 replies
Variability chart: connect cell means across groups

In a variability chart, when "Connect Cell Means" is selected, no line is drawn from one cell to the next cell in the neighbouring group: Is this possible? I.e. drawing a line from the mean of One:Third to the mean of Two:First? Thanks,Marcus
gandi2223

Discussions |
Apr 22, 2020 2:56 PM

2054 views | 2 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

1629 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

1486 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

1325 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

1287 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

1399 views | 0 replies