JMP User Community

Latest Discussions

Date: Date Type, Modeling Type and Format -> How to fix MMM/YYYY

Data in format MMM/YYYY (001/2019, 002/2019, ...012/2019) is being imported as Date Type Character, Modeling Type Nominal.
I'm trying to get JMP to recognize this as a date. The final format isn't import per se. I show a format below just as an example.

I've tried scripting two ways to fix with no luck. The column name is "MMM/YYYY" [fail #1] names default to here(1); dt = current data table();...
BSwid

Discussions |
Oct 28, 2018 2:10 PM

5449 views | 2 replies
set title for control chart open in mulitple tab

Hi all , I would like to change the title of each of my individual control chart opened in various tab , i have tried set title ("xxx") but it apprears error , anyone can help ? For( i = 1, i <= n Items(losscode), i++, TB << Add( losscode[i],ob1 = Outline Box( "Pareto Chart", dt << Control Chart Builder( Show Capability( 0 ), Variables( Subgroup( :weight ), Y( :height ) ), Chart( Po...
kuannygoh

Discussions |
Oct 28, 2018 8:16 AM

6115 views | 3 replies
how to adjust Bivariate plot x axis scale with weekly date/time data

Hello everyone: This is my first posting. I am still a neophite with JSL and I've been trying to solve my problem for couple of days. Here is the problem setup... I have a datafile that I need to analyze every Friday. This datafile consists of a date/time log of some values captured real time. So every Friday, this datafile has a new date range. I wrote a script to plot this data in a bivariate pl...
abpc1

Discussions |
Oct 27, 2018 7:13 PM

3098 views | 1 replies
How to split a column cells into different columns

Not sure how I can split a column of cells into different columns. For example I have this ONE column with both First and Last names as one cell

Name
1 Lee, Bob
2 Miller, Mike
3 Smith, Jack

Not split this one column into Two columns, one of First, and second column of Last

Last First
1 Lee Bob
2 Miller Mike
3 Smith Jack

Discussions |
Oct 26, 2018 10:36 AM

16038 views | 12 replies
How to stack time series data when the data repeats with different units (double stack?)

In this case sales are first expressed in units and then dollars. This is a common output format from SAP. Starting file and left. Goal on the right.
BSwid

Discussions |
Oct 26, 2018 7:22 AM

12174 views | 2 replies

Previous
Next

Latest Discussions

how to adjust Bivariate plot x axis scale with weekly date/time data

Hello everyone: This is my first posting. I am still a neophite with JSL and I've been trying to solve my problem for couple of days. Here is the problem setup... I have a datafile that I need to analyze every Friday. This datafile consists of a date/time log of some values captured real time. So every Friday, this datafile has a new date range. I wrote a script to plot this data in a bivariate pl...
abpc1

Discussions |
Oct 27, 2018 7:13 PM

3098 views | 1 replies
Need help getting a MATLAB structure as a JMP data table

I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
thamilton

Discussions |
Oct 25, 2018 6:47 PM

2686 views | 1 replies
How to use max among several column with "get rows where" condition

It seems an easy question but I'm struggling to solve it...I have this kind of data table : It goes until 64 which is the parameter "dim" in my script.I'm looking for the maximum and minimum of all median_range_mm 1, 2 , 3 ... until 64. But I don't want JMP to look at rows where target_status is different of 5 or 9.As you can see, when target status is 10 it overranges at 39996.It is easier to ...
Rob128

Discussions |
Oct 25, 2018 1:47 AM

3979 views | 3 replies
closing all data tables but leave one open for further analysis

Hi All This is a follow up on the post: https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739 However, I have encountered an error on my script while running JSL Debgger. DontClose = ("dt4"); // Example names of tables you want to leave // Loop backwards through the list, so the table numbers do not change For( i = N Table(), i >= 0, i--, If( Contains(...
ivomdb

Discussions |
Oct 24, 2018 5:13 AM

14609 views | 7 replies
Outliers in data

Hi, Is there a way in JMP to label outliers in a dataset. For example, I have 100 lots and I want to label the units that are observered on the lower side of the distrubution. I dont care if the outliers perform better than the distrubution, I am more intersted in the lower ones. In other words for example, I have a lot with 100 units, 1 or 2 units are outliers. How can I label those units? Than...
rshehadah

Discussions |
Oct 23, 2018 4:04 PM

8595 views | 3 replies

Previous
Next

Latest Discussions

how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3681 views | 0 replies
Mean separation letter from test slices

Hello!

How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
jfranc19

Discussions |
Sep 14, 2018 2:35 PM

2514 views | 0 replies
repeated-measures ANCOVA: How to perform the analysis when the parallel slope assumpt. doesn't meet?

Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Reinaldo

Discussions |
Jun 18, 2018 6:31 AM

3511 views | 0 replies
Time Series - Prewhiten

Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
nopon649

Discussions |
Jun 7, 2018 11:10 PM

2509 views | 0 replies
Fit Spline By Group: Save Spline Coefficients to Column?

Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
M0gAl0g

Discussions |
Jun 5, 2018 3:19 PM

3094 views | 0 replies