You are previewing Using JMP 13.
O'Reilly logo
Using JMP 13

Book Description

Using JMP 13 shows you how to perform common tasks such as importing data, setting column properties, exporting analyses as graphics or HTML, and modifying JMP preferences. Details about connecting to SAS and working in the Formula Editor are also provided.

Table of Contents

  1. Contents
  2. Learn about JMP
    1. Documentation and Additional Resources
    2. Formatting Conventions
    3. JMP Documentation
      1. JMP Documentation Library
      2. JMP Help
    4. Additional Resources for Learning JMP
      1. Tutorials
      2. Sample Data Tables
      3. Learn about Statistical and JSL Terms
      4. Learn JMP Tips and Tricks
      5. Tooltips
      6. JMP User Community
      7. JMPer Cable
      8. JMP Books by Users
      9. The JMP Starter Window
    5. Technical Support
  3. Get Started
    1. Introduction to Basic Features
    2. Anatomy of a JMP Session
    3. Data Tables
      1. Data Table Panels
        1. Table Panel
        2. Columns Panel
        3. Rows Panel
      2. Data Grid
        1. Context Menu for Columns
        2. Context Menu for Rows
        3. Cursor Forms
      3. Open Data File Options
    4. Platforms
      1. Launch Windows
        1. Cast Selected Columns into Roles Buttons
      2. Reports
    5. Manage JMP Files and Open Windows
      1. JMP Home Window on Windows
        1. JMP Home Window Buttons
        2. Recent Files
        3. Window List
        4. Rearrange Panels in the Home Window
      2. JMP Home Window on Macintosh
        1. Recent Files
        2. Window List
      3. Search for Recently Opened Files on Windows
      4. Close Multiple Files
      5. Display and Arrange Open Windows
      6. Preview JMP Files
      7. Using the Reveal Feature
    6. JMP Starter Window
  4. Import Your Data
    1. Create Data Tables
    2. About Importing Data to JMP
    3. Import Microsoft Excel Files
      1. Preview and Import the Microsoft Excel Data
        1. Importing a Microsoft Excel File with Hierarchical Headings
      2. Import a Microsoft Excel File Directly
    4. Import Data from SAS
      1. Import SAS Data Sets
      2. Create SAS Transport Files in SAS
      3. Connect to SAS
        1. Connect to a SAS Metadata Server
        2. Connect to a Remote SAS Workspace Server
        3. Connect to a SAS Environment (Windows Only)
        4. Connect to SAS on Your Local Machine (Windows Only)
      4. Open SAS Data Sets with SAS Query Builder
      5. Open SAS Data Sets through a SAS Server
        1. Browse SAS Data Information
        2. Open a SAS Data Set in JMP
        3. Import a Sample of a SAS Data Set
        4. Open Password-Protected Data Sets
      6. Using SAS Extended Attributes to Import Metadata
      7. Run Stored Processes
      8. Submit SAS Code
      9. Generate ODS Results
      10. Retrieve Generated SAS Data Sets
        1. Export JMP Data Tables to SAS
    5. Build SQL Queries in Query Builder
      1. Connect to a SQL Database
      2. Select Tables from a SQL Database
        1. Edit the Conditions for Joining Tables
      3. Build the SQL Query
        1. Select Columns from the Database Table
        2. Maintain Compatibility with JMP 12
        3. Create a Computed Column
        4. Group the Common Values
        5. Import a Sample of the Data
        6. Select Filters to Import a Subset of the Data
        7. Import Matching Data from an Existing Data Table
        8. Write a Custom Expression to Import a Subset of the Data
        9. Sort the Selected Data
        10. View the Query Status
        11. Write a Post-Query Script
      4. Save and Run the Query
      5. Open the Selected Data in JMP
      6. Query Builder Red Triangle Options
      7. Write SQL Statements in Query Builder
    6. Import Data from a Database
      1. Connect to a Database
      2. Open Data from a Database
      3. Write SQL Statements to Query a Database
      4. Structured Query Language (SQL): A Reference
        1. Use the WHERE Clause Editor
    7. Import Text Files
      1. Text Import Wizard Options
      2. Open a Text File in a Text Editing Window
      3. Import Text from the Script Editor
    8. Import Data from the Internet or a Remote Computer
    9. Import SPSS Files
    10. Import Triple-S Survey Data
    11. Import HDF5 Data
    12. Import JSON Files
    13. Import Data from MATLAB
    14. Import Data from R
    15. Import Data Using the Excel Add-In
      1. Transfer Excel Data to a JMP Data Table
      2. About the JMP Add-In for Excel
      3. Uninstall the Excel Add-In
    16. Create New Data Tables
  5. Enter and Edit Data
    1. Perform Basic Data Table Tasks
    2. Enter Data
      1. Copy and Paste Data
      2. Add Rows
      3. Add Columns
      4. Fill Columns with Sequential Data
        1. Fill Options
      5. Enter Cell Formulas
    3. Select Rows
      1. Locate Next and Previously Selected Rows
    4. Select Columns
      1. Select Columns in a Data Table
      2. Select Columns in the Columns Viewer
      3. Locate Next and Previously Selected Columns
    5. Select Cells
    6. Resize Rows and Columns
    7. Organize Data
      1. Delete Rows and Columns
      2. Rearrange Columns
      3. Group Columns
      4. Move Values
        1. Move Content into Another Window
      5. Color Cells
      6. Edit or Delete Cells
      7. Edit Column Names
      8. Hide and Exclude Rows
      9. Exclude Rows
      10. Hide Rows
      11. Exclude Columns
      12. Hide Columns
      13. View Patterns of Missing Data
        1. Example of Viewing Patterns of Missing Data
      14. Find and Replace Cell Values
        1. Find Window Options
        2. Search Actions
      15. Use the Row Editor to Edit Cells in a Row
        1. Row Editor Buttons
        2. Row Editor Options
      16. Context Menus for Rows and Columns
      17. Compare Data Tables
    8. Assign Characteristics to Rows and Columns
      1. Label Rows and Columns
      2. Assign Colors or Markers to Rows
        1. Assign a Color to Rows
        2. Add Markers to Rows
        3. Assign Colors or Markers to Rows Based on Column Values
      3. Create Color Themes
        1. Continuous and Categorical Color Themes
        2. Custom Color Themes
      4. Delete Custom Color Themes
      5. Delete Row Characteristics
      6. Lock Columns in Place
    9. Restructure Data
      1. Make a Column into Multiple Columns
      2. Make Indicator Columns
      3. Combine Columns
      4. Compress Selected Columns
      5. Make Binning Formula
      6. Make a New Formula Column
      7. Transform Columns
        1. Transform Menu
        2. Combine Menu
        3. Aggregate Menu
        4. Distributional Menu
        5. Date Time Menu
        6. Character Menu
        7. Row Menu
        8. Transform Column Options
      8. Recode Data
        1. Red Triangle Options for Recode
        2. Right-Click Options for Recode
        3. Grouping Options for Recode
        4. Example of Grouping Based on Character Difference
        5. Example of Grouping Based on Difference Ratio
    10. Edit the Data Table
      1. Change Table Names
      2. Lock Tables
      3. Compress Tables
      4. Use Table Variables
        1. Uses for Table Variables
        2. Table Variable Actions
        3. Concatenating Data Tables with Table Variables
      5. Create and Save Scripts
        1. Save a Report Script to a Data Table
        2. Write a JSL Script for the Data Table
        3. Run, Edit, Delete, or Copy Scripts
  6. The Column Info Window
    1. Set Column Attributes and Properties
    2. About the Column Info Window
      1. About Modeling Types
      2. The Short-Integer Format
      3. Numeric Formats
        1. Specify Width
        2. Numeric Format Options
        3. International Formats
      4. Row State Columns
        1. Permanently Select Cells
      5. Initialize Data
    3. Column Properties
      1. Basic Column Properties
        1. Formula
        2. Notes
      2. Properties That Validate Column Values
        1. Range Check
        2. List Check
        3. Missing Value Codes
      3. Properties That Attach Information to Column Values
        1. Value Labels
        2. Value Scores
        3. Value Ordering
        4. Row Order Levels
        5. Value Colors
        6. Color Gradient
      4. Properties That Control the Display of Columns
        1. Axis
        2. Units
      5. Properties Used in Modeling and DOE
        1. Response Limits
        2. Design Role
        3. Coding
        4. Mixture
        5. Factor Changes
      6. Properties Associated with Control Charts and Capability
        1. Spec Limits
        2. Control Limits
        3. Sigma
        4. Process Capability Distribution
      7. Properties That Control How Columns Are Used in Platforms
        1. Distribution
        2. Time Frequency
        3. Map Role
        4. Supercategories
        5. Multiple Response
        6. Profit Matrix
        7. Informative Missing
      8. Virtual Join Properties
        1. Link ID
        2. Link Reference
      9. Additional Properties
        1. Expression Role
        2. Other
      10. Properties Assigned and Controlled by JMP
        1. Response Probability
        2. Predicting
        3. Informative Missing Terms
        4. Column ID
    4. Standardize Attributes and Properties Across Columns
      1. Recode Values
      2. Standardize Attributes
      3. Standardize Properties
      4. Delete Properties
      5. Example of Standardizing a Formula
    5. Assign a Preselected Analysis Role
  7. Reshape Data
    1. Create Subsets, Sort Data, and More
    2. Create a Subset Data Table
      1. Stratified Subsets
      2. Create a Subset Data Table from a Report
    3. Sort Data Tables
    4. Stack Columns
      1. Example of Stacking into One Column
      2. Example of Stacking into More Than One Column
    5. Split Columns
      1. Examples of Splitting Columns
        1. Split a Column: Basic Example
        2. Split a Column: Grouping Rows Example
    6. Transpose Rows and Columns
      1. Examples of Transposing Rows and Columns
    7. Concatenate Data Tables
      1. Example of Concatenating Data Tables
      2. Example of Concatenating Data Tables and Table Variables
    8. Join Data Tables
      1. Examples of Joining Data Tables
        1. Example of Joining by Row Number
        2. Examples of a Cartesian Join
        3. Examples of Joining By Matching Columns
    9. Query and Join Data Tables with JMP Query Builder
      1. About Links to Data Tables in JMP Queries
    10. Virtually Join Data Tables
    11. Update Data Tables
      1. Example of Updating a Data Table
    12. Anonymize Data
  8. Formula Editor
    1. Construct Formulas
    2. Formula Overview
    3. Create a Formula
    4. Refer to Values in Columns and Table Variables
    5. Use Local Variables
      1. Incorporate Parameters
    6. Insert Constants
    7. Add Operators
      1. Keypad Reference
    8. Use Functions in a Formula
    9. Order Expressions in Formulas
      1. Build a Formula in Order of Precedence
        1. Structure Formulas for Efficient Evaluation
    10. Use Formula Editor Options
      1. Calculate Derivatives
      2. Simplify Complex Formulas
      3. Evaluate Formulas
        1. Suppress Evaluation
      4. Ignore Errors
      5. View a Formula’s Values from the Formula Editor
      6. View a Formula in JSL
    11. Edit Formulas
      1. Correct Mistakes
      2. Select Expressions
      3. Delete Functions
      4. Cut, Copy, and Paste
      5. Click and Drag
    12. Customize Formulas
      1. Hide and Show Boxing
      2. Change the Font Size
      3. Specify the Matrix Size
      4. Change the Orientation of a Formula
      5. Open and Close Arguments
    13. Examples and Tutorials
      1. Use Basic Formula Editor Features
      2. Use Local Variables in a Formula
      3. Use the Munger Function
        1. Insert Characters
        2. Delete Characters
        3. Find the Position (Index) of a Value
        4. Find a Substring
      4. Use the Match Conditional Function
      5. Use the Delete Expression Button
    14. Keyboard Shortcuts
    15. Glossary of Terms
  9. Summarize Data
    1. The Table Summary Command
    2. Summarize Columns
      1. Launch Window Roles
      2. Create a Summary Table
        1. Add Summary Statistics
        2. Use One or More Grouping Columns
        3. Use Quantile Statistics
        4. Change the Format of the Statistics Column Name
        5. Link to the Original Data Table
        6. Keep the Summary Window Open
        7. Create a Two-Way Table of Summary Statistics by Adding a Subgroup Variable
      3. Add a Statistics Column to an Existing Summary Table
    3. Explanation of Statistics
    4. Example of Creating a Summary Table
  10. JMP Reports
    1. Navigate and Customize Report Windows
    2. Navigate Reports
      1. Use the Hand Tool
      2. Access Report Display Options
      3. Show and Hide Parts of a Report
      4. Combine Several Reports
      5. Rename a Title
      6. Increase Font Sizes
      7. Resize a Window
    3. Red Triangle Options in a Report
      1. Local Data Filter
      2. Redo Menus
      3. Save Script Menus
        1. Automatic Recalc
        2. Column Switcher
    4. The Data Filter
      1. Types of Filter Columns
      2. Filtering Modes
      3. The Data Filter Control Panel
        1. Changing the Row State in the Data Table After Making Data Filter Selections
      4. Red Triangle Options for the Data Filter
        1. Conditional Data Filters
        2. Grouped by AND in Data Filters
        3. Animation in Data Filters
        4. Save WHERE Clause in Data Filters
      5. Red Triangle Options for Variables
        1. Options for All Types of Variables
        2. Options for Continuous Variables
        3. Options for Nominal or Ordinal Variables
        4. Options for Variables with the Multiple Response Modeling Type or Column Property
    5. Reformat Report Tables
      1. Modify Display Box Properties in a Report
      2. Turn a Report Table Into a Matrix
      3. Use Conditional Formatting
        1. Disable or Enable a Rule
        2. Add a Rule
        3. Edit a Rule
    6. Select Points in Graphs
      1. Select Rows in Graphs
      2. Select a Rectangular Area of Points
      3. Select an Irregular-Shaped Area of Points
    7. Use Markers
      1. Change Marker Shape
      2. Change Marker Colors
      3. Change Marker Size
      4. Change the Marker Drawing Mode and Transparency
      5. Add Outlines Around Markers
      6. Marker Selection Modes
      7. Specify Marker Transparency
      8. Exclude and Hide Markers
      9. Add Labels to Markers
      10. Change Marker Shape or Colors Based On Values
        1. Remove the Row Legend
    8. Change the Appearance of Graphs
      1. Resize Graphs
        1. Use Click and Drag
        2. Specify Size in Pixels
      2. Zoom In and Out
      3. Pin Hover Labels on a Graph
      4. Change Line Widths
      5. Change the Background Color in a Graph
      6. Change the Color of Histogram Bars
      7. Display Coordinates and Temporary Reference Lines
      8. Scroll and Scale Axes
      9. Customize Axes and Axis Labels in the Axis Settings Window
        1. Scale
        2. Tick/Bin Increment
        3. Axis Label Row
        4. Reference Lines
      10. Customize Axes and Axis Labels Using the Right-Click Menu
        1. Extend Divider Lines and Frames for Categorical Axes
        2. Add and Remove Axis Labels
        3. Rotate Axis Labels and Tick Marks
        4. Copy and Paste Graph Contents
        5. Copy and Paste Axis Settings
      11. Change the Order of Values
      12. Change the Pattern and Format of Selected Objects
      13. Add a Graph to a Data Table
      14. Customize Graphical Elements
        1. Create Scripts for Graphical Elements
        2. Change the Drawing Order of Graphical Elements
        3. Save Your Customizations
        4. Copy Your Customizations
    9. Add Images to a Graph or Report
      1. Paste a Background Image into a Graph
      2. Paste an Image at the End of a Report
      3. Drag and Drop an Image into a Graph
        1. Image Processing
      4. Add Geographical Images and Boundaries
      5. Extract Data from an Image
    10. Add Annotations and Shapes to a Report
      1. Add Annotations
      2. Add Shapes
        1. Add a Line
        2. Add a Polygon or Bezier Curve
        3. Add an Oval or Rectangle
  11. Save and Share Data
    1. Get Your Data Out of JMP
    2. Save and Share Data Tables
      1. Save as a Microsoft Excel File
        1. Save One Data Table as a Microsoft Excel Workbook
        2. Save Multiple Data Tables as a Microsoft Excel Workbook
      2. Save as a CSV File
      3. Save as a Text File
        1. Windows
        2. Macintosh
      4. Save as a SAS Transport File
        1. Windows
        2. Macintosh
      5. Save as a SAS Data Set
        1. Windows
        2. Macintosh
      6. Save Data Tables to a Database
      7. Replace a Database with a Data Table
      8. Email a Data Table
    3. Save and Share Reports
      1. Email a Report
      2. Save the Report as Interactive HTML
        1. Interactive HTML Contains Data
        2. Which Reports Are Supported
      3. Create a Web Report
        1. Web Report Options
      4. Save as PowerPoint
        1. Custom PowerPoint Templates
      5. Save as Flash
      6. Setting the Graphic DPI
    4. Save Your Analysis as a Script
      1. Save Using the Layout Command
      2. Save Parts of a Report in a Graphic Format
    5. Print Reports
    6. Copy and Paste Reports
    7. JMP Journals
      1. Create a New Journal
      2. Prevent Modifications
      3. Append Reports to a Journal
      4. Add and Edit Outline Levels
      5. Control the Display of Outline Levels
      6. Add a Graph or Graphic
      7. Customize Journal Items
      8. Save the Journal in Another Format
        1. Windows
        2. Macintosh
      9. Print a Journal
      10. Delete Items from a Journal
      11. Example of Making a Journal for a Presentation
    8. Save JMP Sessions
      1. Save Sessions upon Exiting
      2. Save Sessions Manually
    9. JMP Projects (Windows Only)
      1. Create a JMP Project
      2. Save a JMP Project
      3. Close a JMP Project
      4. Open a JMP Project
      5. Add Items to a JMP Project
        1. Project Menu
        2. Drag and Drop Files
      6. Customize the Project
        1. Open Files
        2. Groups
        3. Notes
      7. Fix Broken Links
    10. Save a Log Window
  12. Extend JMP
    1. Create Dashboards
    2. Combine Reports by Creating a Dashboard
      1. Example of Creating a Dashboard with Two Reports
      2. Details about Using the Dashboard Builder
      3. Dashboard Builder Red Triangle Options
      4. Sample Dashboards
      5. Edit a Dashboard
        1. Rearrange Reports in Dashboard Edit Mode
        2. Format Text in a Text Box
        3. Preview the Dashboard
      6. View a Running Dashboard
        1. View a Summary of the Report
        2. Rearrange Reports in a Running Dashboard
        3. Maximize a Report in a Running Dashboard
        4. Resize Reports in a Running Dashboard
        5. Share Reports with Users Working Outside JMP
      7. Example of Combining Windows to Create a Dashboard
      8. Example of Adding a Selection Filter to a Dashboard
      9. Example of Creating a JMP Query Dashboard and Add-In
  13. Personalize JMP
    1. Customize Menus and Toolbars
    2. Personalize Toolbars and Menus on Windows
      1. Change Customization Sets
        1. Customization Set Options
      2. Create Toolbars
      3. Create Main Menus
      4. Create Menu Items and Toolbar Buttons
      5. Rearrange Toolbars
      6. Copy and Paste Menus, Menu Items, Toolbars, and Buttons
      7. Rearrange Custom Menus, Menu Items, and Buttons
      8. Delete Custom Items
      9. Show and Hide Items
      10. Import Customizations
      11. Remove Customizations
    3. Personalize Toolbars on Macintosh
    4. Personalize Menu Items on Macintosh
  14. JMP Preferences
    1. The Preferences Window
    2. Overview
    3. General
    4. Reports
    5. Graphs
    6. Styles
    7. Tables
    8. Platforms
      1. Graph Builder Preferences
    9. Print
    10. Text Data Files
    11. Windows Specific
    12. Macintosh OS Settings
    13. Fonts
    14. Communications
    15. File Locations
    16. Script Editor
    17. SAS Integration
    18. JSL Debugger
    19. Menu Preferences
    20. Query Builder
  15. Formula Functions Reference
    1. Descriptions of Functions in the Formula Editor
    2. Row Functions
    3. Numeric Functions
    4. Transcendental Functions
    5. Trigonometric Functions
    6. Character Functions
    7. Character Pattern Functions
    8. Comparison Functions
    9. Conditional Functions
    10. Probability Functions
    11. Discrete Probability Functions
    12. Statistical Functions
    13. Random Functions
    14. Date Time Functions
    15. Row State Functions
    16. Assignment Functions
    17. Parametric Model Functions
    18. Finance Functions
  16. JMP Technical Details
    1. Features That Support Multithreading
    2. Conventions for Mapping JMP Attributes to SAS Extended Attributes
  17. Index
    1. Using JMP