JMP Knowledge Base

Latest Posts

• Running Patient Profiles in JMP® Clinical 7.1 produces an error when the EX data set does not contain EXTRT

  When the EX data set is missing the EXTRT variable, running Patient Profiles in JMP® Clinical 7.1 produces the following error: ERROR: The following columns were not found in the contributing tables: EXTRT. As a workaround, the user can add a variable named EXTRT with all missing values to the EX data set. This issue is resolved in the JMP® Clinical 7.1.1 hot fix (link below).   JMP® Clinical 7.1...

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 1:08 PM

  501 views | 0 replies

• Metadata table files are overwritten if a mapped drive connection is lost when managing a configuration

  In JMP^® Clinical 7.1, if a mapped drive connection is lost while managing a configuration, metadata files are overwritten. You might encounter the following JMP Alert: date rc=0 in access or evaluation of 'Last Modification Date', Bad Argument (narrDestPath||narrfileName||".VM"), Last Modification Date/*###*/(narrDestPath||narrfileName||".VM") This issue is corrected in the JMP^® Clinical 7.1.2 hot...

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 1:04 PM

  512 views | 0 replies

• Lower-level terms are not represented in the Term Type distribution in the Standardized MedDRA Queries Distribution report

  In the Standardized MedDRA Queries Distribution report in JMP^® Clinical 7.1, if you click the Show Events Leading to SMQs action button, lower-level terms are not represented in the Term Type distribution. This issue is corrected in the JMP^® Clinical 7.1.2 hot fix (link below).   JMP^® Clinical 7.1.2 hot fix   [Previously JMP Note 65969]

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 1:02 PM

  575 views | 0 replies

• How are control limits calculated for the different moving average control charts?

  EWMA Charts: The following notation is used for the formulas:
  
  You can compute the limits in the following ways: as a specified multiple (k) of the standard error of E_i above and below the central line. The default limits are computed with k=3 (these are referred to as 3σ limits).as probability limits defined in terms of α, a specified probability that E_i exceeds the limits.   The following table ...

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 11:55 AM

  1504 views | 0 replies

• Can I test if my data are coming from the "XYZ" distribution?

  Yes. This functionality is available in the Distribution platform. In the output window, select either Continuous Fit or Discrete Fit from the column's pull-down menu. Once the Fitted Distribution table is presented, choose Goodness of Fit from its pull-down menu.   [Previously JMP Note 36012]

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 11:38 AM

  501 views | 0 replies

• Can I test for equal variances in JMP®?

  Yes. Through the Fit Y by X platform, select a continuous Y column and a nominal or ordinal X column. Next, in the output window from the Oneway Analysis pull-down menu, choose Unequal Variances. The following tests are performed: O'Brien[.5], Brown-Forsythe, Levene, and the Bartlett test. If only two groups are present, JMP^® also gives the F-Test 2-sided, otherwise called the Folded F-test.   [Pr...

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 11:36 AM

  5284 views | 0 replies

• Can I get a pdf plot in JMP®?

  Yes. Go to the Analyze menu and choose the Distribution platform. Specify a continuous Y column. Next, from the red triangle menu in the output window, choose Continuous Fit or Discrete Fit and fit the distribution of your choice.   [Previously JMP Note 35336]

  sseligman

  JMP Knowledge Base |

  Dec 23, 2022 11:34 AM

  671 views | 0 replies

• You see the message "Python data type is not supported" when using the Python send() function in JMP® 15.2

  When you use JMP 15.2 and the Python send() function to send data to Python, you encounter the following error that states the Python data type is not supported.   Figure 1   To resolve this error, update to JMP 15.2.1.   [Previously JMP Note 66430]

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 8:51 AM

  293 views | 0 replies

• Using R Send() and R Get() functions with R 4.x in JMP® 15.x generates the error "The final R statement is incomplete"

  Either sending variables by using the R Send() function or getting data by using the R Get() function fails in JMP 15.x with R 4.x. You then see the following error message: The final R statement is incomplete. This message is the result of changes that are made by a Windows Security Update (KB4586786). The error occurs only when you use JMP 15.x with R 4.x versions. However, when you use the abov...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 8:50 AM

  361 views | 0 replies

• Supported Join types for Table > JMP Query Builder

  JMP^® Query Builder can be used to join two JMP tables. However, some may notice the option to "Include non-matching rows from table" is grayed out.                      JMP uses SQLite as its database engine for Table > JMP Query Builder. SQLite supports only the following Join types: Inner-Join: returns rows when there is a match in both tablesLeft-Join: returns all rows from the left table, eve...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 8:45 AM

  804 views | 0 replies

• Step-by-step: Installing JMP® on Microsoft Windows

  The following is a step-by-step guide for sites that wish to provide their users with an instruction set to install JMP^® on their machines. Note: This SAS Note is not intended to address any environmental or system-related issues that might arise during the installation process. If any deviations are encountered during the installation, verify whether you are running a version of JMP supported by ...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 8:42 AM

  25015 views | 0 replies

• Special requirements for the JMP® Python integration on Apple silicon (M1) machines

  The JMP Python integration has special requirements when it is running on Apple silicon (M1) and later processors: Python 3.10 universal2 installers are recommended for Python.org distributions on Apple M1 architecture.Python 3.7 through 3.9 for Python.org distributions require the Python.org universal2 installers to be installed to match the Apple M1 architecture. Note: Using Python 3.9 and earli...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 7:52 AM

  954 views | 0 replies

• Query Builder or Open Table Error: The specified DSN contains an architecture mismatch between the Driver and Application.

  Whether you prefer to use Open Table or Query Builder in JMP®, you may encounter the error: "The specified DSN contains an architecture mismatch between the Driver and Application" (Figure 1.1). Figure 1.1 Figure 1 With Database Management Systems (DBMS) such as Oracle, MS SQL Server, PostgreSQL, etc., you need to configure the ODBC Data Source that corresponds with the architecture of JMP. Meanin...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 7:49 AM

  749 views | 0 replies

