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 a JMP File
Let’s start by opening a JMP data table. At the top left of the JMP window is the File menu:
1. Select File Open (see Figure 2.1). A dialog box opens. (On a Mac, select File Open and locate your file in the appropriate folder.)
Figure 2.1 Opening a File
We will use the Big Class Families data table described earlier. Click the Big Class Families.jmp file and select Open. (See Figure 2.2.)
Figure 2.2 Open File Dialog Box
| Note |
| To locate this file for the first time, select File Open C: Program Files SAS JMP 15 Samples Data Big Class Families.jmp. Alternatively, you can also select Help Sample Data Open the Sample Data Directory Big Class Families.jmp. |
These steps open the JMP data table Big Class Families. (See Figure 2.3.) With these simple steps, you are now ready to analyze or visualize this data.
Figure 2.3 The JMP Data Table
This spreadsheet-like table is referred to as the JMP data table, which is JMP’s common data format regardless of where the data comes from. Section 2.2 discusses the components of the data table.
| Note |
| In the Big Class Families example, each row of the table contains information about a single student in the class and is, therefore, one observation. Each column of the table is one piece of information (or variable) collected on each student. This structured format of the data table is required for most graphs and analyses in JMP. The importing examples that follow assume that your data already exists in this format. Section 2.4 introduces some tools to use if your data does not conform to this structure. |
Importing Data into JMP
Importing data into JMP from another file format is similar to opening a JMP file. Within the File Open pop-up window, the Files of Type drop-down menu indicates All JMP Files as the default.
If you are importing another file type, simply click on the down arrow and select the correct type. You can also select All Files from the drop-down menu. (See Figure 2.4.) Select the file that you want, and then click Open. On the Mac, select File Open and available files will be highlighted. On the Mac, files that JMP cannot open will be dimmed.
Figure 2.4 Selecting All File Types
| Note |
| If you know the format of your data, first select the correct format from the Files of Type drop-down menu. You will see the available files of that type within the folder. Once you have located the right file, select the file and click Open. |
Importing an Excel File
Importing an Excel file is easy if your variables are in columns and your cases or observations are in rows. Ideally, any variable names should appear in the row directly above the first row of data, as shown in Figure 2.5. The import process automatically opens and converts the data into a JMP data table and uses your variable names as column headings:
Figure 2.5 Importing an Excel File
1. Select File Open.
The Big Class.xls file, which is illustrated here, can be found by selecting C: Program Files SAS JMP 15 Samples Import Data Big Class.xls.
2. From the Files of Type drop-down menu, select Excel Files.
3. Select the file that you want, then select Open to launch the Excel Import Wizard dialog box with a view of your data. If it looks correctly structured, select Import.
| Shortcut |
| If you have an Excel worksheet or workbook on your desktop, you can simply drag the file over the JMP shortcut icon on your desktop to launch JMP and the Excel import wizard. |
The Excel Import Wizard
While the previous example was simple and straightforward, a common characteristic of Excel worksheets is that data does not always conform to the essential column/row structure that is required by JMP. For example, you might have multiple nested headers where one row might represent year and the next row contains months within that year. The Excel Import Wizard has made importing this worksheet and maintaining the month-within-year structure much easier.
This wizard also provides options to specify which rows should be headers for columns, to specify hidden or merged columns, and to replicate these settings or merge data from multiple worksheets within a workbook.
To illustrate this feature, let’s try another example with one of these characteristics. We will use the Team Results.xlsx worksheet from the Import Data folder. This worksheet has headers/column names that appear to be in the second row. (See Figure 2.6.) The Excel Import Wizard will help JMP decide how to import this data.
Figure 2.6 The Excel Import Wizard
1. Select File Open, then select an Excel workbook. In this example, we are using Team Results.xlsx from the C: Program Files SAS JMP 15 Samples Import Data folder.
2. Select Team Results.xls Open to launch the Excel Import Wizard with an initial display of your data in the window (Figure 2.6).
3. As you can see, the column headers begin in row 3 (when you include the note that appears as a header in the preview) and the first set of observations in row 4. To get this into the right format, adjust the Individual Worksheet Settings as we have done in Figure 2.7.
Figure 2.7 Adjusting the Worksheet Settings
4. Once you have adjusted these settings,