JMP User Community

Latest Discussions

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
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
save script to data table

I am familiar with the save script to data table command, but can I save a multipart script to one data table script?For example:my JSL script queries a database, then filters data, then creates a control chart. When I save the script to the data table, I can send Save Script to Data Table to the filter, and again for the control chart. This creates two table scripts respectively:What I would l...
jmpbeginner

Discussions |
Jan 19, 2016 8:21 PM

11199 views | 1 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

7640 views | 3 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

7640 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

7437 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

7612 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

2551 views | 0 replies