Contents
Enter Data
This section describes how to add rows and columns, fill columns with sequential data, and enter cell formulas.
Add Rows
To add any number of rows to the table:
1. Select Rows > Add Rows.
2. Enter the number of rows to add.
3. Specify where to add the new rows (at the start or end of the data table, or after a specific row).
4. Click OK.
To add a single row to the end of the table:
• Below the last row, click anywhere in a cell and begin typing.
• Below the last row, double-click in the empty row number area.
Add Columns
To add new, empty columns:
• Double-click the empty space to the right of the last data table column.
• Select Cols > New Column. You can then specify more details about the column. You can also add subsequent columns by clicking Next. See The Column Info Window in Set Column Properties.
• Select Cols > Add Multiple Cols. See Adding Multiple Columns.
Note: When you initially create a column, you can choose to fill it with initial data values. See Fill in Initial Data Values in Set Column Properties. However, after you modify the cells, this option no longer appears.
Adding Multiple Columns
Using the Add Multiple Columns command to define multiple columns is different from using the New Column command. All of the columns that you add using the Add Multiple Columns window have the same data type. Right-clicking anywhere to the right of the last column in a data table to add multiple columns defaults to After Last Column.
To add multiple columns:
1. (Optional) Change the Column prefix.
By default, the new column names are Column 1, Column 2, and so on.
2. Enter the number of columns to add.
3. (Optional) Specify if the columns should be grouped. See Group Columns.
4. Select the data type (Numeric, Character, or Row State) for all of the columns. See About Data Types and Modeling Types in Set Column Properties.
5. Specify where you want to put the new columns.
6. (Optional) Select initial data values for all of the columns. See Fill in Initial Data Values in Set Column Properties.
7. Click OK.
Figure 4.2 The Add Multiple Columns Window
Tip: To change the data type after the columns are created, click on the modeling type icon in the Columns panel and select a different type.
Fill Columns with Sequential Data
To fill columns with a repeating sequence of data or with a continuation of values:
1. Create a sequence of data in a column. See Figure 4.3.
Figure 4.3 Example of a Sequence of Data
2. Highlight the cells containing the sequenced data. The cells can be in different columns.
3. Right-click the selected cells and select an option under Fill.
Fill Options
Repeat sequence to end of table
cells below the selection are filled with repeats of the selected cells.
Continue sequence to end of table
cells below the selection are filled with a continuation of the pattern found in the selected cells. For example, if the selected cells contain the numbers 1 and 2, then the remaining cells are filled with 3, 4, 5, 6, and so on. If the selected cells contain the numbers 2 and 4, then the remaining cells are filled with 6, 8, 10, 12, and so on.
Repeat sequence to
JMP repeats the pattern found in the selected cells to the row number that you specify.
Continue sequence to
JMP continues the pattern found in the selected cells to the row number that you specify.
Enter Cell Formulas
In numeric columns, you can enter cell expressions preceded by an equal sign (=). JMP evaluates the expression and stores the new number as the cell’s value. Unlike column formulas, a cell expression is not stored. Cell expressions can contain operators, constants, and global and column variables.
To enter an expression:
1. Click the cell where you want to enter the expression.
2. Type an equal sign (=), and then type the expression. See Table 4.1.
3. Press the ENTER key.
|
Example expression
|
Cell value
|
|
=sqrt(2)
|
1.41
|
|
=456+890
|
1346
|
|
=height+weight
|
Sums the values of cells in columns height and weight located in the same row as the cell that you entered the expression.
|
|
=height[1]
|
Displays the value found in row 1 of the height column
|
Select Rows
To select one entire row:
• Click in the empty space that contains the row number.
To select a specific row number:
• Select Rows > Row Selection > Go to Row and type in the desired row number.
To select multiple rows:
• For continuous selection:
– Click and drag the cursor over the row numbers.
– Hold down the SHIFT key and click the first and last rows of the desired range.
– Hold down the SHIFT key and press the up or down arrow key.
• For discontiguous selection:
– Hold down the CTRL key and click on each row.
To select or deselect all rows:
• To select all rows, select Rows > Row Selection > Select All Rows.
• To deselect all rows, select Rows > Clear Row States.
or
• Hold down the SHIFT key and click the lower triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all rows. See Figure 4.4.
• To clear all highlighted areas in the data table, press the ESC key.
Figure 4.4 Lower Triangular Area
To select random rows:
1. Select Rows > Row Selection > Select Randomly.
2. You can randomly select either a specific number of rows, or a proportion of the total number of rows:
– Enter a whole number to select that number of rows.
– Enter a value between 0 and 1 to select that proportion of rows.
For example, enter 10 to select 10 rows. Enter 0.1 to select 10% of the rows.
To invert the row selection:
• Select Rows > Row Selection > Invert Row Selection.
To select the Pareto Frontier:
1. Select Rows > Row Selection > Select Dominant.
2. Choose the columns.
3. Select high or low values for each column.
Note: For more information about the Pareto Frontier, see Quality and Reliability Methods.
To save the current row selection in a new column:
1. Select Rows > Row Selection > Name Selection in Column.
2. Type a column name.
3. Label the selected and deselected rows.
4. Click OK.
To select excluded, hidden, or labeled rows:
1. Select Rows > Row Selection.
2. Select from the following options:
– Select Excluded
– Select Hidden
– Select Labeled
Note: For details about excluded, hidden, or labeled rows, see Assign Characteristics to Rows and Columns.
Locate Next and Previously Selected Rows
You can locate the next selected row after the current row and cause it to flash by selecting Rows > Next Selected. Similarly, you can locate the previously selected row before the current row and cause it to flash by selecting Rows > Previous Selected.
Each time you select Rows > Next Selected or Rows > Previous Selected, the next or previously selected row is found and flashes. A beep signals when the last selected row is located.
You might want to use this feature when you have selected rows intermittently in a large data set and want to look through the selected rows in the data table.
Example of Locating Next and Previously Selected Rows
1. Open the Diamonds Data.jmp sample data table.
2. Select Analyze > Fit Y by X.
3. Select Carat Weight and click Y, Response.
4. Select Price and click X, Factor.
5. Click OK.
6. Select Tools > Lasso.
If you cannot see the menu bar, hover over the blue bar below the title bar to reveal it.
7. Lasso some of the points near the 10,000 dollar price at the bottom of the plot. See Figure 4.5.
8. In the data table, select Rows > Next Selected (or you can press the F7 key).
You can easily navigate through the selected rows to see the data for each.
Figure 4.5 Points Selected
Select Columns
To select one entire column:
• In the data grid, click in the empty space around the column name.
or
• In the Columns panel, click the column name.
To select a specific column number:
1. Select Cols > Go to.
2. Enter the column number or name and click OK.
To select multiple columns:
• For continuous selection:
– Click and drag the cursor over the column name.
– Hold down the SHIFT key and click the first and last columns of the desired range.
– Hold down the SHIFT key and press the left or right arrow key.
• For discontiguous selection:
– Hold down the CTRL key and click on each column.
To select or deselect all columns:
• Hold down the SHIFT key and click the upper triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all columns. See Figure 4.6.
Figure 4.6 Upper Triangular Area
Tip: To clear all highlighted areas in the data table, press the ESC key.
Select Cells
To select a block of cells:
• Drag the arrow cursor diagonally across the cells.
JMP can find all cells whose values are the same as the ones you currently have highlighted. You can do this within one data table or throughout all open data tables. Highlight the cells that contain the values that you want to locate.
To find all matching cells within the active data table:
• Select Rows > Row Selection > Select Matching Cells
or
• Right-click one of the highlighted row numbers and select Select Matching Cells.
To find all matching cells across all open data tables:
• Select Rows > Row Selection > Select All Matching Cells. The rows that contain the same values as the selected ones are highlighted.
To select cells that contain specific values:
JMP can search for a specific value (or text string) and highlight all of the cells in the data table that contain the specific value.
1. Select Rows > Row Selection > Select Where.
Figure 4.7 Specify Criteria for Selecting Rows
2. From the column list, highlight the name of the column whose rows you want to select.
3. Use the drop-down menu to select a condition from the list (equals, does not equal, and so on). See Figure 4.7.
4. Type the search value. To search for missing values, leave the box empty.
5. Click OK.
You can also specify the following optional features:
• To compare the values of two columns, click the Compare column check box. Select from the list of columns for comparison.
• To make the search case-sensitive, click the box beside Match Case.
If you currently have rows selected in the data table, you can specify the following optional features:
• Click an option under Action on currently selected rows to tell JMP how to handle that current selection:
– Clear Current Selection removes the highlight from currently selected rows and selects all rows that contain the specified value.
– Extend Current Selection keeps the currently selected rows selected and also selects the rows in which the specified value has been found.
– Select From Current Selection selects the rows in the currently selected array that contain the specified values.
• Click Add Condition to add a condition to the list.
• To add more conditions to the search, repeat the previous steps. Click the appropriate item in the Select Rows area to specify if you would like JMP to select rows conditionally: if all conditions are met, or if any of the conditions are met.
• To keep the window open after you click OK, select Keep dialog open.
Edit Data
This section describes how to edit data in a table, including editing cells and making changes to rows and columns.
Delete Rows and Columns
To delete rows:
1. Highlight the rows that you want to delete.
2. Press the Delete key, or right-click on the row numbers and select Delete Rows.
Caution: When you try to delete thousands of rows, an alert might appear if your computer has insufficient memory. Click No to cancel the deletion, and then try to delete fewer rows.
To delete columns:
1. Highlight the columns to delete.
2. Press the Delete key, or right-click and select Delete Columns.
Edit or Delete Cells
To edit or delete the contents of a cell:
1. Click the cell containing the value that you want to edit or delete.
2. Press the Delete key.
3. To edit the value, click the cell a second time, and then edit the cell’s value.
Edit Column Names
To edit a column name, select the column and begin typing. You can also edit the column name in the Column Info window.
Recode Data
If you have data that is coded incorrectly (for example, contains typographical errors or incorrect wording), you can recode it so that it follows a consistent format. You can also use the recode feature to replace missing or empty values.
To recode data:
1. Select the columns containing the data that you would like to recode.
2. Select Cols > Recode.
Figure 4.8 Example of the Recode Window
3. Type the new value in the text box corresponding to the old value that you want to change.
4. Specify how you would like the text to be recoded. See Recode Options.
5. Click OK.
Recode Options
In Place
applies any change to the original data column.
New Column
creates a new column for the changed data and retains the original column.
Formula Column
creates a new column with the changes as a formula instead of values.
Script
creates a new script called Recode in the data table. You can run this script to perform recoding in-place. If you add more recodes later, the script updates (assuming that you select Script as the destination). You can run this script later, to new data, and copy it to other data tables, or run it from your own scripts.
Red Triangle Options for Recode
The red triangle menu contains options for the Recode window. The first three commands apply to all items in the data table list.
Convert to Titlecase
converts to title case, that is, an initial uppercase character and subsequent lowercase characters for each word.
Convert to Uppercase
converts all items to uppercase.
Convert to Lowercase
converts items to lowercase.
Tab characters, space characters, and line separators are often imported into a data table. Remove these characters using the following commands:
Trim Whitespace
removes leading and trailing whitespace characters. For example, if an extra space was imported before and after the name John, this command would delete the spaces.
Collapse Whitespace
trims leading and trailing whitespace characters and removes duplicate interior white space. That is, if more than one whitespace character is present, the Collapse Whitespace command replaces the two spaces with one space.
View Patterns of Missing Data
If your data table contains missing data, you might want to determine whether there is a pattern to the missing data. The pattern might help you make discoveries about your data.
To view patterns of missing data:
1. With your data table open, select Tables > Missing Data Pattern.
2. Select the columns for which you would like to find patterns of missing data.
3. Click Add Columns.
4. Click OK.
Example of Viewing Patterns of Missing Data
1. Open the Missing Data Pattern.jmp sample data table.
2. Select Tables > Missing Data Pattern.
Figure 4.9 The Missing Data Pattern Window
3. Highlight all of the columns.
Note: For details about the options in the red triangle menu, see the Basic Analysis and Graphing book.
4. Click Add Columns.
5. Click OK.
Figure 4.10 A Missing Data Pattern Table
Figure 4.10 shows the following patterns:
• Row 1 shows that there are two instances where all rows in Trial 1, Trial 2, Trial 3, and Trial 4 have no missing values.
• Row 2 shows that there are two rows in the source table whose one missing value is in the Trial 4 column.
• Row 3 shows that there are two rows in the source table whose missing values are in the Trial 3 and Trial 4 columns.
• Row 4 shows that there is one row in the source table whose three missing values are in the Trial 2, Trial 3, and Trial 4 columns.
In the Missing Data Pattern table, JMP automatically assigns the Count column the analysis role of frequency. If you now use the Missing Data Pattern data table to run an analysis, JMP automatically uses Count as a frequency. So you do not have to specify Count as the role each time. For details, see Assign Column Properties in Set Column Properties.
Find and Replace Cell Values
You can find and replace cell values by selecting the Edit > Search options.
Figure 4.11 The Find Window
The following rules apply to searching for values:
• To find values in hidden columns, unhide the column.
• Values found in locked columns cannot be modified.
• The Undo command works only with Replace. You cannot undo Replace All.
• If your data table contains value labels, using the Search commands searches for actual values, but does not search for labels. See Value Labels in Set Column Properties.
• If your data table contains formatted values (such as dates, times, or durations) using the Search command searches for the formatted values, not the actual values.
Find Window Options
Refine your search with the following options:
Match Case
Performs a case sensitive search, which can be useful for locating proper nouns or other capitalized words.
Match entire cell value
Detects empty spaces, which lets you search for a series of words in a character column, or locate strings with unwanted leading or trailing empty spaces.
Tip: To find missing character values, leave the Find what box empty and check Match entire cell value. To find missing numeric values, insert a period into the Find box and check Match entire cell value.
Use regular expressions
Assumes the find string to be a regular expression instead of the literal string that you enter in the Find what box. The regular expressions follow standard semantics.
Restrict to selected rows
Restricts the search to selected rows.
Restrict to selected columns
Restricts the search to selected columns.
Search data
Searches only data cells (omitting column names).
Search column names
Searches only column names (omitting data cells).
By column
Searches the table column by column, from top to bottom, until it reaches the last cell in the rightmost column, or until you stop the search.
By row
Searches the data table row by row from left to right, to the rightmost cell in the last row or until you stop the search.
Multiple lines
Increases the Find and Replace boxes to 3 lines long instead of 1. The Enter key inserts a return into the field.
Tip: You can alternatively click and drag on the Find and Replace boxes to make them larger. If you copy and paste, the boxes resize to 1 line long, but all of your text is still there.
Keep dialog open
Keeps the Find window open during your search.
Search Actions
This section describes some common searches that you might perform.
Begin by searching for a value in the data table. The search begins with the first cell in the first column and searches every cell until it locates the value or reaches the end of the table.
To replace the currently highlighted cell value:
Enter a value in the Replace with box and click Replace. Or, if the Search window is closed, select Edit > Search > Replace. If the replace value is a missing value, the currently highlighted cell content becomes a missing value.
To replace all occurrences of the specified value:
Enter a value in the Replace with box and click Replace All. Or, if the Search window is closed, select Edit > Search > Replace All.
To replace the value and search for the next value:
Enter a value in the Replace with box and click Replace. Or, if the Search window is closed, select Edit > Search > Replace and Find Next. Or, press CTRL-L.
To use a selected value as the Find what value:
In the data table, select a value. Select Edit > Search > Use Selection for Find. Next, select Edit > Search > Find. The value that you selected in the data table is already entered in the Find what field.
To use a selected value as the Replace with value:
In the data table, select a value. Select Edit > Search > Use Selection for Replace to populate the Replace with field.
To find the next value when the Search window is closed:
Select Edit > Search > Find Next. Or, press CTRL-G, or F3 on Windows.
To find a missing value:
• To find missing character values, leave the Find what field empty and select Match entire cell value.
• To find missing numeric values, type a period into the Find what text box and select Match entire cell value.
Note: Typing a period into the text box without clicking the Match entire cell value box searches for a period.
Reorder Columns
You can rearrange or sort data table columns by their name, data type, or modeling type, or reverse the current order. To reorder columns, select Cols > Reorder Columns and select from one of the following options:
Move Selected Columns
moves the selected columns to a particular place in the data table. Specify where to place the selected columns in the Move Selected Columns window:
– To first: moves the selected columns so they are in the left-most position in the data table.
– To last: moves the selected columns so they are in the right-most position in the data table.
– After: moves the selected columns so they are after a column that you identify.
Original Order
returns the columns to the order they were in at the time the data table was last saved.
Reorder by Name
arranges the columns from left to right in alphabetical order by column name.
Reorder By Data Type
arranges the columns from left to right in alphabetic order by data type (row state, character, numeric).
Reorder By Modeling Type
arranges the columns from left to right in alphabetic order by modeling type (continuous, ordinal, nominal). Row state columns have no modeling type, and are shown last.
Reverse Order
reverses the order of the data table columns.
Group Columns
Group columns within a single heading to manage large numbers of columns and facilitate analysis role assignment. Grouped columns appear in an outline format within the Columns panel.
To group or ungroup columns:
1. Within the data grid, select the columns that you want to group.
2. From the main menu, select Cols > Group Columns or Cols > Ungroup Columns.
or
1. From the Columns panel, select the columns that you want to group.
2. Right-click on the selected columns and select Group Columns or Ungroup Columns.
Note: Grouped columns are automatically retained for data tables generated from the following commands: Subset, Sort, Summary, Join, Stack, and Split. For the Stack command, if all the columns in the stack group belong to the same columns group, then the group's name is used for the column name.
Move Values
To move values in a data table, select the values, click and pause, and then drag and drop the values into the new location.
Tip: Clicking and dragging on a selection without pausing extends the selection.
When dragging and dropping values, note the following:
• Cells retain all of their characteristics and column properties.
• After you move cells, missing values appear in the cells that you initially selected.
• The selected cells and the destination cells must have the same data type.
• If you drag a set of cells to an empty area of the table, new columns are automatically created.
• New columns have the original columns’ display format and modeling types.
To specify where to move rows:
1. Highlight the rows that you want to move.
2. Select Rows > Move Rows.
3. Specify where you would like to move the rows in the Move Rows window:
– To the beginning of the table (At start)
– To the end of the table (At end)
– After a specific row number (After row:)
Move Content into Another Window
In Windows, you can drag selected content over a minimized window. The minimized window moves to the front and you can paste your content into it. You can do the same thing in JMP. For example, you can drag selected content over the Home Window button 
(located in the bottom right corner of most windows). Then in the Window List, drag the content over the window that you want to move the content into. That window moves to the front and you can drop in the content.
(located in the bottom right corner of most windows). Then in the Window List, drag the content over the window that you want to move the content into. That window moves to the front and you can drop in the content.Tip: If you cannot see the JMP Home Window button, select View > Status Bars.
For example, you can drag a selected column, row, or cell from one data table into another; drag selected text from one script window into another; or drag selected content from a report into a journal.
Use the Row Editor
Use the Row Editor to browse or edit cells one row at a time. Open the Row Editor in one of the following ways:
• Select Rows > Row Editor.
• In a data table, double-click in the row number area. The row that you use is the row that first appears in the Row Editor.
• In a report window, right-click in a plot or graph and select Row Editor.
Figure 4.12 Row Editor
Note the following:
• If you have a report window open, and you want edited data to be automatically reflected there, make sure that Automatic Recalc is turned on. See Automatic Recalc in JMP Platforms.
• If your data table contains value labels, the Row Editor displays the label, and when the cell is highlighted for editing, it shows the actual value. See Value Labels in Set Column Properties.
Row Editor Buttons
Click the arrow buttons to browse through selected rows or the entire data set if no rows are selected. Row Editor buttons are described as follows:
Shows the previous row.
Shows the previously selected row.
Makes the row blink in graphs.
Shows the next selected row.
Shows the next row.
Searches for a row. See Select Cells.
Creates a new row at the end of the data table.Row Editor Options
The red triangle menu in the Row Editor contains the following options:
Next Selected
displays information for the selected row that is located after the current one.
Prev Selected
displays information for the selected row that is located before the current one.
Next
displays information for the row that is located after the current one, regardless of whether the row is selected.
Prev
displays information for the row that is located before the current one, regardless of whether the row is selected.
Save
saves the data table and any changes that you have made to it via the Row Editor.
New Row
creates a new row in the data table.
Find
displays the same window as if you had selected Rows > Row Selection > Select Where. Select one of the options on the Action on currently selected rows menu, and then highlight the column whose rows you want to select. Type in the value for which you want JMP to search. See Select Cells.
Blink
causes the current row’s highlight to flash at a rapid rate.
Note: Text in a locked column or a locked data table cannot be edited. For details, see Lock Tables, and Lock Columns in Place.
Context Menus for Rows and Columns
When you right-click in the row number area, or at the top of a column in the column name area, context menus appear. These menus provide quick access to selected commands in the Rows and Columns menus. For details about these options, see Context Menu for Columns in Get Started and Context Menu for Rows in Get Started.
Edit Data Tables
This section describes the following actions that you can perform on data tables:
• Change the data table name
• Lock data tables
• Add table variables
• Add scripts to the data table
• Compare data tables
Change Table Names
A data table’s name appears at the top of its window, in the table panel, and on all related analysis reports. You can change a data table’s name in any of the following ways:
• Select File > Save As and save as the new name.
• In the table panel, click twice on the table name, type the new name, and then press the Enter key.
• On Windows. select Window > Set Title.
Lock Tables
Locking a JMP data table prevents its values from being edited. You can still run analyses, assign characteristics, and so on. To lock a data table, click the red triangle menu next to the table name in the table panel and select Lock Data Table.
A lock icon 
appears next to the data table name. To unlock the file, select Lock Data Table again.
appears next to the data table name. To unlock the file, select Lock Data Table again.If you make a data table read-only outside of JMP (for example, by changing its properties on Windows), the data table contains a note informing you that it is locked. See Figure 4.13. This type of lock allows users to edit the data table, but not save the changes.
Figure 4.13 A Read-Only File
Use Table Variables
Note: Starting in JMP 10, the Table Variable window is non-modal, meaning that you can access other windows and perform other operations while the Table Variable window is open.
A table variable can contain textual information (for example, source information for the data), or a value that can be used by column formulas or JSL scripts. Table variable names appear in the table panel at the left of the data grid. See Figure 4.14.
Figure 4.14 Table Variables in the Table Panel
Uses for Table Variables
Use table variables in the following situations:
• To document tables
• In formulas
• In JSL scripts
Use Table Variables to Document Tables
Table variables are used primarily to document tables. Many sample data tables installed with JMP contain a table variable named Notes. This variable provides details about the data (for example, the source of the data). The example in Figure 4.14 shows a data table that contains Notes as one of its table variables. JMP also automatically creates table variables when you create a design table using the Design of Experiments commands in JMP. The design table has a table variable named Design with the name of the design type as its value.
Reference Table Variables in Formulas
Table variables can also be incorporated in formulas that you build using the Formula Editor. These formulas calculate values for a column by referring to a table variable. For details about constructing a formula that uses table variables, see Reference Columns and Table Variables in Formula Editor.
Use Table Variables in JSL Scripts
You can also incorporate table variables into JSL scripts. See the Scripting Guide for details.
Table Variable Actions
To add new table variables
1. In the Table panel, click the red triangle menu to the left of the data table name.
2. Select New Table Variable.
3. Give the variable a name and value in the boxes labeled Name and Value.
4. Click OK.
The table variable appears in the Table panel.
To view or edit table variables
1. Double-click on the content of an existing table variable.
2. Edit the content.
To edit a table variable name
1. Double-click the table variable name.
2. Edit the name.
To delete table variables
Right-click the table variable name or value and select Delete.
Concatenating Data Tables with Table Variables
Create and Save Scripts
Note: Starting in JMP 10, the Script window is non-modal, meaning that you can access other windows and perform other operations while you are in the Script window.
To automatically complete various analyses and tasks, you can create a JSL script and save it to the data table. See Figure 4.15. For detailed explanations of scripts, see the Scripting Guide.
Figure 4.15 Scripts Saved With the Data Table
Save a Report Script to a Data Table
Once you have run an analysis and you are in the report window, you can add a script to the data table. This script generates the JSL that reproduces your analysis.
To save a script to the data table:
• From the report window, click on the red triangle menu for the platform and select Script > Save Script to Data Table.
Example of Saving a Report Script to a Data Table
First, you create your analysis, then you save the script.
1. Open the BigClass.jmp sample data table.
2. Select Analyze > Fit Y by X.
3. Select weight and click Y, Response.
4. Select height and click X, Factor.
5. Click OK.
6. From the red triangle menu, select Fit Line.
7. From the red triangle menu for Bivariate Fit, select Script > Save Script to Data Table.
Figure 4.16 Click the Red Triangle
The script is added to the bottom of the Table panel.
Tip: If you want a particular script to run automatically every time the data table is opened, name the script OnOpen. Only one script saved in the data table can be set to run automatically. If you name the script Model (or model) in a Fit Model script, the launch window is automatically filled in based on the script when you select Analyze > Fit Model.
Write a JSL Script for the Data Table
To add a script to a data table using JSL:
1. Click the red triangle menu to the left of the data table name in the Table panel. See Figure 4.17.
Figure 4.17 Creating a Script
2. Select New Script.
3. Give the script a name by typing it into the box beside Name.
4. Add the script by entering JSL code into the box beside Script.
5. Perform one of the following actions:
– If you want to run the JSL Debugger on the script to check it for errors, click Debug Script.
– If you are finished editing the script, click OK. The script appears in the Table panel and the window closes.
– If you are not finished editing the script and want to save it, click Save. The script appears in the Table panel and the window remains open for further editing.
– If you want to run the script, click Run.
Run, Edit, Delete, or Copy Scripts
To run, edit, delete, or copy a script that is saved to the data table:
1. In the Table panel, click the red triangle menu beside the script’s name, or right-click on the script name.
2. Select one of the following commands:
– Run Script
– Edit
– Delete
– Copy
Once you copy a script, you can then paste it into a script window or into the Table panel of another data table.
Compare Data Tables
JMP can compare two open data tables and report the differences between data, scripts, table variables, column names, column properties, and column attributes. Character values that do not match exactly appear in the report. For numeric data, you can select a relative (or fuzzy) comparison. The numeric values are considered equal if they are within the relative error rate that you specify. The smaller the relative error, the more precise the comparison.
To compare two data tables:
1. Open the data tables.
2. In one of the tables, select Tables > Compare Data Tables.
3. If necessary, select the data table that you want to compare from the list.
4. (Optional) Select Fuzzy Compare and enter the relative error to see numeric differences within the specified rate.
5. Click on the red triangle menu and select the following options:
– which items you want to compare
– how to show the differences
6. Click Compare.
The Difference Summary and Difference Plot are shown by default. The red triangle options that you selected also appear.
Basic Table Information
The Tables Info report shows the data table names and locations along with the numbers of columns and rows in each table. In Figure 4.18, you see that Big Class1.jmp contains one more row than Big Class2.jmp.
Figure 4.18 Basic Information
Compare Data
The interactive Difference Summary report and Different Plot indicate how rows differ between reports. Each entry in the Difference Summary report shows which action occurred, how many rows are affected, and the first row in which the change occurs.
In Figure 4.19, Big Class1.jmp (left) and Big Class2.jmp (right) are compared.
• The first entry in Figure 4.19 indicates that one row (N) has changed (or been replaced) in the first row of Big Class2.jmp. When you select the entry in the Difference Summary report on the left, the entry is highlighted in yellow, and the row flashes in the data table.
For a graphical view of the comparison, place your cursor over a colored cell in the Difference Plot. Figure 4.19 shows that the name KATIE in Big Class1.jmp was changed to KIM in Big Class2.jmp. The entire first row is highlighted in the Difference Plot, which tells you that all values in that row are different.
Figure 4.19 Modified Data
• In Figure 4.20, the second entry indicates that two rows were deleted beginning at row four. The deleted rows are highlighted in Big Class1.jmp on the left. And the Difference Plot specifies the different values. The name in row four of Big Class1.jmp was JACLYN and TIM in Big Class2.jmp.
Figure 4.20 Deleted Rows
• In Figure 4.21, the third entry tells you that one row was added before what was originally row eight. The name in row eight of Big Class1.jmp was ROBERT. PETER is the name in row six of Big Class2.jmp.
Figure 4.21 Identify New Rows
Click the Previous difference and Next difference buttons above the Difference Summary to navigate from row to row.
Tip: Save the Difference Summary report to a data table by selecting Save Difference Summary from the red triangle menu.
Compare Table Properties
Select Compare Table Properties from the red triangle menu to see differences in table scripts and variables. For example, Figure 4.22 shows that the Distribution script in Big Class2.jmp refers to the height column rather than the weight column.
Figure 4.22 Modified Table Script
Compare Column Attributes and Properties
Select Compare Column Attributes and Properties from the red triangle menu to see differences in column notes, cell colors, and the like. For example, Figure 4.23 shows that column notes and value colors differ in Big Class2.jmp.
Figure 4.23 Modified Column Attributes and Properties
Assign Characteristics to Rows and Columns
This section describes how to exclude, hide, label, color, or mark rows and columns in order to customize the appearance of points in scatterplots and graphs. You can also lock columns so that they stay in place when you scroll through the data table.
The menu for row actions can be accessed from three places:
• the Rows menu in the main menu
• the red triangle in the Rows panel
• the left red triangle in the upper left corner of the data grid
Similarly, the menu for columns actions can be accessed from three places:
• the Cols menu in the main menu
• the red triangle in the Columns panel
• the right red triangle in the upper left corner of the data grid
Exclude Rows and Columns
Marking rows and columns as excluded means that they will not be analyzed. Note the following:
• Excluded observations are excluded from calculations in text reports and graphs. For most platforms, excluded observations are not hidden in plots.
• Use Hide/Unhide to hide observations in plots and graphs for most platforms. See Hide Rows and Columns.
• A circle with a strikethrough (
) appears beside either the row number or the column name in the Columns panel. The circle indicates that the row or column is excluded and therefore not analyzed.
) appears beside either the row number or the column name in the Columns panel. The circle indicates that the row or column is excluded and therefore not analyzed.• For most platforms, data remain excluded until you select Exclude/Unexclude again.
To exclude one or more rows from analyses:
1. Highlight one or more rows that you want to exclude.
2. Right-click on the selected rows and select Exclude/Unexclude.
or
From the Rows menu, select Exclude/Unexclude.
To exclude one or more columns from analyses:
1. Highlight one or more columns that you want to exclude.
2. Select Cols > Exclude/Unexclude or right-click select Exclude/Unexclude.
To unexclude rows or columns:
1. Highlight the excluded rows or columns that you want to include in your analyses.
2. Select Exclude/Unexclude from the Rows menu or Cols menu. You can also right-click rows or columns and select Exclude/Unexclude.
Hide Rows and Columns
Marking rows and columns as hidden means that they do not appear in plots and graphs. Note the following:
• Hiding rows and columns does not exclude them from analyses. They simply do not appear in plots and graphs.
• To exclude hidden observations from analyses, use the Exclude/Unexclude option. See Exclude Rows and Columns.
• A mask icon (
) appears beside the hidden row number or the column name, indicating that the row or column is hidden.
) appears beside the hidden row number or the column name, indicating that the row or column is hidden.• Observations remain hidden until you select Hide/Unhide again.
To hide one or more rows:
1. Highlight one or more rows that you want to hide.
2. Right-click on the selected rows and select Hide/Unhide
or
From the Rows menu, select Hide/Unhide.
To hide one or more columns:
1. Highlight one or more columns that you want to hide.
2. Select Cols > Hide/Unhide or right-click and select Hide/Unhide.
To unhide rows or columns:
1. Highlight the hidden rows or columns that you want to show in your plots and graphs.
2. Select Hide/Unhide from the Rows menu or Cols menu. You can also right-click rows or columns and select Hide/Unhide.
Label Rows and Columns
When you position the arrow cursor over a point in a plot, the point’s label appears. By default, row numbers are used as labels. You can customize the labels as follows:
• You can change the label to display column values instead of the row number.
• You can enable the label to always appear, not only when you position the cursor over points.
• A label or yellow tag icon (
) appears beside the column name in the Columns panel, indicating that points on plots are identified by the column value. If there are multiple columns that are labeled, their values appear on plots separated by a comma.
) appears beside the column name in the Columns panel, indicating that points on plots are identified by the column value. If there are multiple columns that are labeled, their values appear on plots separated by a comma.• Data remain labeled until you select Label/Unlabel again.
To change the label to display column values:
1. Highlight one or more columns whose values you want to appear as the label in plots.
2. Select Cols > Label/Unlabel from the menu or right-click and select Label/Unlabel.
To enable the label to always appear (not just when you position the cursor over points):
1. Highlight one or more rows whose label you want to always appear in plots.
2. Select Rows > Label/Unlabel from the menu.
To turn off labeling for rows or columns:
1. Highlight the labeled rows or columns that you no longer want labeled.
2. Select Label/Unlabel from the Rows menu or Cols menu. You can also right-click columns or rows and select Label/Unlabel.
Assign Colors or Markers to Rows
• If you assign a color to a row, the points representing the values in that row are colored in the plot.
• If you assign a marker to a row, the point is replaced with the marker in the plot.
• You can also assign colors or markers based on column values.
Assign a Color to Rows
Assigning a color to selected rows means that the points in plots appear in the color that you select. In the data grid, the active color assigned to a row appears next to the row number.
To assign rows a color:
1. Highlight one or more rows that you want to assign a color to.
2. Right-click on the highlighted rows and select Rows > Colors.
3. Select one of the available colors.
Tip: To clear an assigned color from the selected rows, assign the color black.
Add Markers to Rows
To replace the standard points in plots with a marker, use the JMP markers palette. In the data table, these markers also appear next to row numbers.
1. Highlight one or more rows that you want to apply the marker to.
2. Right-click on the selected rows and select Markers, and then select the marker shape.
Select Other to create custom markers. You can type alphabetic characters, numerals, and other keyboard symbols.
Tip: To return to the default marker, select the initial dot marker.
Assign Colors or Markers to Rows Based on Column Values
You can assign colors or markers to your data table rows based on the values found in a particular column. For example, in a column called Sex, you could assign all rows whose value is F a red circle marker. All rows whose value is M could have a green plus marker. These colors and markers replace the default black dot in plots and appear next to its row number in the data table.
To assign colors or markers to rows based on column values:
1. Select Rows > Color or Mark by Column.
2. Highlight the column to assign the color or marker to. See Figure 4.24.
Figure 4.24 Color or Mark by Column
3. Select the Colors and Markers schemes to apply.
A preview of your selection appears under Row States.
4. (Optional) Select any additional options. See Color or Mark by Column Options.
5. Click OK.
6. (Optional) To shade all rows according to their row state, right-click in the row numbers area within the data grid and select Color Rows by Row State.
From then on, the rows are shaded with the color that you assign to the rows.
Color or Mark by Column Options
Colors
select a color theme to assign different colors to the rows in your data table. Color assignment is based on the values of the selected column.
Continuous Scale
assigns colors in a chromatic sequence based on the values in the highlighted column.
Reverse Scale
assigns colors in a reversed chromatic sequence based on the values in the highlighted column.
Markers
assigns a different marker to each row in your data table based on the values found in the column that you highlighted.
Make Window with Legend
Includes a legend with your new characteristics so that you can easily identify which colors and markers correspond with which row.
Save To Column Property
saves the color and marker information as a column property. The rows in the selected column of the data table are colored, based on the color theme.
Save To Table Property
saves the color and marker information as a table property.
Excluded Rows
assigns colors or markers to rows that are excluded.
Create Color Themes
JMP includes several color themes that can distinguish a range of values in a graph. You can also create your own color themes based on an existing color theme or create custom themes.
Note: When you select a default color theme, the colors are not applied to reports that are open. You need to rerun the existing reports to format them with the default color theme.
To create a color theme:
1. Select File > Preferences > Graphs.
2. Click the Custom Color Themes button.
The Customize Color Themes window appears.
Figure 4.25 Customize Color Themes Window
3. Click the 
button.
button.A new color theme is created based on the default continuous color theme. A temporary name is assigned to the theme.
4. Type a new name in place of the temporary label. On Windows, do not press ENTER. The window closes if you do so.
5. (Optional) To base the theme on an existing theme, right-click the color bar, select Copy From, and then select the color theme.
6. To modify the color theme, do any of the following:
– To modify the gradient of continuous color, move the sliders left or right.
– To add more colors to the gradient, double-click the color bar, select a color from the Color window and click OK. A new slider is displayed under the color bar.
– To change the color of a slider, click on the slider to display the Color window and choose another color.
– To distribute the colors evenly on the gradient, right-click the color bar and select Space Evenly.
– To reverse the order of the colors on the gradient, right-click the color bar and select Reverse.
– To convert the gradient to distinct blocks of color (rather than graduated color), right-click and deselect Continuous.
– To remove a color from the color theme, click the color’s slider and drag the slider above or below the color bar.
– To discard your changes, right-click the color bar and select Revert.
7. Click OK.
Customize Color Themes Buttons
Moves the selected color theme up in the list.
Moves the selected color theme down in the list.
Deletes the selected color theme. Adds a new color theme.Continuous and Categorical Color Themes
The following figure shows examples of the two types of color themes in JMP, continuous and categorical. When a color theme is selected for continuous data, the colors are graduated (as shown on the left). When the same color theme is selected for categorical data, the color consists of distinct blocks of color. (as shown on the right).
Figure 4.26 Examples of Continuous and Categorical Color Themes
Custom Color Themes
Custom color themes can be applied in the same way as built-in color themes:
• You can select custom color themes as defaults from the Continuous Color Theme and Categorical Color Theme drop-down menus in the Graphs preferences. Only continuous color themes are available for continuous data. All color themes are available for categorical data.
• You can apply the custom color themes to components such as markers and data table rows. See Assign Colors or Markers to Rows Based on Column Values for details.
• In certain reports, such as treemaps and surface plots, you can select specific custom color themes. See the Basic Analysis and Graphing book for details.
Use Custom Color Themes on Multiple Computers
In Windows, the color themes that you create are defined in the JMP preferences file called JMP.PFS. If you use JMP on more than one computer (for example, at home and at work), you can copy the color theme definitions from one JMP preferences file to another. Custom colors are then available on both computers.
In the preferences file, the code for a custom color theme looks like this:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
In this example, the name of the color theme is “Pink to Blue.” The Red/Green/Blue (RGB) values for each color slider are located in brackets. The first slider defines the RGB values 255, 168, and 255. The second and third groups of brackets define colors for the second and third sliders.
In a text editor (such as Microsoft Notepad) add this color theme to the preferences file on your other computer. The preferences file is located in the following folders:
• Windows XP: C:Documents and Settings<username>Local SettingsApplication DataSASJMP10
• Windows Vista and 7: C:Users<username>AppDataLocalSASJMP10
Note: To see the preceding folders, you must configure Windows Explorer to show hidden files and folders. For details, refer to the Windows help.
To Transfer Color Themes to Another Windows Computer:
1. On the computer that contains the customized JMP preferences, select File > New > Script.
The Script window appears.
2. Type the following JSL function:
Show Preferences()
3. Click the Run Script button 
.
.Your customized preferences are written to the log.
4. Select View > Log (or display the open log).
The custom color theme that you created appears, for example:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
This definition might be in the middle of other customized preferences that appear in the log.
5. Save the log as Log.jsl and open the file on the computer whose preferences you are updating.
6. On the computer whose preferences you are updating, close JMP.
7. Make a backup of JMP.PFS, and then open the original JMP.PFS in a text editor.
8. Copy and paste the custom color definition from Log.jsl to JMP.PFS. The definition goes after Preferences( as shown in the following example:
Preferences(
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
);
Note: Be sure to include the closing parenthesis and comma. The code does not need to be indented. You can put the code in any valid location. Pasting it after Preferences( helps ensure that you do not delete any necessary parentheses or commas.
9. Save the file.
If you open JMP and the new color definition is not displayed in the preferences, delete the updated preferences file and add the definition to the original preferences file. Make sure that you copy and paste the definition in the correct location.
Delete All Row Characteristics
To clear all row states in the data table, select Rows > Clear Row States.
All rows become included, visible, unlabeled, and show in plots as black dots. The Clear Row States command does not affect row states saved in row state columns.
Lock Columns in Place
You can lock a column in place so that when you scroll horizontally, the column remains visible. Highlight the columns and select Cols > Scroll Lock/Unlock. Note the following:
• Hidden columns cannot be scroll locked.
• The name of a locked column appears in italics in the Columns panel.
• Scroll locked columns are moved to the left in the data grid. Once you unlock them, they are not moved back to their original locations in the data table, but remain on the left.
• Columns remain scroll locked until you highlight the columns and select Scroll Lock/Unlock again.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.