Chapter 5: Database Queries

Introduction

Sample Databases in this Chapter

Connecting to a Database

Extracting Data from One Table in a Database

Import an Entire Table

Import a Subset of a Table

Querying a Database from JMP

Query Builder

An Illustrative Scenario: Bicycle Parts

Designing a Query with Query Builder

Query Builder for SAS Server Data

Conclusion

References

Introduction

This chapter continues in the same vein as Chapter 4. It provides approaches and methods to create a single JMP data table using data extracted from another source. In this chapter, the other source is a relational database. Traditionally, a database user would create a query to specify the data of interest for a particular project. Such a query would generate a new ...

Get Preparing Data for Analysis with JMP now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.