JMP User Community

Latest Discussions

Renaming columns by position

Dear JMP Community, I would like to rename a column/columns by position. I am creating a subset of a dataset and each time I run the code it counts up some column names. This makes it cumbersome to use this subset in subsequent code because the column names are always different. dt is my big dataset dt << select where( :ScreenCaption == "XYZ" ); //mark the rows in which ScreenCaption == "X...
HenningWeiss

Discussions |
Nov 5, 2020 5:52 AM

1663 views | 1 replies
Copy File Function

I am using JMP 12. I just want copy five csv files with different name from A folder and save it in B folder. The A folder contains many csv files. Using Copy File function (as below), I can only copy one file at a time. I need to write below script five time to copy all five files Copy File( "C:\A\data1.csv", "C:\B\data1.csv" ); Copy File( "C:\A\data2.csv", "C:\B\data2.csv" ); Copy File( "C:...
bzanos

Discussions |
Nov 5, 2020 5:42 AM

3553 views | 3 replies
Editing strings in a list

I am making a listbox that I use in a script to select the batch numbers I want to analyze. I would like to make the list of batch numbers based on file names in a folder. I cannot figure out how to edit the name of the file to be only the batch number. This is what the list of file names looks like "data_20229.csv", "data_20230.csv", "data_20231.csv", "data_20232.csv", "data_20236.csv", "data_202...
ealindahl

Discussions |
Nov 5, 2020 12:40 AM

3659 views | 5 replies
Adding the user-defined error interval option to the graph builder

Is it possible to plot the mean and then add a summary statistics from Points-Summary Statistic as a separate error interval, which you define Yourself? Because calculating mean and SD in different columns in JMP is very easy, but then adding them together and plotting them as a dot and error bars does not function. And this is frankly very annoying because this feature is present in many other st...
dainius

Discussions |
Nov 4, 2020 8:00 AM

15402 views | 13 replies
TWO Y VAR with different visulisation in graph builder

hi all.is there a way to visualised two different var at the y axes but each series in a different wayfor example one var with the "area" plot while the second with the "line" presentation (same X axes)thank you vary much. ( in short to combine the two graphs attached)
hillel

Discussions |
Nov 4, 2020 5:59 AM

3285 views | 2 replies

Previous
Next

Latest Discussions

Editing strings in a list

I am making a listbox that I use in a script to select the batch numbers I want to analyze. I would like to make the list of batch numbers based on file names in a folder. I cannot figure out how to edit the name of the file to be only the batch number. This is what the list of file names looks like "data_20229.csv", "data_20230.csv", "data_20231.csv", "data_20232.csv", "data_20236.csv", "data_202...
ealindahl

Discussions |
Nov 5, 2020 12:40 AM

3659 views | 5 replies
Adding the user-defined error interval option to the graph builder

Is it possible to plot the mean and then add a summary statistics from Points-Summary Statistic as a separate error interval, which you define Yourself? Because calculating mean and SD in different columns in JMP is very easy, but then adding them together and plotting them as a dot and error bars does not function. And this is frankly very annoying because this feature is present in many other st...
dainius

Discussions |
Nov 4, 2020 8:00 AM

15402 views | 13 replies
JMP 15 not compatible with JMP14 JSL

In JMP14, i am using code r = dt << Get Rows Where( name("sex") == "M" ); But it does not work in JMP15. I cannot change code at this point as it is used many places in the code. have seen previously also with newer releases previous JMP JSL is not compatible, face the issue again. dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); r = dt << Get Rows Where( :sex == "M" ); Show( r );
ram_asra_gmail_

Discussions |
Nov 4, 2020 4:51 AM

3098 views | 6 replies
How can I calculate area under the curve in jmp pro?

Hello!In a recent study, I collected blood samples at baseline (fasted) and four timepoints following consumption of one of two types of fiber (each subject received both types of fiber, but on separate days). I analyzed the blood samples to determine the concentrations of various compounds at each time point. I would like to calculate the area under the curve for each compound following both ty...
stellaporkchop

Discussions |
Nov 3, 2020 6:16 AM

5739 views | 7 replies
PLS platform is refitting without validation + how to use the bootstrap?

Hi,1) I'm doing a PLS, I have 42 observations. The number of possible predictors ranges from 24 to 79 to 240 depending on how much I preselect variables. My Y is categorical, either 2 or 3. After running the platform launch, I get to the NIPALS/SIMPLS part, and no matter what type of validation I use (Kfold, leave on,e holdout) or how many factors I choose - I always get the error - "best model ha...
utkcito

Discussions |
Nov 3, 2020 6:06 AM

2206 views | 3 replies

Previous
Next

Latest Discussions

Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1717 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1474 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

938 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1156 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1409 views | 0 replies