JMP User Community

Latest Discussions

Divide column by value from another table

Hello,I need your help to devide columns by a variable from another tabledt is a big table with a lot of columnsdt2 has 2 columns "Names" (contains column names from dt) and "DivideValue" ( could be 10, 100, 10000,...) I want to divide dt columns by the dt2 Dividevalue IF dt column nane = dt2 Names.I could create a new column with formula, then remove property and delete "old column", but I gu...
geoff1

Discussions |
Mar 23, 2020 1:51 AM

3135 views | 2 replies
How to append legacy data table with new data from database script

Hi all, I have a static JMP data table that contains old, historical information (legacy data). I have another JMP data table that contains new data. This table is fed from a database through a JMP database query. That also means JMP automatically provides me with a nice script that allows to update the table from the database each time I run it. Now I want to have the old table appended with the ...
guyvanhove

Discussions |
Mar 23, 2020 12:01 AM

9893 views | 12 replies
how to change one column to percentage format

Like change the weight column to persentage: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); how to covert the "weight" column as "95/100*100"=95%. 95% as the final result? height weightKATIE small F 59 95
LOUISE small F 61 123
Theresa

Discussions |
Mar 22, 2020 7:47 PM

6500 views | 1 replies
Save Presentation (pptx): is it possible to modify dynamically (JSL) the slide title?

Hi JMP Community, When you save a Journal as a PowerPoint presentation (pptx), the export algorithm uses the name of each OutlineBox to populate the title (as editable text) on each slide. Is it possible to reproduce this step in a JSL script where the slide title would be generated dynamically (change the default OutlineBox name)? For example, I have generated a large number of GB plots (script g...
Thierry_S

Discussions |
Mar 22, 2020 2:22 PM

3390 views | 1 replies
RE: how do i Fit a constrained longitudinal data analysis (cLDA) in JMP

Hi thereHow do i fit a cLDA in JMP (via FIT command say) with the constraint that the group means are assumed to be equal at baseline (hence the “constrained” in cLDA). Hence if we had a model with Time and their interaction Group:Time as predictors theoretically this model structure would impose that the group means are equal at baseline (i think?). In cLDA baseline means are constrained to be e...
vincem

Discussions |
Mar 22, 2020 11:05 AM

2896 views | 2 replies

Previous
Next

Latest Discussions

how to change one column to percentage format

Like change the weight column to persentage: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); how to covert the "weight" column as "95/100*100"=95%. 95% as the final result? height weightKATIE small F 59 95
LOUISE small F 61 123
Theresa

Discussions |
Mar 22, 2020 7:47 PM

6500 views | 1 replies
RE: how do i Fit a constrained longitudinal data analysis (cLDA) in JMP

Hi thereHow do i fit a cLDA in JMP (via FIT command say) with the constraint that the group means are assumed to be equal at baseline (hence the “constrained” in cLDA). Hence if we had a model with Time and their interaction Group:Time as predictors theoretically this model structure would impose that the group means are equal at baseline (i think?). In cLDA baseline means are constrained to be e...
vincem

Discussions |
Mar 22, 2020 11:05 AM

2896 views | 2 replies
how to carry out multivariate analysis of variance

I have several hundred Ss who fall into 1 of 6 groups based on residence (city, suburb, rural) and disability (yes, no). All Ss took a personality test of about 50 items, which are scored to yield 6 traits. Items are intermixed on the test to avoid order effects, but the traits may be intercorrelated. I want to analyze the 6 traits as dependent variables in a 3 (residence location) x 2 (disability...
OldGugga

Discussions |
Mar 20, 2020 6:49 PM

4108 views | 2 replies
Logistic Plot interpretation of points

I am trying to understand the points in the logistic plot. When I use Fit Y by X, with Y nominal and X continuous, I get a logistic curve. The curve is perfectly understandable, but the points make no sense to me. JMP help says: "The logistic probability plot gives a complete picture of what the logistic model is fitting. At each x value, the probability scale in the y direction is divided up (...
dale_lehman

Discussions |
Mar 20, 2020 1:01 PM

16353 views | 8 replies
Partial Least Squares

Hello all, I am trying to perform a multivariate partial least squares on my dataset in JMP. This dataset consists of 10 rows and 59740 columns (FT-IR data, which has many thousands of "discrete" measurements to create a continuous curve). I get the following error when I try to run the PLS, setting 59738 columns to the X factors and two columns to the Y response. This dataset is structured in the...
bi0

Discussions |
Mar 20, 2020 9:14 AM

5846 views | 7 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

2222 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

2034 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

1673 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

1608 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

1689 views | 0 replies