JMP User Community

Latest Discussions

How to use the formula row by row to find the dynamic change of the total number of columns.

How to use the formula row by row to find the dynamic change of the total number of columns.
Such as setting:
The number a is the number of starting column positions that need to be summed
The number b is the total number of columns that need to be summeddt = Open( "$SAMPLE_DATA/Diabetes.jmp" ); dt << New Column( "test", formula( As Column( 6 ) + As Column( 7 ) + As Column( 8 ) + As Column( 9 ) ) );...
lwx228

Discussions |
Feb 10, 2020 3:40 AM

2960 views | 3 replies
Selecting multiple columns and do histogram in a script

Hi,I have written a script to select two columns from a table and do histogram. I like to be able to select an arbitary number of columns and do histogram for selected one. Can one help me achieve that? I have liste my script below. Thanksdt = Open( "A.csv" );xvar = .;yvar = .;win = New Window( "Choose Two Variables",<<Modal,<<On Validate(// require the user to select two variables before clicking...
AT

Discussions |
Feb 9, 2020 11:25 PM

6891 views | 4 replies
Setting path to R location

HelloI would like to be able to run a couple of R-scripts I have. Additionally, I'd like to run some of the JMP add-ins that utilize R (ex. Chernoff Faces). Is there a way to set the pate within preferences or tell JMP where the location of R is on my laptop. Its not under program files (due to admin rights), as I'm assumming that's where it might be looking. It is definately on my laptop ho...
Jim_G_Pappas

Discussions |
Feb 9, 2020 9:37 AM

8396 views | 3 replies
How do I create a new column and insert a text x-rows before an 'event' and y-rows after the 'event'

Hi JMP Community, I am working with a table with thousands of rows. In one column certain rows are marked 'event' (e.g. an out-of-spec lot on a particular day). How can I create a new column where the x rows before an 'event' are marker PRE and the y rows after the event are marked POST. In the example below x=3 and y=5.Thank you for your help!
WernerL

Discussions |
Feb 9, 2020 9:07 AM

6513 views | 8 replies
Bivariate Fit - how to delete line fitting frame box

In jsl, how do I delete the box containing all of the "Fit Each Value" line items. I want to keep the plot with the fitted lines, but delete box containing all of the "Fit Each Value" lines which can be >100 items long and makes scrolling through many plots painful.
RonSwanson

Discussions |
Feb 7, 2020 2:24 PM

2215 views | 1 replies

Previous
Next

Latest Discussions

Splitting columns

Hi, i have a column full of dates with different time points in the date. Eg:2020-01-31T11
2020-01-31T12
2020-01-31T13
2020-01-31T14
2020-01-31T15
2020-01-31T16
2020-01-31T17
2020-01-31T18
2020-01-31T19
2020-01-31T20
2020-01-31T21
2020-01-31T22
2020-01-31T23
2020-02-01T00
2020-02-01T01 but I want to split them into two separate columns: date and time. I'm a beginner so I'm still getting use to the software.than...
SMast

Discussions |
Feb 7, 2020 9:55 AM

2504 views | 2 replies
JMP 14 crush

Hi all, I have a big script that includes other smaller scripts. JMP (14.0.3) crushes allot of times when I try to execute the script, about ones every three runs. Does anyone know what the reason can be? Is there a crush report somewhere?
avner8943

Discussions |
Feb 6, 2020 5:57 AM

7275 views | 6 replies
Selecting data for past X number of days

I have a data set that contains past 60 days of data and I want just past 7 days of data. Data column name "OUT_DATE" in the format of MM/DD/YYY HH:MM:SS AM/PM. Date is not sorted and in random order. I found the following discussion answered by super user "txnelson" (https://community.jmp.com/t5/Discussions/Date-function-in-jsl/td-p/57122) and did my script as below dt=Open("Report.csv");// Ope...
djmomo

Discussions |
Feb 6, 2020 5:54 AM

2968 views | 3 replies
Formulas in data table not re-evaluating

Howdy, So today I have an issue with formulas not updating in my data table. I have a large table with a bunch of measurements. There is a script that sets columns with formulas to evaluate specifications contained in data table variables. These formulas are generated in the following way : Eval( Eval Expr(Column(Concat(columnName," Spec"))<< Set Formula( If( Column(expr(columnName))[]>Expr(USL),...
bobmorrane

Discussions |
Feb 6, 2020 5:37 AM

3203 views | 1 replies
Analysis of Means - Transformed Ranks

Hello together,I found a function in JMP and was wondering when to apply the Transformed Ranks option within the Analysis of Means menu. I read the reference from Nelson et. al, provided by JMP, but I am still not quite sure if I apply it properly. Unfortunetaly, I do not really find any other references which are useful. If I compare groups (measurements instruments with same sample set) with non...
Martin91

Discussions |
Feb 5, 2020 8:23 AM

1902 views | 1 replies

Previous
Next

Latest Discussions

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

2016 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

1660 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

1600 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

1681 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

2077 views | 0 replies