Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest 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
6072 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
21461 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
6640 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
6237 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
5728 views | 4 replies
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
4066 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
4032 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())^" );it works when I run it on my PC but when I schedule it on a serv...
Eval Insert Into( WW );
dt = Open("\\.......\Reports\"||WW||"\.......xlsx");AdamChoen
2634 views | 2 replies -
ODBC connection
How do I create an ODBC connection from LIMS to JMP?
eward3614
6043 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
8974 views | 9 replies
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
1585 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
3588 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
2425 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
2049 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
3291 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
1:00PM - 2:30PM EDTApr 16Jump into DOE: Hands-on Workshop
Jump into DOE Wednesday, April 16 | Live Web Workshop1:00 p.m. – 2:30 p.m. ET Hosted via Zoom...
-
12:00PM - 1:00PM EDTApr 17JMP for Teaching Statistics in Semiconductor Engineering Education
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-for-teaching-stat-semicon...
-
1:00PM - 2:00PM EDTApr 25Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
3:00PM - 4:00PM CESTApr 30Scripters Club: Is Your SPC Doing Well?
Is Your SPC Doing Well? Presenter: Georg Raming (Siltronic) Would you like to keep an eye on many SP...
