JMP User Community

Latest Discussions

How do I construct a column A, whose entries are equal to the mean/median/mode of the last 10 non-null entries of another column B?

Hello, I have a column A (around 15,000 rows) which has numbers and many null values (maybe 70-80% null). I would like to construct a column B which at row i, is equal to the the mean of: the *last 10 non-null values from A* --> this means take A[row i-1] , A[row i-2], ... and go back until you have 10 non-null values (or if you reach row 1 then take whatever number <= 10 of non-null values...
jj_jmp

Discussions |
Oct 17, 2022 2:44 PM

3019 views | 8 replies
Create a report window of graphs without spawning multiple graph windows

Hello, I have a datatable with hundreds of thousands of lines. There is a run ID column, a column of device names (29 currently of interest), and a column of associated values. So for each run there are multiple devices recording data, and I want to create run charts for each device with the run ID as the x-axis. However, I have two issues that I can partially resolve individually, but not res...
JDA

Discussions |
Oct 17, 2022 7:14 AM

1491 views | 1 replies
Could anybody recommend an online course or books of mathematics for DoE?

I am reading A Primer on Experiments with Mixtures by John Cornell. However, I was lost after 40 pages. I hope I could understand the principle of math behind it. Could anyone please recommend some online courses or books that will help me understand math for DoE? I am not satisfied with using JMP as a tool without understanding the background principle, and I am not confident with the analysis r...
loganshawn

Discussions |
Oct 17, 2022 12:52 AM

1624 views | 3 replies
How to change the order of sequence stacking in a stacked bar chart？

In stacked bar chart， how to change the order of legend stacking in a stacked bar chart，I want to freely adjust the display position of each legend in the stacked bar chart.
Jony

Discussions |
Oct 16, 2022 7:37 AM

6959 views | 1 replies
Problems with parallel graphs: Continuity and similar scale

Hi mates,Working with parallel graphs, I have got 2 problems and would be appreciated if anyone can help me resolve it. 1- Continuity: Say you have 6 series on your X-axis, but one of your data sets is missing series 4, then the connection between 3 and 5 will be missed. Is there any way to make the graph continues and connects the series just neglecting the missing points? 2- Scale: If the number...
Hamid

Discussions |
Oct 16, 2022 5:51 AM

1868 views | 3 replies

Previous
Next

Latest Discussions

Create a report window of graphs without spawning multiple graph windows

Hello, I have a datatable with hundreds of thousands of lines. There is a run ID column, a column of device names (29 currently of interest), and a column of associated values. So for each run there are multiple devices recording data, and I want to create run charts for each device with the run ID as the x-axis. However, I have two issues that I can partially resolve individually, but not res...
JDA

Discussions |
Oct 17, 2022 7:14 AM

1491 views | 1 replies
Could anybody recommend an online course or books of mathematics for DoE?

I am reading A Primer on Experiments with Mixtures by John Cornell. However, I was lost after 40 pages. I hope I could understand the principle of math behind it. Could anyone please recommend some online courses or books that will help me understand math for DoE? I am not satisfied with using JMP as a tool without understanding the background principle, and I am not confident with the analysis r...
loganshawn

Discussions |
Oct 17, 2022 12:52 AM

1624 views | 3 replies
Problems with parallel graphs: Continuity and similar scale

Hi mates,Working with parallel graphs, I have got 2 problems and would be appreciated if anyone can help me resolve it. 1- Continuity: Say you have 6 series on your X-axis, but one of your data sets is missing series 4, then the connection between 3 and 5 will be missed. Is there any way to make the graph continues and connects the series just neglecting the missing points? 2- Scale: If the number...
Hamid

Discussions |
Oct 16, 2022 5:51 AM

1868 views | 3 replies
Measure exact distance having latitudes and longitudes

Hello, I have some latitudes and longitudes and need to measure the exact distance between each pairs of nodes. By exact distance I mean a measurement close to what google maps shows. Is it possible to this in SAS JMP PRO?I have already tried Distance Tool Add-In but the distance metrics are not what I am looking for. Thanks,Azadeh
sadeghia

Discussions |
Oct 14, 2022 9:48 AM

936 views | 1 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

1824 views | 0 replies

Previous
Next

Latest Discussions

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

1824 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

578 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
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

653 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

719 views | 0 replies