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
-
Color code Top 5
I would like to color code my table (so that all the charts and graphs I make follow the same). But I want to do it so that top 5 are red, middle 15 are yellow, and bottom 27 are green. There has to be an easy way to do this. For context, I have all the CDC rate data for various diseases that I need to track for 2014-2021. I need to be able to compare the US to any of the states and have it show ...
patriciafm811
3643 views | 10 replies -
Automate importing files
I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name). Any help in the right direction is very appreciated. The snippet of code is below with the importan...
MedianRooster10
820 views | 2 replies -
Open Multiple files in different folders
I have experimental results in 2 different formats as excel files under different folders depending on the conditions of the experiment. Is there a way for the user to state the parent directory and then JMP will open all the excel files as data tables?I also need need to be able to state the row the data starts on depending on which format the file is so that the column names are correct. I have ...
1156 views | 1 replies -
How to open a SAS file in sas7bdat format using JSL?
Thanks!Opening the file directly with JMP shows different results
lala
989 views | 2 replies -
JSL: How to correctly pass variable values from one Expr() to another Expr()
Hi All, I'm having difficulty with variables that evaluate normally in one Expr1() not evaluating properly in another Expr2() that calls the first Expr. I have some code where I've defined an Expr1() that generates distributions of columns of interest. I have another expression later on, Expr2() that calls back to Expr1(). There are variables in Expr1() that appear not to evaluate properly in Ex...
SDF1
1250 views | 3 replies
Latest Discussions
-
Automate importing files
I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name). Any help in the right direction is very appreciated. The snippet of code is below with the importan...
820 views | 2 replies -
How do I change the number of decimals shown for a distribution plot?
Hi,We recently moved from JMP 11 to JMP 13, and now the output of DoE looks different. In particular, more decimal points are shown than before (see screenshot). We want to avoid redoing all previous reports, so is there a way we can set the number of decimals in the distribution?Any feedback is highly appreciated!Sasker
Sasker
4203 views | 4 replies -
How to use JSL to replace characters with special symbols in ""?
[{"ReqId":"200904","PoolId":"2001"}]How to[{\!"ReqId\!":\!"200904\!",\!"PoolId\!":\!"2001\!"}]Thanks!1437 views | 6 replies -
Is it possible to have independent x-axis ordering within x-axis groups in graph builder?
In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...
Neo
501 views | 0 replies -
Are the results of fit two-level screening valid with a Plackett-Burman which may violate effect sparcity?
I wanted to design an experiment to screen 18 factors against one response. I now understand that there are more modern, better designs to solve this problem, but at the time I used a 20-run Plackett-Burman design. I completed each run in duplicate, for 40 runs in total. I am attaching a .csv of the anonymised results, where I have standardised the factor levels (subtracted mean and divided by sta...
noahsprent
2298 views | 5 replies
Latest Discussions
-
Is it possible to have independent x-axis ordering within x-axis groups in graph builder?
In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...
501 views | 0 replies -
Strange behavior using GenReg and Forward Selection
Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
504 views | 0 replies -
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?
Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio
814 views | 0 replies -
What determines which data table is seen as "Associated Data" for New Window?
What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi
556 views | 0 replies -
Using R - File path problem
I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"Prometheus
674 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...
-
2:00PM - 3:00PM EDTApr 25Gleaning Valuable Product Information from Text Data - Mastering JMP
Are you a subject matter expert with information buried in unstructured text, such as survey free-re...
