JMP User Community

Latest Discussions

Stack columns based on regex selection

I am constantly stacking hundreds of columns which have common prefixes and end with a different number or suffix. What I would like to do is write a script to:Find columns based on a regex pattern, e.g. "BLUE_CARS_*_\d{1,2}", "HOMES_(SINGLE|DOUBLE)_WIDE", etc.Select those columnsStack the columns (and place in a new datasheet)For the life of me, I can't find (or Google search properly for) how to...
tsandidge

Discussions |
Mar 28, 2016 11:40 AM

15560 views | 8 replies
Delaying (lag) a row value by column date

Dear All,I would like to make a simple calculation but I can not.Attached jmp table is a subset of Hotel Occupancy Data Base.Simple logic for Record ID 27421 is;in 14 Apr 2016 250 Rooms arrive and check in,in 14-15-16 Apr 2016 those 250 Rooms stay at the hotel for 3 days long,in 17.04.2015 the 250 Rooms which arrived in 14 Apr 2016 Check Out (Leave the hotel).I need to calculate the RoomLeave Colu...
saitcopuroglu

Discussions |
Mar 25, 2016 9:55 AM

15521 views | 7 replies
select matching cells

by the end of the thing, my expected output should be 3 subset tables.So I want to do this: 1) Go to a specific column, 2) Go to the first row of the column, and select matching cells, and group them to a subset tabledt << Select Matching Cells;3) Then I want to skip the rest of the cell that I have matched, and move on to the next unique cell, and select the matching cells, and group them to a ne...
zhouye0

Discussions |
Mar 25, 2016 3:36 AM

10772 views | 1 replies
Split data into training and validation without JMP Pro

What is the easiest and convenient way to split data into training, test and validation without using JMP Pro?
tajrida

Discussions |
Mar 24, 2016 2:41 PM

17083 views | 3 replies
Save to Database is too slow (10k records per minute)

I have a JMP table with 270,000 records and 72 columns.I am trying to save it to a database via ODBC but the process is painfully slow: it is about 10,000 records per minute (yes, per minute, it's not a typo).I tried to export to both a Microsoft SQL Server 2014 and a PostgreSQL 9.3 server: the speed (or lack thereof...) is the same in both cases. Also, both servers are in the same building as the...
jumper

Discussions |
Mar 24, 2016 10:21 AM

28347 views | 7 replies

Previous
Next

Latest Discussions

Save Residuals to Summary Table Problem

Hi,I have a table with 400k+ rows and in my analysis I have created a summary table.I do a fit Y by X on the summary table and get what I expect. From the pull down I select "Save Residuals" and the new column is not created on the summary data table, but on the original data table. Is this the intended operation? The work around is to separately save the summary data table to break the linkage...
Hegedus

Discussions |
Mar 24, 2016 6:35 AM

5408 views | 4 replies
How to classify groups with categorical data?

Hi, Here is an easy one. I have a group of rodent skulls. They are from several named groups which are also geographic regions. One group is classified as "unknown". I have metric data and used Discriminant Analysis and a plot of the Canonical 1 and 2 scores. And, using the values in the Discriminant Scores table to show predictions. I also have categorical data. Briefly, things like the numb...
ondatra_berkele

Discussions |
Mar 22, 2016 4:51 AM

4105 views | 1 replies
Calculate between and within subgroup variability using jmp (similar to Minitab)?

Hello,How would I go about calculating between and within subgroup variability using jmp (similar to Minitab)? Note: Group sample sizes are different. I am looking to compare various brands of products tested across different vectors. For example, for each brand there is a given quantity of samples tested per vector. and I would like to compare across brands for that vector, specifically between/w...
smithkr10

Discussions |
Mar 21, 2016 1:16 PM

5030 views | 1 replies
JSL to change color of specific cause in Pareto Plot

Hello,I'm trying to change the color of a specific cause in the Pareto Plot using JSL. How can I select a cause by name?For example, I want to implement something like this: cause ({"PASS"}) << Colors (Green);This gives me an error and wants me to use Cause where n is the index of the failure pareto. My issue is that I won't know if my PASS pareto will be #1, #2, etc. Any suggestions? Here is m...
snagpal

Discussions |
Mar 20, 2016 10:13 PM

4755 views | 2 replies
Mixed Models with JMP: Can I see the Covariance Matrix

Dear JMPers! Hope you all enjoy Amsterdam. Too sad I could not come to ask you personally.When working with mixed models in JMP: Is there any chance to see the blocks of the estimated covariance matrix. I'm interested in what I get in SAS when using the G, R and especially V options in PROC MIXED. I like to have a look at that to make sure that I set up the model correctly and that the covariance ...
shoffmeister

Discussions |
Mar 18, 2016 9:12 AM

3714 views | 1 replies

Previous
Next

Latest Discussions

Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3798 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3812 views | 0 replies
Generalized Segmented Distributions

A former classmate of mine from Graduate School has recently published a paper on Generalized Segmented Distributions. Utilizing this method, the distribution can approach any continuous density function of arbitrary form. The method is particularly effective in fitting data with sufficient observations that are skewed and/or multimodal. The paper can be found here:The General Segmented Distrib...
Steven_Moore

Discussions |
Sep 17, 2015 11:54 AM

2524 views | 0 replies
Running JSL Script After Creation of a File

sophiaw

Discussions |
Sep 1, 2015 9:56 AM

2813 views | 0 replies
Clash?

saitcopuroglu

Discussions |
Aug 18, 2015 6:43 AM

2549 views | 0 replies