JMP User Community

Latest Discussions

Script works in scripting editor but not on menu item (Get Column Names not behaving the same)

When I run the following script from the scripting editor, it works fine. But when I run it from a custom menu item I created in View->Customize, it does not work. I've traced it down to the Get Column Names function not behaving the same. When I put a print statement to output the value of each column name and its Type before I use Get Property on it, I see this (for example) when running from...
tatarjj

Discussions |
May 8, 2018 5:49 PM

6450 views | 4 replies
Formula to use previous value if not missing, otherwise use value from last occupied cell

I'm trying to write a formula in Col3 that adds the current value of Col1 with the lagged value of Col2 but I'm running into a pickle trying to figure out how to carry forward the last observation from Col2 when missing data is encountered and to use this value at the first instance of non-missing data. That is, If( !IsMissing( Col1) Col1 + Lag(Col2,1); //create variable that contai...
terapin

Discussions |
May 7, 2018 11:20 AM

23103 views | 15 replies
Prediction Interval for New Observations Not in the Data Set

I’ve built a linear regression model and been asked to create a tool in excel, using the prediction expression, for a team of stakeholders to use. The will apply the tool to new observations not seen in the original dataset. I’d like to include a prediction interval but I’m not sure how to use the JMP outputs to give a prediction interval on data not already seen in the model.
jlrouquette

Discussions |
May 7, 2018 10:09 AM

7053 views | 2 replies
Rename Data Table Script

I know I can rename a data data table script using dt << Rename Table Script("Old","New"); But I want to rename more than one scripts and I am trying to rename all the scripts starting from the third script in the data table with the column names I acquired from a different table. Can anyone point me out to my mistake since I am getting no error in my log. Thank you. a1 = dt << getTableScript...
Aam_jmp

Discussions |
May 7, 2018 7:11 AM

6682 views | 4 replies
Open several JMP files in one session

Hi, When I open JMP file from file explorer (not from JMP itself), it's open separately using new JMP window/session and not from the opened session.Also, when I open several JMP files - each file open in separate session...How can I fix it to open all files in the existing session? Thanks a lot!Assaf
Assaf1

Discussions |
May 6, 2018 12:08 AM

6142 views | 4 replies

Previous
Next

Latest Discussions

How to create APA-format tables and plots from JMP data?

Hi JMP users, I would like to know if there is an easy way to create/export tables and plots from JMP data to APA*-format. Thank you! * APA: American Psychological Association
Reinaldo

Discussions |
May 4, 2018 7:03 AM

4479 views | 2 replies
Issues with local data filter and select where

I am trying to make a Class object that contains methods and properties I find usefull when working with distribution reports. I have everything working how I would like it when I don't try and filter the report or data table but when I try and fitler the report I start having issues. Main issue being is after I filter the report when I go into the display tree to pull and save values they don't r...
awsmagala

Discussions |
May 4, 2018 3:30 AM

4465 views | 3 replies
get current work week in string

Hi I need to pull the date from a constant changing folder name, the name is the year+curent WW e.g. 201817I have the following JSL if ((day of week(today()))==1, WW = "^year(today())^^week of year(today())-1^", WW = "^year(today())^^week of year(today())^" ); Eval Insert Into( WW ); dt = Open("\\.......\Reports\"||WW||"\.......xlsx");it works when I run it on my PC but when I schedule it on a serv...
AdamChoen

Discussions |
May 4, 2018 1:53 AM

2927 views | 2 replies
ODBC connection

How do I create an ODBC connection from LIMS to JMP?
eward3614

Discussions |
May 3, 2018 11:16 AM

6367 views | 2 replies
Wait(0), Wait() vs. Wait(n)

I have a script that does many thing including creating a matrix from a datatable of ~17,500x40. The entire scrpit works fine when I run in in sections but fails to create the matrix when I run it as a whole. The issue appears to be at the step where m = dt << Get As Matrix();. I've inserted wait(0), wait() and even wait(30) but nothing seems to fix the issue. Any suggestions? Sorry I can't t...
DaveLee

Discussions |
May 3, 2018 6:12 AM

10120 views | 9 replies

Previous
Next

Latest Discussions

Why does Profiler not stop

All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.
uday_guntupalli

Discussions |
Apr 27, 2018 7:12 AM

1711 views | 0 replies
P value, L-R Chi Square, Prob Chi Square in Choice results

Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi

Discussions |
Mar 17, 2018 2:22 AM

3814 views | 0 replies
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column

Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard

Discussions |
Mar 15, 2018 1:57 PM

2634 views | 0 replies
pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2260 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3501 views | 0 replies