Using JMP 12

Using JMP 12

by SAS Institute
Released March 2015
Publisher(s): SAS Institute
ISBN: 9781629594804

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Using JMP 12 covers the initial types of analyses that you often perform in JMP, such as univariate, bivariate, and oneway analyses. Creating tables of summary statistics with the Tabulate platform is included along with approximating sampling distributions using bootstrapping. Find information about how to clean up your data before performing analyses.

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. Discovering JMP
      3. Using JMP
      4. Basic Analysis
      5. Essential Graphing
      6. Profilers
      7. Design of Experiments Guide
      8. Fitting Linear Models
      9. Specialized Models
      10. Multivariate Methods
      11. Quality and Process Methods
      12. Reliability and Survival Methods
      13. Consumer Research
      14. Scripting Guide
      15. JSL Syntax Reference
      16. 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
  3. Get Started
    1. Introduction to Basic Features
    2. Manage JMP Files and Open Windows
      1. JMP Home Window on Windows
        1. JMP Home Window Buttons
        2. Recent Files
        3. Window List
        4. Projects
        5. Rearrange Panels in the Home Window
      2. JMP Home Window on Macintosh
        1. Recent Files
        2. Window List
    3. JMP Starter Window
    4. JMP Personalization Window
    5. 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
    6. Open Data File Options
    7. Close Multiple Files
    8. Display and Arrange Open Windows
      1. Using the Reveal Feature
    9. Preview JMP Files
    10. Anatomy of a JMP Session
  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
      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. Run Stored Processes
      7. Submit SAS Code
      8. Generate ODS Results
      9. Retrieve Generated SAS Data Sets
        1. Export JMP Data Tables to SAS
    5. Build SQL Queries in Query Builder
      1. Connect to an SQL Database
      2. Select Tables from an SQL Database
        1. Edit the Conditions for Joining Tables
      3. Build the SQL Query
        1. Select Columns from the Database Table
        2. Group the Common Values
        3. Import a Sample of the Data
        4. Select Filters to Import a Subset of the Data
        5. Import Matching Data from an Existing Data Table
        6. Write a Custom Expression to Import a Subset of the Data
        7. Sort the Selected Data
        8. View the Query Status
        9. 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 Preview Options
      2. Open a Text File in a Text Editing Window
      3. Import Text from the Script Window
    8. Import Remote Files and Web Pages
    9. Import SPSS Files
    10. Import Data from R
    11. 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
    12. Create New Data Tables
  5. Enter and Edit Data
    1. Perform Basic Data Table Tasks
    2. Enter Data
      1. Add Rows
      2. Add Columns
        1. Adding Multiple Columns
      3. Fill Columns with Sequential Data
        1. Fill Options
      4. 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. Edit Data
      1. Delete Rows and Columns
      2. Edit or Delete Cells
      3. Edit Column Names
      4. View Patterns of Missing Data
        1. Example of Viewing Patterns of Missing Data
      5. Find and Replace Cell Values
        1. Find Window Options
        2. Search Actions
      6. Reorder Columns
      7. Group Columns
      8. Move Values
        1. Move Content into Another Window
      9. Use the Row Editor
        1. Row Editor Buttons
        2. Row Editor Options
      10. Context Menus for Rows and Columns
    7. Edit Data Tables
      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. Compare Data Tables
    8. Assign Characteristics to Rows and Columns
      1. Hide and Exclude Rows
      2. Exclude Rows and Columns
      3. Hide Rows and Columns
      4. Label Rows and Columns
      5. 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
      6. Create Color Themes
        1. Continuous and Categorical Color Themes
        2. Custom Color Themes
      7. Delete Custom Color Themes
      8. Delete Row Characteristics
      9. 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 New Formula Column
      7. Virtual Columns
        1. Transform Menu
        2. Combine Menu
        3. Aggregate Menu
        4. Distributional Menu
        5. Date Time Menu
        6. Character Menu
        7. Row Menu
        8. Virtual Column Options
      8. Recode Data
        1. Red Triangle Options for Recode
        2. Right-Click Options
        3. Grouping Options
        4. Example of Grouping Based on Character Difference
        5. Example of Grouping Based on Difference Ratio
  6. The Column Info Window
    1. Set Column Attributes and Properties
    2. The Column Info Window
      1. About Data Types and 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. Fill in Initial Data Values
    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
      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. Additional Properties
        1. Expression Role
        2. Other
      9. Properties Assigned and Controlled by JMP
        1. Response Probability
        2. Predicting
        3. Informative Missing Terms
    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. Update Data Tables
      1. Example of Updating a Data Table
    10. Anonymize Data
  8. Formula Editor
    1. Construct Formulas
    2. Create a Formula
    3. Reference Columns and Table Variables
    4. Use Local Variables
      1. Incorporate Parameters
    5. Insert Constants
    6. Add Operators
      1. Keypad Reference
    7. Use Functions
    8. Order Expressions in Formulas
      1. Build a Formula in Order of Precedence
        1. Structure Formulas for Efficient Evaluation
    9. 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
    10. Edit Formulas
      1. Correct Mistakes
      2. Select Expressions
      3. Delete Functions
      4. Cut, Copy, and Paste
      5. Click and Drag
    11. Customize Formulas
      1. Change the Font Size
      2. Hide and Show Boxing
      3. Change the Orientation of a Formula
      4. Open and Close Arguments
    12. 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 Key
    13. Keyboard Shortcuts
    14. Glossary of Terms
  9. Summarize Data
    1. The Table Summarize Command
    2. Summarize Columns
      1. 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
      2. Add a Statistics Column to an Existing Summary Table
    3. Explanation of Statistics
    4. Example of Creating a Summary Table
  10. JMP Platforms
    1. Launch and Report Windows
    2. Launch Windows
      1. Cast Selected Columns into Roles Buttons
        1. Columns Filter Menu
    3. Platforms That Support Multithreading
    4. Navigating 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
    5. How to Access Analysis Options
      1. Script Menus
        1. Automatic Recalc
        2. Column Switcher
    6. 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
        2. Animation
        3. Save WHERE Clause
      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 Property
    7. Format 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
    8. Select Points in Plots
      1. Select Rows in Graphs
      2. Select a Rectangular Area of Points
      3. Select an Irregular-Shaped Area of Points
    9. 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
    10. Alter Plot and Chart Appearances
      1. Resize Plots and Graphs
        1. Use Click and Drag
        2. Specify Size in Pixels
      2. Zoom In and Out
      3. Change Line Widths
      4. Change the Background Color in a Graph
      5. Change the Color of Histogram Bars
      6. Display Coordinates and Temporary Reference Lines
      7. Scroll and Scale Axes
      8. Customize Axes and Axis Labels in the Axis Settings Window
        1. Scale
        2. Tick/Bin Increment
        3. Axis Label Row
        4. Reference Lines
      9. 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
      10. Change the Order of Values
      11. Change the Pattern and Format of Selected Objects
      12. Add Geographical Images and Boundaries
      13. Drag and Drop an Image into a Graph
        1. Image Processing
      14. Extract Data from an Image
    11. Add Graphics Elements to a Report
      1. Annotations
      2. Add Shapes
        1. Add a Line
        2. Add a Polygon or Bezier Curve
        3. Add an Oval or Rectangle
      3. Add Graphics
      4. 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
  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. Windows
        2. Macintosh
      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. E-mail a Data Table
    3. Save and Share Reports
      1. E-mail a Report
      2. Save the Report as Interactive HTML
        1. Interactive HTML Contains Data
        2. Which Reports Are Supported
      3. Save as PowerPoint
        1. Custom PowerPoint Templates
      4. Save as Flash
      5. 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. Personalize JMP
    1. Customize Menus, Toolbars, and Add New Features
    2. Personalize Toolbars and Menus on Windows
      1. Change Customization Sets
      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
    5. JMP Add-Ins
      1. Manage JMP Add-Ins
        1. Install Add-Ins
        2. View Your Add-Ins
        3. Update Add-Ins
        4. Disable, Enable, and Remove Add-Ins
  13. 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. Mac OS Settings
    13. Fonts
    14. Communications
    15. File Locations
    16. Script Editor
    17. SAS Integration
    18. JMP Updates
    19. JSL Debugger
    20. Menu Preferences
    21. Query Builder
  14. 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
  15. Index
    1. Using JMP
    2. Symbols
    3. Numerics
    4. A
    5. B
    6. C
    7. D
    8. E
    9. F
    10. G
    11. H
    12. I
    13. J
    14. K
    15. L
    16. M
    17. N
    18. O
    19. P
    20. Q
    21. R
    22. S
    23. T
    24. U
    25. V
    26. W-Z

Product information

  • Title: Using JMP 12
  • Author(s): SAS Institute
  • Release date: March 2015
  • Publisher(s): SAS Institute
  • ISBN: 9781629594804