The Preferences Dialog Window
| Note |
| If you need to make a change within a single graph or result, note that JMP also provides many of these formatting options within the graphs themselves. |
Let’s see how this works. New users on Windows often prefer to turn off the menu auto-hide option (which by design, provides a little more window real estate for graphics and statistics power users), making it a little easier to find the menu options described in this book.
Below we have an illustration of the menu hidden and unhidden (Figure 1.31). Notice the File, Edit, and other menus appear when they are not hidden. When the menus are hidden, you see an ellipsis where the menus would be. Holding your cursor over the ellipsis displays the menus.
Figure 1.31 Illustration of Menu Hidden and Unhidden
To change this auto-hide default to always show the menus, select File Preferences Windows Specific Autohide menus and toolbar Never (Figure 1.32).
Figure 1.32 Removing Menu Auto-Hide
If you want to change the default marker size, style, or color themes used in graphs, select File Preferences Graphs. Included is a handy preview to see how your selections will appear (Figure 1.33).
Figure 1.33 Graph Preferences
1.8 Summary
JMP was developed to help business professionals, scientists, or engineers get answers to the questions and problems that they encounter. The navigation and menus within JMP provide a natural extension of your problem-solving and a direct means to explore your data and generate the results that you need. This book uncovers the structure of JMP’s menus and provides easy steps for producing results. The standardized format of the windows in JMP prompts you through most analysis and graphing. Results can be customized using global detailed preferences.
Chapter 2: Data
2.4 Cleaning and Formatting Data
2.5 Selecting, Highlighting, and Filtering Data: Row States
2.6 Adding Visual Dimension to Your Data
2.7 Shape Files and Background Maps
2.8 The Tables Menu
2.9 Summary
The first step in creating a graph or analysis is to get your data into JMP. With JMP, you can easily import data from many different sources such as Microsoft Excel or ODBC-compliant databases, or you can enter your data directly into a JMP data table. Because most readers already have data in one form or another, this section focuses on getting that data into JMP from another file format. Sometimes data is not in the best condition when you import it. Later in this chapter, we discuss what you can do to format data or deal with missing data. JMP also supports unstructured text and shape files (that can be used to create maps). We will describe the special requirements of using these file types.
As mentioned in the previous chapter, we use Windows as our default operating system to illustrate JMP and its native menus as shown in the below image. JMP instructions for Windows and Macintosh are basically the same, though some operating system differences are noted when they occur.
Example 2.1 Big Class Families
We will be using the Big Class Families.jmp data file to illustrate the steps in this section. This data set consists of 40 middle-school students and their image, name, height, weight, gender, age, and other miscellaneous information. You can access this data set in the Sample Data folder that is installed with JMP: File Open C: Program Files SAS JMP 15 Samples Data Big Class Families.jmp. Alternatively, you can select Help Sample Data Library Big Class Families.jmp.
2.1 Getting Data into JMP
Getting your data into JMP is a familiar process. Like many other desktop applications, you can simply select File Open to import your data into JMP. JMP can handle many different data formats. Table 2.1 shows the default formats JMP recognizes. Other previously installed applications could contain proprietary formats that might also appear as import options. You can import files with these formats as well.
In this section, we show you how to open JMP data tables and how to import Microsoft Excel spreadsheets and text files in JMP. Each of these file formats follows the same basic procedure, but each has special options that enable you to import exactly what you want. JMP interfaces with databases using Open DataBase Connectivity standard (ODBC). Through the Query Builder dialog box, you can easily set up queries of your data and automatically create SQL code that can be saved and repurposed. And you don’t need to learn SQL to do this. We illustrate only the essential connectivity here; more information about querying your data is available in the JMP documentation (Help Search SQL). At the end of this section, we show you how to create a new data table in JMP.
Table 2.1 Default File Formats Supported by JMP
| File Type | File Extension |
| JMP Files | .jmp, .jsl, .jrn, .jrp, .jmpprj, .jmpmenu, .jmpaddin, .jmpapp, .jmpquery |
| Excel Files | .xls, .xlsx, .xlsm |
| Text Files | .txt, .csv, .dat, .tsv |
| SAS Data Sets | .sas7bdat, .sas7bxat, .xpt, .stx |
| SAS Program files | .sas |
| R Code | .r, .R |
| MATLAB Code | .m, .M |
| SPSS Data Files | .sav |
| Minitab Worksheet Files | .mtp |
| Shapefiles | .shp |
| HTML | .htm, .html |
| XML Data files | .xml |
| JSON | .json |
| SQLite 3.0 or Higher | .sqlite, .db, .sqlite3, .db3 |
| Teradata Database | .trd |
| xBase Data Files | .dbf |
| Triple-S Files | .sss, .xml |
| Flow Cytometry v2 or 3 | .fcs |
| Hierarchical Data Format v5 | .h5 |
| Note |
| JMP can be used to initialize or pull data from other third-party applications: Python, ODBC, R, MATLAB, and so on when such integrations are implemented in JMP. The third-party application must match in architecture. The term architecture is sometimes referred to as “bitness” (32-bit or 64-bit). One can verify the architecture of JMP via Help About JMP (Windows). |
Opening
