JMP User Community

Latest Discussions

Copy column prediction formulas to new column

Hi community, This is probably an easy fix, but I'm stumped... I am looking for a scripting answer. I am trying to make a generic workflow in a JSL add-on consisting of the following steps:1: Create new column with non-linear prediction expression and parameters (done)2: Model non-linear data with prediction expression and fit by groups (done)3: Save prediction formula by groups in a new column (d...
CSkjodt

Discussions |
Jul 27, 2017 5:23 AM

6154 views | 2 replies
Scripting to interpolate missing time series weather data?

With hourly interval weather data there are occasional missing data points (missed reads). I’d like to interpolate missing data point(s) – temperature, humidity, barometric pressure typically change gradually during a day. I’d like to interpolate between the last and next time-series value in a column to get the missing value(s) to clean the data. Imputation using the “Explore Missing Values” p...
jthornton1

Discussions |
Jul 26, 2017 1:54 AM

17808 views | 7 replies
Is it Possible to Create a Scatter Plot with Pairs of Points Connected in GraphBuilder?

Hi, I would like to create a large number (~100) of partially connected scatter plots similar to the mock example below:Mock Connected Scatter PlotEach connecting line connects the Baseline (BL) point to the Week 24 (W24) point for a patient. The data would be in the folling formatLet me know if you have any ideas: I certainly don't want to draw each connecting line by hand like I did on the mock ...
sornasst

Discussions |
Jul 25, 2017 5:27 PM

7908 views | 1 replies
How to scale each column?

Hello everyone,I have a simple question, I want to scale each column in a data table. So that each value of the same column is divided by the standard deviation of the column.Of course I can use the formula editor therefore if I have only a few columns, unfortunately I have over 1000 columns. So it would be great to have a function/tool in JMP which allows me to do that with all columns iterative....
marcokunzelmann

Discussions |
Jul 24, 2017 11:23 PM

15927 views | 5 replies
Renaming Columns

Hi everyone, In my code, I open up a csv file, and I rename the column to "Column 1". In the data table, it is renamed, but when I search through all the different columns, it can't find "Column 1". It only recognizes its original name when it is opened. I am searching for values with in a data table, and I need to know what column it is in (which is working if I set i to 2). I know that sett...
natalie_

Discussions |
Jul 24, 2017 9:08 AM

25010 views | 5 replies

Previous
Next

Latest Discussions

Name Unresolved: state in access or eva

Making a GUI using SAS and loading in data from .csv files.I found this code on one of the threads, but when I load my .csv file in it shoots me this error. Below is the code: Cheers,
Tyler Name Unresolved: state in access or evaluation of 'state' , state/*###*/ //Call CreateBivariate to do a bivariate (two variable) analysis\status = List(0,0);New Window("Custom Analysis",H List Box(V List Box(Pan...
tylerram93

Discussions |
Jul 21, 2017 7:50 AM

9642 views | 6 replies
is it possible to keep text left and top position?

Hi ALL,
is there a way to keep text at location provided by x and y. meaning left and top justified?
below is the code. i looked in scripting index, mey be there is something but i could not found.
thanks
ram a="this is a \!nnewline"; Names Default To Here( 1 ); New Window( "Example", Graph Box( Text Color( "red" ); Text( Erased, {50, 20}, a ); ) );
ram

Discussions |
Jul 20, 2017 11:31 AM

8946 views | 7 replies
VIP plot in JMP PLS platform

Hi, I have a question reagarding the Variable Importance in the Projection plot in JMP. In JMP, i only get one VIP plot with default cut-off line at 0.8. However, if we do PLS methods, shouldn't we have n of VIP plots (n is the component number) ? So I wonder why JMP only has one VIP plot? My guess is JMP use the first component in PLS? Hope someone could give some insights about this. I checked ...
tyang13

Discussions |
Jul 19, 2017 11:37 AM

4376 views | 2 replies
Is it possible to perform generalized estimating equations in JMP? If so, how?

Is it possible to perform generalized estimating equations in JMP? If so, how?
ngonzalez0

Discussions |
Jul 19, 2017 8:30 AM

7199 views | 4 replies
JSL: How to get retrieve names of more than one currently selected tables?

Hi folks. I'm dealing with new tables every day (unique table names) which always have at least one common column header, which I use to Match Columns for Join. This is getting repetitive so I've been thinking of writing a script. Problem: I don't want to have to specify both the table names in the script every time I want to Join two tables. I'm looking for a method for the script to auto/semi-au...
jmp13

Discussions |
Jul 17, 2017 3:50 AM

4001 views | 1 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4565 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2276 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4521 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

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

3539 views | 0 replies