JMP User Community

Latest Discussions

Change column names at once

Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...
bordini

Discussions |
Oct 23, 2022 8:54 AM

2932 views | 3 replies
know number of data-missing row when making a summary table

Hi all JMP experts, I'm making a summary table from a raw data table - taking median by group names defined in column "purpose," e.g. a group is named "BSL."The summary table shows that there are totally 744 rows of group "BSL" that are used for summary-extraction, but is there a way to know within the 744 data rows, how many rows contain/doesn't contain(i.e. missing) numbers?
stevend1219

Discussions |
Oct 22, 2022 5:22 AM

890 views | 1 replies
Is having 6 terms in a linear regression with n = 8 acceptable?

I am currently analyzing a full factorial experiment with 2 levels and 3 factors, unreplicated, n = 8. According to JMP guides, the proper methodology here would be to fit the model using factorial to degree 2, assuming higher order interactions are insignificant, before using backwards selection to reduce the model down to its significant factors. JMP guide for 2x2x2 full factorial analysis: http...
QW

Discussions |
Oct 22, 2022 1:01 AM

3443 views | 6 replies
Script to save prediction formula of PLS

Hello, I'm using a script to run PLS on my data, but I'm having a hard time getting it to save the prediction formula & values into a column in the data sheet. Is this possible? Here's what I'm using so far: Names Default To Here( 1 ); < P = Partial Least Squares( Y( :Viability ), X( :Name( "976" ), :Name( "778" ), :Name( "973" ), ), Validation Method( None, Initial Number of Factors( 15 ) ),...
rummeln

Discussions |
Oct 21, 2022 10:46 PM

1645 views | 3 replies
How do I perform bitwise xor operations between columns with 44-bit binary data?

I want to perform bitwise xor operations between two columns and output the result in the 3rd column. Please note that the values are 44 bits long in both columns.

Please assume as an example the values are 1s on one column and 0s on the other, 44 bits long. Can you explain how I can achieve this with a formula or a jsl script?
psundar6

Discussions |
Oct 21, 2022 9:41 PM

2059 views | 2 replies

Previous
Next

Latest Discussions

Change column names at once

Hello, I have a data table with several continuous columns, each column with a different name. I wish to: 1) duplicate continuous columns all at once; 2) rename these new columns with their original names (i.e., lady beetle) plus add "/100" to their names (i.e., column name would be: lady beetle/100) all at once; then 3) I want to multiply these new columns by 4 all at once (only the continuous co...
bordini

Discussions |
Oct 23, 2022 8:54 AM

2932 views | 3 replies
know number of data-missing row when making a summary table

Hi all JMP experts, I'm making a summary table from a raw data table - taking median by group names defined in column "purpose," e.g. a group is named "BSL."The summary table shows that there are totally 744 rows of group "BSL" that are used for summary-extraction, but is there a way to know within the 744 data rows, how many rows contain/doesn't contain(i.e. missing) numbers?
stevend1219

Discussions |
Oct 22, 2022 5:22 AM

890 views | 1 replies
Is having 6 terms in a linear regression with n = 8 acceptable?

I am currently analyzing a full factorial experiment with 2 levels and 3 factors, unreplicated, n = 8. According to JMP guides, the proper methodology here would be to fit the model using factorial to degree 2, assuming higher order interactions are insignificant, before using backwards selection to reduce the model down to its significant factors. JMP guide for 2x2x2 full factorial analysis: http...
QW

Discussions |
Oct 22, 2022 1:01 AM

3443 views | 6 replies
why is my "select where" causing JMP to hang?

Using JMP16 standard, and I'm working on a largeish data table (90col, 2.4M rows). I'm creating a summary table, using "Update" to get the new summary column back into the main table, and then doing a "select where" on the newly added column, and JMP hangs every time. I thought it was due to my script, but I get the same issue if I do this manually. However, it seems to work fine if I use "Join" a...
klipson

Discussions |
Oct 21, 2022 2:03 PM

1225 views | 3 replies
Deleting column/table variable that is referenced in formula using JSL

Hi,As stated in the topic of this post, I observed that JSL commands "Delete Column" or "Delete Table Variable" don't work when either column has a function or table variable is a part of a function.When performing this action "by hand" there is an extra warning window, that informs user about consequences of such action and allows to choose an action. I understand that this behaviour was introduc...
Ceg1

Discussions |
Oct 21, 2022 8:42 AM

1095 views | 2 replies

Previous
Next

Latest Discussions

How to Analyze and Graph Responses with Supercategories

I use JMP Pro 16. I am doing MCA on 90 columns that have supercategories. I want to do the analysis and viz on the supercategory classification. Is there a way to do this without having to create separate columns that only have the supercategory classification? PS: I don't know how to do JSL scripting.
TCM

Discussions |
Oct 21, 2022 5:59 AM

768 views | 0 replies
標準化列名稱如何用變數取代求解

//新增周標準化
weekEMC_HF_C_12_0 = Data Table( "周_EMC_HF_C_12um" ) << Get Column Names( string );
weekEMC_HF_C_12 = {};
//少一周={:"2022W38"n,:"2022W40"n,:"2022W41"n};
For( j = N Items( weekEMC_HF_C_12_0 ), j >= (N Items( weekEMC_HF_C_12_0 ) - 5), j--,
Insert Into( weekEMC_HF_C_12, weekEMC_HF_C_12_0[j] )
);
Try(
Local( {old dt = Current Data Table()},
Current Data Table( Data Table( "周_EMC_HF_C_12um" ) );
For Each( ...
Ken697

Discussions |
Oct 20, 2022 9:22 PM

684 views | 0 replies
Methods for compressing a CSV or TSV file with jmp compression to save as .jmp table without having to open the csv in JSL first?

I have access to both JMP12 and JMP14, so a solution for either would work. What I am trying to achieve is saving very large text files (csv,tab,tsv,etc.) with JMP compression such that I get a compressed .jmp file as the result. By large I mean 2-6gb files. Currently I use something like this: MyDataFile = open(filename,Private); MyDataFile << Compress File When Saved; MyDataFile << save(filetosa...
CurbStegosaurus

Discussions |
Oct 14, 2022 9:06 AM

1834 views | 0 replies
Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

580 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

623 views | 0 replies