JMP User Community

Latest Discussions

Can you add outline to Data table when saving as image?

I am creating summary tables using JSL and want to save them as images. I was able to get that to work, thanks to another post from the JMP community.However, the image is always saved with all the borders removed which makes it hard to read at times. Here is my sample code :mypath = "C:/JSL/"; Set Current Directory( mypath ); //sets output directory to variable 'mypath' DT = Data Table( "Try" )...
skumar0789

Discussions |
Feb 11, 2020 11:07 AM

2570 views | 3 replies
Variability chart for columns as list in JSL

Hi,What is the way to run Variability chart with X axises from list of strings.Thanks. dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
columns_list = {"sex","age"};
Variability Chart( Y( :height ), X( columns_list ) );
tom_abramov

Discussions |
Feb 11, 2020 2:46 AM

2847 views | 2 replies
How to get correct and Predictive model

Hi, I need your help again.

I've been doing an analysis recently and the contents are simple.
It's data with 376 rows, 223 columns, and single Y value.

To get the Y-value prediction model, I used 'Fit - Models'(Fit Least squares - standard Least squares / Effect Screening), and I first got the R-Square 0.95, using row 1 to 263. I added the Predict formula to the 'New column' and compared the estimate...
Dongjin

Discussions |
Feb 10, 2020 4:27 PM

4652 views | 4 replies
Delete Column

I have 190+ columns and I wanted to delete columns stored in the listRemain_columns = { column names I want to remain}.
How do I do it using for loop?
skyzvoir0001

Discussions |
Feb 10, 2020 4:00 PM

2486 views | 1 replies
Stacked Bar Graph Builder with >10 Discrete Overlay Items - Avoid Summary Statistics

Currently on JMP 14.2. My team uses stacked bar charts of the amount of time each step in our production process took for each batch. I'm attempting to add another, but keep running into a confusing issue with Graph Builder. Our batch system has ten discrete process steps and I'm attempting to add an eleventh. My data table is structured with each row is a unique Batch+Step combination with its du...
jsrmfh

Discussions |
Feb 10, 2020 1:48 PM

2598 views | 2 replies

Previous
Next

Latest Discussions

Delete Column

I have 190+ columns and I wanted to delete columns stored in the listRemain_columns = { column names I want to remain}.
How do I do it using for loop?
skyzvoir0001

Discussions |
Feb 10, 2020 4:00 PM

2486 views | 1 replies
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

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