JMP User Community

Latest Discussions

locate value and replace them

Hi everybody,I have this type of data table (see attached file). I want to detect all values which are outside of 2 threshold values (-0.5 and 0.5) and replace them by the ceiling values. For example: -5.30, -6.00, -11.56 must be replaced by the same value of -5.00, and 5.30, 6.00, and 11.56 replaced by 5.00. Have you any suggestion to do that in a simple way ? Thanking you in advance
paul_apicella

Discussions |
Feb 23, 2017 1:10 AM

7520 views | 2 replies
Merge data by time stamp

I have a data set with a Column of Date/Time (m/d/yy h:m:s) and two colums of data.I am trying to move/combine/correct the numbers in each data colum to match the Date Time stamp.Here is a sample of two rows that shold have the columns combined: Notice the time stamps are the same, yet I cannot get them to combine correctly on the same row.I have about 5K+ lines of data, but I work with more, and ...
mmcclusk0

Discussions |
Feb 22, 2017 1:42 PM

16092 views | 15 replies
Possible to extract Prediction Formula as a one line formula in script?

Hello, After creating a prediction formula (say from a Neural Network) and a column is created, I can right click on that column and click "formula" and view the created formula. I then am able to "click and drag" the equation into a text file as a one line equation. My question: Is it possible to script this process? I want to save off that formula without having to do the above process every...
showtime287

Discussions |
Feb 22, 2017 11:52 AM

9892 views | 10 replies
Full factorial analysis with multiple variables

I am trying to run a three way Anova analysis on my data. The problem is that when I run a full factorial (with the three-way and the two-way interactions) the table does not contain the data regarding the main effects and the two way anova- only for the three-way anova. in the row of the 3 main effects and the 2 interactions, there is a "dot" where there should be F ratio or P-value, and in the D...
Adi

Discussions |
Feb 22, 2017 9:14 AM

9310 views | 6 replies
How to place List values into the column

As a result of some manipulations I have a list of size of number of rows in my table.I want to create a new column and place these values into this colum.JSL reference says that this should work: dt = New Table( "My Data"); dt << New Column( "Last Name", Character, Values( {"Smith", "Jones", "Anderson"} ) ); IThe list that I want to put into that column is actually list of lists. If I do Eval(na...
miguello

Discussions |
Feb 21, 2017 1:31 PM

14238 views | 5 replies

Previous
Next

Latest Discussions

Using "Get Rows Where"

I need to use Get Rows Where to get the row with value that is just below certain value.In other words:I have a Date AI have a table with dates. I need to get the row where the date is the latest, but less than Date A Example:I have a date when person died.I have table with all event when somebody logged in into his account. There are dates before and after his death.I need to find the latest dat...
miguello

Discussions |
Feb 18, 2017 4:45 AM

7000 views | 3 replies
Make JMP Journal Transportable

JMP supports talks about "Building a JMP Journal Presentation". How can you create a journal that will still work when it is: Transported to another computer, possible switching between Windows and Mac, Viewable from a USB drive, no matter what drive/folder the host mounts the drive in.
kthompsn

Discussions |
Feb 15, 2017 10:45 AM

7339 views | 3 replies
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4389 views | 0 replies
Automate a Gauge R&R with many measurement columns

I would like to know if you can take a "spec limit" file that is used to add limits to a capability study and use it to add limits to the column properties all at once to perform a gauge R&R without inputting them in one by one. I would like to get a precision to tolerance ratio and need the spec limits for all of the columns.
jjhartwi

Discussions |
Feb 14, 2017 11:41 AM

5178 views | 3 replies
Test column data type

Hi, Is there a simple way to test if the data type of a column is numeric and nominal? Thanks and regards, Jérôme
j_bonnouvrier

Discussions |
Feb 14, 2017 3:08 AM

6153 views | 1 replies

Previous
Next

Latest Discussions

Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4389 views | 0 replies
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word

For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE

Discussions |
Dec 14, 2016 8:48 AM

4713 views | 0 replies
Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4868 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3882 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5149 views | 0 replies