JMP User Community

Latest Discussions

Concat multiple list items together

Using JMP12.2 - I'm looking for a fast way to concat list items together from two different lists in a 1 to 1 fashion - assuming the lists have the same number of items. This will be used For Each Row in very large tables - so I prefer no iterative function if possible. Here is an example of what I want to achieve: list1 = {"a","b","c","d","e","f","g"};list2 = {"1","2","3","4","5","6","7"}; Accept...
ts2

Discussions |
Oct 6, 2021 1:30 AM

4657 views | 6 replies
Are two regression lines equivalent? ANCOVA versus Fit Line.

I have a data set in which 2 response variables were collected (JO2 and dPsi) under 5 different energy states (dGATP) for subjects on two different diets (PM or SR; grouping variable). I used the Fit Model platform to plot the individual subject data and compare whether a linear or quadratic model would be optimal. The AIC was lower for the linear model for both individual and grouped data and m...
TimboK

Discussions |
Oct 5, 2021 3:05 PM

4400 views | 3 replies
Set a web proxy for New Http Request

I am trying to access a web API using the New Http Request and route the calls via a web proxy. JMP support tells me that proxy settings are set at the OS level or the Environment Variable leves. But my company does not allow changes to the OS or to the environment variables on our issued laptops. Is anyone aware of a workaround that can force New Http Request to route through a proxy serve tha...
tgardner4

Discussions |
Oct 5, 2021 9:18 AM

10287 views | 12 replies
how to compare rows with 0 and 1 to find out the prevalence and clustering of two medical conditions?

Hello, I am a new and unexperienced user of JMP working on my PhD thesis. I simply cannot find out how to compare a part of my data and I need assistance. My data consists of 146 columns with either 1 or 0 (yes/no) for 146 medical conditions respectively. I have about 14000 rows (patients) to compare this data from. I need to find out the order for the most common combinations for two medical cond...
EmmaLT

Discussions |
Oct 5, 2021 4:31 AM

1846 views | 4 replies
Is there an alternative to iterating through rows using column formula?

I have a dataset which is a series of test runs, all collected in one table. The experiment is 6 sweeps from high to low speed for each sample, and what I need to do is assign the correct sweep number to each one (i.e. from 1 to 6) and then restart the sequence for the next sample. I could easily do this with the sequence or count function, however the number of points in each sweep is not always ...
david_gillespie

Discussions |
Oct 5, 2021 1:07 AM

1246 views | 2 replies

Previous
Next

Latest Discussions

how to compare rows with 0 and 1 to find out the prevalence and clustering of two medical conditions?

Hello, I am a new and unexperienced user of JMP working on my PhD thesis. I simply cannot find out how to compare a part of my data and I need assistance. My data consists of 146 columns with either 1 or 0 (yes/no) for 146 medical conditions respectively. I have about 14000 rows (patients) to compare this data from. I need to find out the order for the most common combinations for two medical cond...
EmmaLT

Discussions |
Oct 5, 2021 4:31 AM

1846 views | 4 replies
//GraphBuilderGroupBox << Get Window Title issue

Hi, do you know how to get the GraphBuilderGroupBox "name" from the JSL scripting level? In attached picture it would be "Male" or "Female" (marked in red circles). My guess is to have a similar command to << xpath( "//GraphBuilderGroupBox" )) << Get Window Title. However it doesn't work. Here is the code: dt = Open( "$SAMPLE_DATA/Academic Achievement.jmp" ); win = dt << Graph Builder(...
LiPav

Discussions |
Oct 5, 2021 12:54 AM

1452 views | 1 replies
Summary table ignoring weight column in specific conditions (bug?)

For some reason, when adding to summary a Median(), it ignores the weights provided for other statistics. Here, I am creating a simple filter where every male row has 0 weight, hence max and min for males should not exist. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // New column: Filter dt << New Column( "Filter", Numeric, "Continuous", Format( "Best", 12 ), Formu...
FN

Discussions |
Oct 4, 2021 11:20 PM

1115 views | 2 replies
Conducting a one-way ANOVA to compare three means?

I have three different data sets (median home values) for the years 2018,2012,2010. I randomly selected a subset of 50 values from each set. How do I compare the mean of these data subsets to each other using a one-way ANOVA? I start off by using the fit y by x tool, but I'm not sure what to put as the y and x to compare the means.
rubio66

Discussions |
Oct 4, 2021 12:59 PM

1345 views | 2 replies
Structural Equation Model Standardized Path Coefficients Greater than 1

Hi! I just built a structural equation model including two latent variables. Each latent variable has three indicators. However, after running the model, there are three standardized path coefficients greater than 1 (water quality > St[Mac... MMI]; latent 1 > St[Mac... MMI]; St[Base...Index] > St[Mac... MMI]). Normally the standardized path coefficients should be less than 1. I did some search and...
lujc07

Discussions |
Oct 2, 2021 7:07 AM

7744 views | 4 replies

Previous
Next

Latest Discussions

Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

941 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

943 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

655 views | 0 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1212 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

610 views | 0 replies