JMP User Community

Latest Discussions

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

9848 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

7374 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

7882 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

17673 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

10780 views | 10 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

7327 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

7721 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

4582 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

5547 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

6418 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

4582 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

4912 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

5037 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

4125 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

5525 views | 0 replies