JMP User Community

Latest Discussions

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

7947 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

2589 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

4286 views | 5 replies
How to make 28 Run Five-Factor Central Composite Design

Hi all-I'm studying Split Plot Design.
There is a table 12. '28 Run Five-Factor Central Composite Design'
in 'Split-Plot Designs:What, Why, and How' by BRADLEY JONES, CHRISTOPHER J. NACHTSHEIM,as Follows:I would like to make this DOE table with JMP,
please advice me how to make this table by JMP. Thanks a lot.Aki
yuzawaomine

Discussions |
Mar 30, 2020 9:49 PM

6269 views | 4 replies
How to interpret odds-ratios for ordinal logistic regression with multiple levels for dependent variable

I have an ordinal dependent variable practically composed of 5 levels. I am fitting a logistic model with three continuous parameters derived using factor analysis. I am having some trouble understanding the effect summary with respect to the odds-ratio associated with each level.

JMP 14 gives parameters estimates for 4 intercepts and 1 coefficient estimate for each variable. My question is why doe...
adamszymanski

Discussions |
Mar 30, 2020 12:47 PM

14943 views | 7 replies

Previous
Next

Latest Discussions

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

2589 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

4286 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

2266 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

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

13510 views | 12 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

2216 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

2020 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

1668 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

1604 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