Level: Intermediate
Kelci Miclaus, Senior Manager Advanced Analytics R&D, JMP Life Sciences, SAS
Mandy Chambers, JMP Principal Test Engineer, SAS
JMP has many ways to join data tables. Using traditional Join, you can easily join two tables together. JMP Query Builder enhances the ability to join, providing a rich interface allowing additional options, including inner and outer joins; combining more than two tables; and adding new columns, customizations and filtering. In JMP 13, virtual joins for data tables were developed that enable you to use common keys to link multiple tables without using the time/memory necessary to create a joined (denormalized) copy of your data.
Virtually joining tables gives a table access to columns from the linked tables for easy data exploration. In JMP 14 and JMP 15, new capabilities were added to allow linked tables to communicate with row state synchronization. Column options allow you to set up a link reference table to listen and/or dispatch row state changes among virtually joined tables. This feature provides an incredibly powerful data exploration interface that avoids unnecessary table manipulations or data duplications. Additionally, there are now selections to use shorter column names, auto-open your tables and a way to go a step further, using a Link ID and Link Reference on the same column to virtually “pass through” tables.
This presentation will highlight the new features in JMP with examples using Human Resources data followed by a practical application of these features as implemented in JMP Clinical. We will create a review of multiple metrics on patients in a clinical trial that are virtually linked to a subject demographic table and show how a data filter on the Link ID table enables global filtering throughout all the linked clinical metric (adverse events, labs, etc.) tables.