JMP User Community

Latest Discussions

Labeling rows as greater/less than a date with JSL

I have a dataset with a date column formatted dd/mm/yyyy hh:mm. In my script I want to be able to set a variable equal to some date and then have the script create a new column labelling all rows as being “before” of “after” the specified date.The workaround I’m using is to format the variable and the column in seconds but it’s not easy to read.Is there a way to keep the dd/mm/yyyy formatting whe...
jamiesupica0

Discussions |
Feb 25, 2017 11:49 AM

9452 views | 2 replies
Factor Analysis - Which combination to use?

Hello, In doing Factor Analysis on the Principal Components, which combination to use for the Factoring Method (Principal Components or Maximum Likelihood) and Prior Communality (Principal Components or Common Factor Analysis)? The default option is the Maximum Likelihood and Common Factor Analysis, but I would like to know how to interpret the factors derived from the other combinations. In my da...
anoopchengara

Discussions |
Feb 24, 2017 9:00 AM

11706 views | 4 replies
JSL: Open a VBS script

Hi everyone, Is there a way to start a .vbs (visual basic script) from a jsl-script?It is possible if I make an .exe file from the vbs and run it with Run Program(), but due to tech reasons, I prefer to run the actual .vbs. Run Program (Executable("c:\path\VbsAsExe.exe")); Thanks, Jan
jan_solo

Discussions |
Feb 24, 2017 7:46 AM

9736 views | 1 replies
Prediction Profiler Simulator Problem

Greetings, I'm working with a formula in a prediction profler and using the simulator to do analysis around a selected point. For two parameters, I have found that when I update them the all the other parameters are reset to initial values that come up when I open the profiler. I was doing this via JSL scripting at first so I figured I got something wrong there. But when I manually tried to do it ...
pbrett

Discussions |
Feb 23, 2017 9:51 AM

7268 views | 3 replies
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

7773 views | 2 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

7255 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

7610 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

4525 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

5437 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

6335 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

4525 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

4856 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

4990 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

4065 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

5409 views | 0 replies