• Post-Query Script within Query Builder is ignored when launching a saved .jmpquery file.

  In JMP® 15 when a post-query script is saved within a .jmpquery file, the script is ignored upon opening the file and selecting Run Query. The table being referenced within the query returns data, but the expected output of the post-query script is not generated. Workaround: Open the Query Builder (.jmpquery) file.Select the Red-Triangle > Run on Open.If the script is still listed, copy the Post-Q...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 7:45 AM

  417 views | 0 replies

• JMP® Query Builder: Filters set with Prompt on Run crash JMP 15.

  Selecting "Prompt on Run" for a variable within Query Builder's filter crashes JMP® 15 after selecting "Run Query". Workaround: Go to File > Preferences > Query Builder and turn off "Run queries in the background when possible".   [Previously JMP Note 65168]

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 7:41 AM

  183 views | 0 replies

• JMP® Get Data for x fails using R 4.2.x and later

  R 4.2.x versions are currently not working with various JSL R functions that pull data from R. To address this issue, SAS recommends that you downgrade to an R 4.1.x version to use the R integration with JMP. Note: Reference JMP Note 575310 when considering using the integration on Apple (macOS) silicon arm (M1) architecture.   [Previously JMP Note 69504]

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 2:29 AM

  757 views | 0 replies

• JMP® does not support Anaconda Python distributions on Macintosh

  Macintosh no longer allows modifications to paths to Anaconda libraries that JMP depends on at runtime. As such, JMP no longer supports the Anaconda distribution of Python. JMP recommends the use of the Python.org distribution on Macintosh when using the Python integration.    [Previously JMP Note 67963]

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 2:24 AM

  304 views | 0 replies

• JMP® 15 Google Sheets: sign in disabled for app or app is not secure

  Using the JMP® 15 Google Sheets import results in one of the following messages:  Sign in with Google temporarily disabled for this app.Couldn't sign you in. This browser or app may not be secure.  Due to recent security changes, importing Google Sheets via File > Internet Open > Google Sheets might present these messages. The messages are the result of changes in how Google grants applications ac...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 2:22 AM

  437 views | 0 replies

• JMP® 15 does not recognize tables when opening .mdb or .accdb files.

  Tables produced by opening a .accdb or .mdb file are not recognized when using the drag and drop method or using File > Open. As a result, any subsequent actions, such as choosing Analyze > Fit Y by X or selecting the table from the Current Data Table drop-down will not see the opened table. Workaround: Run the source script within the table, which produces a new table that is recognized. Import t...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 2:19 AM

  392 views | 0 replies

• JMP® 15 and newer will not install on 32-bit operating systems

  If you install JMP 15 or a newer version, you might encounter an error message that is similar to the following: The version of this file is not compatible with the version of Windows you're running. Check your computer's system information to see whether you need an x86 (32-bit) or x64 (64-bit) versions of the program, and then contact the software publisher. This message appears when you are lik...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 2:15 AM

  664 views | 0 replies

• How to re-register the Excel Add-in for JMP® if it is missing

  If the Excel Add-in for JMP® was once visible in Excel but is no longer listed in the menu, follow these steps to correct the problem. This may occur when the file used to load the add-in becomes unregistered. To register or re-enable the Excel Add-in for JMP: Close Excel.Launch the Command Prompt in Windows. See 10 ways to launch the Command Prompt in Windows for your specific Windows version.Rig...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 1:58 AM

  3254 views | 0 replies

• Determining your ODBC driver version when you contact JMP® for database-related questions

  This JMP Note describes the steps you can take to determine your Open Database Connectivity (ODBC) driver version. Take these steps if you are using a Microsoft Windows PC: Open JMP.Navigate to Help ► About JMP.If you are running JMP^® 15 and higher, your system architecture is 64-bit. Otherwise, it lists as 32-bit in this area.Navigate to Control Panel ► System and Security ► Administrative Tools....

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 1:50 AM

  1297 views | 0 replies

• #REF values appear in JMP® data tables when importing from Excel®

  When importing .xlsx, or .xls workbooks into JMP®, #REF values may appear within a variable. This is a known issue that stems from Excel formulas that are nested or conditional. The utility used to import the workbook does not process these formulas, which leads to missing cell references (#REF).  Workarounds:  Save the .xlsx or .xls workbook as a text (.txt) file and import the data into JMP.Use ...

  Dahlia_Watkins

  JMP Knowledge Base |

  Dec 23, 2022 1:40 AM

  397 views | 0 replies

• JMP® Clinical might crash when you attempt to close the Review Builder via an API call

  When you attempt to close the Review Builder via an API call, JMP Clinical might crash. This issue is corrected in the JMP^® Clinical 7.1.2 hot fix (link below).   JMP^® Clinical 7.1.2 hot fix   [Previously JMP Note 65971]

  sseligman

  JMP Knowledge Base |

  Dec 22, 2022 12:13 PM

  608 views | 0 replies

• JMP® Clinical 7.1 displays a zero size on disk for studies containing .xpt files that are changed to .sas7bdat files

  For a study that contains transport (.xpt) files, JMP^® Clinical reports a nonzero size on disk. However, if the .xpt files are replaced with the corresponding .sas7bdat files (and the study metadata is refreshed), a size on disk of zero is reported. This issue is corrected in the JMP^® Clinical 7.1.2 hot fix (link below).   JMP^® Clinical 7.1.2 hot fix   [Previously JMP Note 65972]

  sseligman

  JMP Knowledge Base |

  Dec 22, 2022 12:11 PM

  421 views | 0 replies