JMP User Community

Latest Discussions

How to find the minimum value of selected rows within a column?

Hi all,I am writing a script, and I need to search for the minimum value in a column but only within a few rows. Is there a way to do select these rows using the minimum function?I thought about creating a subset and then using the minimum function, but I was wondering if there was a simpler way.Thanks!
natalie_

Discussions |
Jan 22, 2016 6:27 AM

20313 views | 8 replies
JMP Formula

I have a quick question, does anyone know how you would approach using this Excel formula in the JMP Pro 12 formula platform to generate decile of equal distribution without using the cut point system? How do you get the INT component of the formula below in JMP? Assuming the total rows of your data table is 218086 and you want to have decile of 20,000 plus. This is what I use in Excel, but it be ...
jenkins_macedo

Discussions |
Jan 21, 2016 11:36 AM

15611 views | 5 replies
Updating JMP Data Tables

In September, I posted a question about updating JMP Data Tables, but got no replies. However, I was able to figure it out and feel that others might have the same problem. The Tables<Update works fine if you have changed existing data in your master data table. However, if you add rows of data to the bottom of your master table, the new data will not update. This was driving me crazy until I...
Steven_Moore

Discussions |
Jan 21, 2016 7:04 AM

13158 views | 2 replies
How to use JSL to copy and paste frame settings

Hello,Is there a way to capture the frame settings within JSL to say a list or other variable instead of sending it to the clipboard?thisBiv = Bivariate(.....);report_Biv = thisBiv << Report;????? = report_Biv << Copy Frame Settings;If not, how do I access the results of the clipboard from within JSL so that I can then paste the frame settings to another report?Thanks,Dan
danlund21_gmail

Discussions |
Jan 20, 2016 9:14 AM

13776 views | 5 replies
optimizing an IF statement?

I have a list of specific values I am interested in identifying in my data set (specific values of the :MeasurementGroup column). I created a new column called "Value of Interest?" with a formula to generate an indicator: either YES or NOdt1 << New Column( "Value of Interest?", Character, Nominal, Formula( If( :MeasurementGroup == "A", "YES", :MeasurementGroup == "B", "YES", :MeasurementGro...
jmpbeginner

Discussions |
Jan 20, 2016 8:06 AM

18616 views | 7 replies

Previous
Next

Latest Discussions

Adding a Column and Populating with Data

JMP Users I have a simple question I would like to create a new column and populate it with data based upon information in and existing column. For examples, say I have a column of "Animals" as so:ANIMALCATDOGHUMANHORSESNAKELIZARDCROCODILETURTLETURKEYCHICKENEAGLEDUCKANTBEESPIDERFLYI WOLD LIKE TO WRITE JSL SCRIPT TO ADD A "CATEGORY" COLUMN AND TO POPULATE THE CATEGORY COLUMN WITH DATAT. WITH THE ...
fuscod

Discussions |
Jan 20, 2016 7:07 AM

7277 views | 2 replies
Printing List of Columns (variables?)

Just checking to see if this is available...Is there a way to print out the entire list of columns/variables in a study (with short and long names) for reference? With a very large database, it can sometimes be difficult to navigate through the list and could be handy to have an entire printout if available. Thanks!
Anonymous

Discussions |
Jan 19, 2016 10:57 AM

6911 views | 2 replies
Color Coding Variability Charts through Script

Hello Guys,I have a simple problem with variability chart which I am not able to script properly.I want to do a color coding for my variablility charts as per required conditions. For example, I will I want all the rows with 12-Nov-2015 to come in red color and rest in black color. I want to use similar conditions to color code my data for better representation. I am using this simple code ...dt =...
akash_nigam_gma

Discussions |
Jan 19, 2016 10:33 AM

7639 views | 3 replies
Graph Builder heat map: how to share the same scale for all years?

HiI want to show the spread and growth of the population over time and space. I’m using Graph Builder to map population density (see below). I can produce quite nice heat maps but the density seems to be calculated separately for each year. Is there a way to share the same scale for all years so the colours will have the same meaning across maps?Thanks.C.B.
claude_bellavan

Discussions |
Jan 18, 2016 6:41 AM

7436 views | 7 replies
Finding a relative path in a network

I would like JMP to pick up a "template-table" from the same directory that the script is located. This pathway may vary depending on user due to network setup (for example for me the disk is named K but for other users it might be named L or N). I've managed to use the following "fixed" link:TempTable = "K:\...\TableTemplate.jmp";open (TempTable);(this setup works)the data table is located in the...
anders_bankefor

Discussions |
Jan 12, 2016 11:55 AM

7611 views | 4 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