Preparing Data for Analysis with JMP

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 ...