JMP User Community

Latest Discussions

Add a csv to a JMP Data Table

Hi all. I've looked around to see if there is a script that adds/imports a csv file while still keeping the old data. My objective is to have a master JMP file. Then everytime I test a different device/different date, I would like it to be added to the master JMP Data table without overwriting it. I've seen code that meshes all csv files in a folder, but I would like it for just one csv file at a ...
mochar

Discussions |
Mar 27, 2020 7:28 PM

1638 views | 1 replies
two plots on one graph

Hi all - I'm new to JMP's graph builder. I'm sure this is easy but alas...

I need to present two plots on one graph:
1. bars with s.e. bars (mean long-term rainfall by month)
2. line (no error bars) rainfall data from a single year, also by month

So, same x and same y axes.

Thanks in anticipation.
malurus

Discussions |
Mar 27, 2020 1:59 PM

16014 views | 6 replies
Vertical scrolling keeps going after I release the mouse

(JMP 13.2.1 64-bit on Windows 10 Home) Hi,Since the release of the update prior to my current version, the vertical scrolling behavior when moving up and down a data table has become very strange. I have never seen this in any other application. If I click and drag the scrollbar slider with the mouse and let go, scrolling *sometimes* continues. It starts fast at first and then slows down. I don't ...
JohnnyMalaria

Discussions |
Mar 27, 2020 1:29 PM

10182 views | 12 replies
Clustered bar chart by variable

Hi all, This might sound like a simple question but I haven't figured out a way to make this work. I ran a test on multiple samples and for each sample, the test outputs the percentages of the three different components that make up the sample. I set up a data table with 4 columns: 1 for sample name and the other 3 for the percentages of the 3 components.I'm trying to create a clustered bar chart ...
hxnduke

Discussions |
Mar 27, 2020 1:18 PM

9225 views | 10 replies
How to update display boxes in jmp?

Hi,I have a display box (Text Box) which I would like to update in a for loop.I see that I am not able to reliably update the Text Box in the loop.This is really annoying because I have a lot of files to process and it is not possible toalways physically check the drives to see if files are being processed.I am using Wait(0) so as to allow jmp to catch up. I have tried busy light as well which has...
AD1

Discussions |
Mar 27, 2020 6:56 AM

4301 views | 6 replies

Previous
Next

Latest Discussions

Vertical scrolling keeps going after I release the mouse

(JMP 13.2.1 64-bit on Windows 10 Home) Hi,Since the release of the update prior to my current version, the vertical scrolling behavior when moving up and down a data table has become very strange. I have never seen this in any other application. If I click and drag the scrollbar slider with the mouse and let go, scrolling *sometimes* continues. It starts fast at first and then slows down. I don't ...
JohnnyMalaria

Discussions |
Mar 27, 2020 1:29 PM

10182 views | 12 replies
How to update display boxes in jmp?

Hi,I have a display box (Text Box) which I would like to update in a for loop.I see that I am not able to reliably update the Text Box in the loop.This is really annoying because I have a lot of files to process and it is not possible toalways physically check the drives to see if files are being processed.I am using Wait(0) so as to allow jmp to catch up. I have tried busy light as well which has...
AD1

Discussions |
Mar 27, 2020 6:56 AM

4301 views | 6 replies
Fit Y by X - how to perform a specific test on multiple resulting graphs.

When "Fit Y by X produces multiple is the a way to perform an additional test on all the results without repeating the command individually?Thank youJoe
Wantj43

Discussions |
Mar 25, 2020 10:03 PM

2261 views | 3 replies
Concatenating large number of files

Hi Guys,

I am trying to concatenate several files in a folder as below:

Discussions |
Mar 25, 2020 3:57 PM

7993 views | 11 replies
Reference Table file name in SQL query

Hi @stan_koprowski , I used JMP Query Builder to create the following SQL Query Names Default To Here( 1 ); //Prompt to select and open an MS Excel file dt1 = Open( Pick File( "Select Excel File", "$DOCUMENTS", {"Excel Files|csv;xlsx;xls", "All Files|*"}, 1, 0 ), Invisible ); //Prompt to select an open a JMP data table dt2 = Open( Pick File( "Select JMP File", "$DOCUMENTS", {"JMP Files|jmp", "All...
Jackie_

Discussions |
Mar 25, 2020 9:24 AM

3256 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

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