JMP User Community

Latest Discussions

Suggestion on how to script a small update/progress window for modeling

Dear JMP Community, I'm interested in scripting a small window that pops up when I run my model building script to show me at which step (out of thousands) is it currently running. I'm thinking of doing something like the following script, which works, but also makes a new window each time.Names Default To Here( 1 ); imax = 5; For( i = 1, i <= imax, i++, update_window = New Window( "Progress Up...
SDF1

Discussions |
Mar 3, 2020 1:00 PM

3468 views | 3 replies
Converting Seconds since the epoch to datetime

I have a column of data representing datetime stamps that is stored in seconds since the epoch (1 Jan 1970). How can I make JMP interpret these integers as datetime stamps?
jfsilves

Discussions |
Mar 3, 2020 12:45 PM

3238 views | 2 replies
JSL prompt user for data table name (not saving)

My first JMP community post! JSL has been enormously helpful for me in my work. Thanks all for your inputs. I'm running a script which concantenates two files. I'd like to prompt the user when it's complete (or before it starts, doesn't matter) for what s/he would like to name the data table. The user can then save the data table later if s/he is happy with it. I don't want to obligate a file ...
datanaut

Discussions |
Mar 3, 2020 12:43 PM

4326 views | 3 replies
Graph Builder Add p Values dynamically: recommended workflow

Hi JMP community, I often need to annotate Graph Builder plots (~200) with the results of an analysis (e.g. p Values. Estimates). So far, I have mostly relied on manual annotations but I'm starting to be tired of this approach. I know how to add text dynamically via scripting but I have not figured out a good way to solve my specific problem (see below) What would be your recommended workflow in t...
Thierry_S

Discussions |
Mar 3, 2020 2:46 AM

3799 views | 3 replies
How to walk a directory with many sub-folders to fetch specific files?

Hello, I have a folder/directory with many sub folders. In each of the subfolder there are bunch of csv files. Each csv file has a unique ID in the filename. My question is that if I have a list of IDs then how can I traverse the directory to fetch those specific csv files and concatenate them in a jmp table? Is there a way to do it with a script (JSL)? I will appreciate any guidance. CSV file nam...
rverma

Discussions |
Mar 2, 2020 2:42 PM

3711 views | 3 replies

Previous
Next

Latest Discussions

Displaying n values above above bars

Hello, I'm trying to display the n sample size for each category in my graph above the error bars on my graphs. For example, I'm looking at data and comparing findings from different states, which are my categories, and I'd like to display how many respondents, my n, were in each category.
smit3000

Discussions |
Mar 2, 2020 9:44 AM

2535 views | 2 replies
Help with Col List Box

I'm trying to create a dialog with a Col List Box (CLB). I populate my CLB using the following:sourceColList << Append( DataTable1 << Get Column Names() ); sourceColList << Set Analysis Type( Continuous ); sourceColList << Set Data Type( Numeric ); sourceColList << Set Max Selected( 1 );and when I create my window everything looks fine, and I can select items in the CLB.But here's the thing: when...
john_madden

Discussions |
Feb 28, 2020 9:49 AM

1432 views | 1 replies
Keep Leading Zeros

One of the columns in my data set is Employee ID. All employee ID's have a length of 8 and begin with leading zeros. When I open the excel file that has the data JMP seems to drop those leading zeros. Is there a way to get JMP to not do that? Or does it have to do with the way that column is stored in the xlsx file? I tried using the code I found on here to just add them back in but it added them ...
ACraig

Discussions |
Feb 27, 2020 11:33 AM

2717 views | 2 replies
cutting out violin plot or box plots

Hello all,I need to cut out the drawn violin plot in the way that only the outside line exists and the rest (the inner body) is transparent, because I have to fit the plot over some points (points should be still visible underneath the plot.Has anybody recommendations or ideas for how that would work out? Thanks in advance for your help!
Bachelorgi

Discussions |
Feb 27, 2020 11:03 AM

2419 views | 2 replies
Interpretation about Split Plot Design Example in JMP

Hello, I have a question about the example of Split Plot Design Example, introduced in JMP webpage.https://www.jmp.com/support/help/14-2/split-plot-design-example.shtml In this explanation, an animal identification code called subject, with nominal values 1, 2, and 3 for both foxes and coyotes. Then it was nested in species. Then subject[species] was selected as random effect, and then REML methos...
JK

Discussions |
Feb 27, 2020 10:52 AM

1954 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

1626 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

1483 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

1324 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

1285 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

1398 views | 0 replies