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, you should see your data take its proper shape in the Data Preview panel. Once you are satisfied with the adjustments you have made, select Import.
Importing a Text File
If you are importing a text file, another handy wizard is included in the Data with Preview file option. Like the Excel Import Wizard, this wizard enables you to view your data and specify how you want it to appear before importing it into a JMP data table. It also provides options to convert your text file if it is delimited by commas, tabs, or spaces:
1. Select File Open.
The Big Class_L.txt file, illustrated here, can be found by selecting C: Program Files SAS JMP 15 Samples Import Data Big Class_L.txt.
2. Select Text Files (*.txt, *.csv, *.dat, *.tsv) in the Files of Type drop-down menu. Select the file.
3.
