Preparing Data for Analysis with JMP

Chapter 4: Single Files

Introduction

Review of JMP File Types

Common Formats Other than JMP

MS Excel

Text Files

SAS Files

Other Data File Formats

Conclusion

References

Introduction

In this chapter and in the two chapters that follow, we’ll see how to transfer data from various sources into a JMP data table. This chapter focuses on common data file formats that analysts are likely to encounter when assembling data for a project. Chapter 5 covers database queries, and Chapter 6 demonstrates methods for reading data from websites.

In this chapter, we assume that the starting point is a file residing in a local directory, and we consider different methods for transferring the data from one format into a *.jmp data table file. Another implicit assumption ...