JMP User Community

Latest Discussions

Select rows based on first character

Hi I have a column with a lot of numbers and some text. Below is a snipet of what my data looks like. I'm tring to hide and exclude all rows that aren't 7 digits long and don't start with 5 (i.e. I only want numbers like 5******). 5238403
5236577
3238403
ASKU
523660682
asku
2536614
NI
5236610 So far I know how to exclude all the rows that aren't 7 characters long, but I can't figure out how to select the ...
ab0716

Discussions |
Sep 23, 2018 1:55 AM

8683 views | 3 replies
Table Box (Data table col box)

Hi All, I have been working on this idea for the past week or so and @gzmorgan0 helped me with this post https://community.jmp.com/t5/Discussions/creating-an-index-for-columns-to-point-to-the-graph/m-p/71555#M35439 say for example, I loop through 5 continuous columns and 2 nominal columns, I plot one way analysis of 10 columns(say nw2). I get the p-value and other parameters in a table. I want ...
vishwasanj

Discussions |
Sep 22, 2018 11:26 AM

13358 views | 5 replies
Scatterplot 3D tiff resolution

Dear community, I wish to export a 3D scatter plot at a high resolution. Once I do this (600 or 1200 dpi) the data frame is clean, but the actual plotted data and axis are still pixelated. See attached image. Is there a method for exporting 3D plots in high resolution?Thank you,-Lucas
Anonymous

Discussions |
Sep 21, 2018 11:09 AM

8861 views | 2 replies
Help with Nominal Logistic Fit: Confusion Matrix vs ROC Table Output?

Hi JMP Community, I have been studying the Nominal Logistic Fit to determine the value of a Baseline Biomarker to predict the outcome of a Clinical Treatment. I thought that I understood the concept of the Confusion Matrix: it returns the numbers of True Positive, True Negative, False Positive, and False Negative for a given model for the Training data set and, if defined, the Validation set. Howe...
Thierry_S

Discussions |
Sep 21, 2018 10:52 AM

7611 views | 1 replies
Expression vs. Functions

I been struggling to understand the differences. It looks to me, at least on the surface that they accomplish the same thing but seeing how you get to choose there is a difference somewhere. If you fine folks wouldn't mind giving me the dumb downed explination with maye an example or two i would greatly appreciate it. D
Yngeinstn

Discussions |
Sep 21, 2018 8:51 AM

8503 views | 4 replies

Previous
Next

Latest Discussions

JMP and MongoDB

Our database team is moving us from a T-SQL framework to a MongoDB framework. Currently much of our team has extensive JMP scripts and tools for automated queries / processing / analysis that rely on JMP's ability to connect/pull through the OBDC drivers. What does JMP / MongoDB integration look like? Below is a 'sample' of how we interact currently. Is this functionality still avaliable with the...
JumpingAC

Discussions |
Sep 19, 2018 9:33 AM

4909 views | 2 replies
Import JSON Files

I am trying to import JSON files and the data comes in with the wrong formatting. Attached you will see images of the corrrect and incorrect way that the files import. To get the correct import view I have to save the file as a text file and then re-import the text file. What should I do to fix the import issues Wrong Formatting Right Formatting
dkraeuter_sunne

Discussions |
Sep 19, 2018 7:00 AM

4842 views | 2 replies
Analysis by specific rows

Hi Everyone! I have a very large dataset that I am in the midst of analyzing but I have come across some difficulties. In the dataset there are 1924 rows and 1061 columns - so it's quite large. I am trying to do Fit Model and just want to make sure that I am doing this right. If I for example want to fit a model based on rows 112-245, I select these rows, enter "Fit Model" option, select the colu...
Maxpower1123

Discussions |
Sep 18, 2018 12:11 AM

10183 views | 9 replies
API Access to AWS Database

I’m trying to access a database using the new API request feature in JMP ( I’m using 14.1) and I’m having trouble understanding what is required to connect to the database. I’m trying to access amazon cloud ( AWS) at the following location deawdoraisap001.xxxxxxxxxxxx.eu-central-1.rds.amazonaws.comusername is dbarnettpassword is Password_123 ( obviously it isn’t this so it’s just an example) Could...
d_barnett

Discussions |
Sep 17, 2018 11:34 AM

3856 views | 1 replies
How to overlap points with the same/ very close values in a graph?

Hello!A quick question, as the title suggests, how can I overlay points with the same value or close values ( e.g., a difference smaller than 0.1) in a graph?For example, in the following situtation I want to keep only one point for each small range of values, and therefore lose the observed horizontality of points. Thank you very much in advance.
Natalia_Castelo

Discussions |
Sep 17, 2018 10:59 AM

3660 views | 2 replies

Previous
Next

Latest Discussions

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

2457 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

3434 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

2470 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

3024 views | 0 replies
Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1849 views | 0 replies