JMP User Community

Latest Discussions

Make combined data table with a column containing the test title

I need help with table scripting, I think... Goal: run paired tests on 93 variables and save the combined data table of results to apply a multiple-test correctionWhat's working: the analysis What I'm struggling with: the output of the combined data table. I'm looking for an output where, ideally, the two-tailed P value is included in the table with a descriptor column that relates back to the com...
Shiz

Discussions |
Oct 11, 2023 10:25 AM

2287 views | 5 replies
Adding dates from columns

I have 3 dates that I wanted to add up in order to calculate the total number of days. Is there a way to do this? I just know the Date Difference ( ) function, but doesn't know if there is a function used in calculating the sum of dates from three different columns?
UserID16644

Discussions |
Oct 10, 2023 6:19 PM

1560 views | 4 replies
Change column format

Hi all, I am opening a csv file with dates (0000-00-00) having a default column data type character. However, whenever I tried to update the column with a formula from another column with a date value, I cannot change the format into date. My code looks something like thisdt = Open ("C:\Users\table1.jmp"); dt2 = Open ("C:\Users\table1.jmp"); dt2 << Update( With( dt), Match Columns( :idFin = :idF...
UserID16644

Discussions |
Oct 10, 2023 6:06 PM

1155 views | 1 replies
How to create a two column user input modal window where the second column is populated based on single input on first column?

I would like to create a two column user input modal window where the user input goes into the first column (single input box) for a "parent part ID", based on which adjacent second column window entries (child part IDs) get populated.The entries in the second column come from a database query (for which I already have a script). A "parent part ID" can have one or more than one "child part IDs"Thi...
Neo

Discussions |
Oct 10, 2023 9:10 AM

7713 views | 21 replies
How to screen easily the non significant of many factors(~200 columns) before to perform a mulitple regression.

I have many factor (~200 columns) and one response,i have many measures.Most of this factors show colinearity between them,is there a simple way to perform a first filter of the not relevant factors?Then in the remaining i will perform a multiple regression.
Perpignan_italy

Discussions |
Oct 10, 2023 5:50 AM

1762 views | 3 replies

Previous
Next

Latest Discussions

Make combined data table with a column containing the test title

I need help with table scripting, I think... Goal: run paired tests on 93 variables and save the combined data table of results to apply a multiple-test correctionWhat's working: the analysis What I'm struggling with: the output of the combined data table. I'm looking for an output where, ideally, the two-tailed P value is included in the table with a descriptor column that relates back to the com...
Shiz

Discussions |
Oct 11, 2023 10:25 AM

2287 views | 5 replies
Adding dates from columns

I have 3 dates that I wanted to add up in order to calculate the total number of days. Is there a way to do this? I just know the Date Difference ( ) function, but doesn't know if there is a function used in calculating the sum of dates from three different columns?
UserID16644

Discussions |
Oct 10, 2023 6:19 PM

1560 views | 4 replies
How to screen easily the non significant of many factors(~200 columns) before to perform a mulitple regression.

I have many factor (~200 columns) and one response,i have many measures.Most of this factors show colinearity between them,is there a simple way to perform a first filter of the not relevant factors?Then in the remaining i will perform a multiple regression.
Perpignan_italy

Discussions |
Oct 10, 2023 5:50 AM

1762 views | 3 replies
How can I find Custom Map Creator Add-In

I fail to find where is Custom Map Creator. I do not know how to open it.
WhiskyNing

Discussions |
Oct 10, 2023 12:22 AM

1052 views | 2 replies
How do replace these with JSL with regex substitution?

This is copied in the browser. How to use JSL's regular substitution is processed into syntactic JSL with the following requirements:
1, contains POST......HTTP/1.1 replaced with: u="...";h=[=>];
2, containing:, write h
3. The last line..., replace with: jj="...";rs=New HTTP Request(URL(u),Method("POST"),JSON(jj),Headers(h));Thanks! POST https://app.com/w1/api HTTP/1.1 Host: apparticle.longhuvip.com...
lala

Discussions |
Oct 10, 2023 12:02 AM

3445 views | 11 replies

Previous
Next

Latest Discussions

Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

618 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

1122 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

733 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

847 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies