JMP User Community

Latest Discussions

Graph Builder: calculating axis Max, Min, and Range for dynamic annotation placement

Hi JMP community, I have a script that plots data from a series of columns in one table grouped based on a variable (:VAR_CAT), and that adds dynamically text from another table, using Graph Builder. While this script works well, I have experienced some difficulty with the vertical placement of the dynamically added text (see script below). Specifically, I tried different approaches including:YMax...
Thierry_S

Discussions |
Apr 2, 2020 8:54 AM

6160 views | 4 replies
How to add a data table to web report?

I used the following example of create a project: project = New Project(); project << Run Script( dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Run Script( "Bivariate" ); dt << Run Script( "Distribution" ); ); Now when I use publish, I get the web report with Distribution and Bivariate plot. How do I add data table as well? Thanks for your help.
AT

Discussions |
Apr 2, 2020 4:38 AM

10062 views | 13 replies
Width of a button box

How can I reduce the width of a button box via JSL? I would like to create a very small button containing only a "+" sign.The default width of Button Box("+")resulting inis optically too large for my purpose. I was not able to find a way to control its size. Thanks for any hint.
JWi

Discussions |
Apr 2, 2020 12:31 AM

4995 views | 6 replies
Calculate Rate of Change Grouped by Column

I, like many others I suppose, are looking at the COVID-19 data (I got mine from https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-states.csv). I would like to plot the daily change in confirmed cases by State. I've been able to work it out by first sorting the data by State, and then calculating the deltas: If(:state == Lag(:state, 1), :cases - Lag(:cases, 1) )But is there any wa...
MarkDayton

Discussions |
Mar 31, 2020 2:37 PM

5423 views | 3 replies
Assigning Minimum value to a column

Hi folks,I have 2 files. 1st file: 2nd file : I am trying to write a script which will search for the Minimum age from the 1st file and assign the lowest age in the 2nd file For e.g. The 1st row which has three name Sam, John, Smith so the Value in the Minimum Age Column should be Min{Sam, John, Smith} Min{21, 27, 32} = 21 my final output will look something like this: Any suggestions please?Tha...
Jackie_

Discussions |
Mar 31, 2020 2:31 PM

7924 views | 13 replies

Previous
Next

Latest Discussions

How to add a data table to web report?

I used the following example of create a project: project = New Project(); project << Run Script( dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Run Script( "Bivariate" ); dt << Run Script( "Distribution" ); ); Now when I use publish, I get the web report with Distribution and Bivariate plot. How do I add data table as well? Thanks for your help.
AT

Discussions |
Apr 2, 2020 4:38 AM

10062 views | 13 replies
How can I write a script to automatically group columns in new table?

Hello, I am currently writing a script to essentially join three "reference" tables together using the Join, Transpose, and Update functions. My script allows the final output table to be updated each time I add rows to the first "reference" table. I was wondering if it would be possible to edit my script to automatically group columns (i.e. the "Group Columns" function) in the final output table ...
bhdarst

Discussions |
Mar 31, 2020 10:53 AM

2577 views | 3 replies
Copying data from Matrix to JMP file

Hi, I imported the data from the column properties into a matrix. My question is how can I copy data from matrix into JMP file?Spec2 = Function( {co}, a = Column( co ) << get property( "Spec limits" ); b = a["UL"]; C = Matrix( {b} ); );Copying data from Variable C into JMP file Any suggestion?
Jackie_

Discussions |
Mar 31, 2020 9:42 AM

4283 views | 5 replies
Reliability analysis of Interval censored data

Hi , Is any one have any idea about Reliability analysis of Interval censored data. my data set is in following format Days Failed Censored0~30 12 2231~60 8 4061~90 4 22 Dilip
dilipkumar

Discussions |
Mar 30, 2020 5:52 AM

2264 views | 1 replies
Maximum value of several variable columns to specific rows

Hi all, How to create a formula column to find the maximum of several variable columns to specific rows colList = dt << get column names; colList = remove( colList, 1,2); Show( colList ); New Column( "Column 15", Numeric, Continuous, Format( "Best", 8 ), Formula( Maximum(colList[1]), colList[2],colList[3] ) ), Set Selected );
Botzal

Discussions |
Mar 27, 2020 7:36 PM

5308 views | 8 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

2212 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

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

1661 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