JMP User Community

Latest Discussions

How to Save Prediction Formula for Generalized Regression Using JSL

In partitions or linear regressions either 'Prediction Formula' or 'Save Prediction Formula' creates a new column in the data table. In the generalized regression platform neither work. In the example below, I suspect this is because I actually want to send a message to the 'Adaptive Lasso with AICc Validation' part of the Generalized Regression report instead of the top level 'Generalized Regre...
ih

Discussions |
Mar 3, 2017 5:15 AM

7338 views | 2 replies
Set Row Values as Character Sequence

Hi,What is the best way to set row values for a given column as a character sequence?This is easily done when creating a new column (Data Type == Character) by: Column Info --> Initialize Data --> Sequence Data --> "a", "b", "c", etc.What is the best way to script this?I am using JMP10.Thanks!
robot

Discussions |
Mar 2, 2017 4:29 PM

12579 views | 4 replies
How to remove white space from graph (after using Map)?

I have used graph builder to create a custom map. But there is some white space in the graph, which I would like to remove from graph.I have tried using axis settings, aspect ratio doesn't seem to work. Could you please suggest any other way to reduce the white space around the image. [Last option would be to save and crop image, but would loose interative feature in case I share it as HTML]. Than...
sanqub

Discussions |
Mar 2, 2017 2:24 PM

6116 views | 2 replies
How do I conditionally setting cells in a column to missing values

After hours of Internet searching, there does not appear to be a clear answer on how to accomplsh what I want to do and, after a number coding attempts, this is clearly one of those areas where JSL differs dramatically from other programming languages. I have CSV files that are used as databases in a custom VBA program for a client. The reason for using CSV files was largely due to making it easy ...
mdawson69

Discussions |
Mar 2, 2017 11:26 AM

11912 views | 5 replies
JSL question: select columns and replace missing values with zero

Hi, There are many numeric columns in the data table, and all of them have missing values in them. I want to select only few of them (considering that I know the column names already), and replace the missing values in them with zero.I wrote the code as follows, but it doesn't work. Could you help? Thanks! dt = data table("Untitled 9"); col_list = {"A","B"}; For( i = 1, i <= N Items( col_list ), ...
pomemelom

Discussions |
Mar 1, 2017 1:53 PM

10348 views | 4 replies

Previous
Next

Latest Discussions

Where is the binomial reliability calculation hiding?

I'm doing a binary test (pass/fail) and the number of acceptable failures depends on the sample size and acceptance/confidence limits. It's a binomial reliability calculation. I can find reliability lifetimes but no basic sample size calculator that takes failures into account. MiniTab has it clearly available, and I found very simple online calculators, but I need to document the calculations in ...
Lisa

Discussions |
Feb 28, 2017 4:05 PM

5477 views | 4 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3591 views | 0 replies
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

7329 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

7730 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

4585 views | 0 replies

Previous
Next

Latest Discussions

Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3591 views | 0 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

4585 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

5038 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

4127 views | 0 replies