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

Book Description

Using JMP 11 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. Book Conventions
    3. JMP Documentation
      1. JMP Documentation Suite
      2. JMP Help
      3. JMP Books by Users
      4. JMPer Cable
    4. Additional Resources for Learning JMP
      1. Tutorials
      2. The JMP Starter Window
      3. Sample Data Tables
      4. Learn about Statistical and JSL Terms
      5. Learn JMP Tips and Tricks
      6. Tooltips
      7. Access Resources on the Web
  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
    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 Files
    7. Display and Arrange Open Windows
      1. Using the Reveal Feature
    8. View Preview of Data (Windows Only)
    9. 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 (Windows)
      2. Import a Microsoft Excel File Directly
    4. 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
    5. Import Remote Files and Web Pages
    6. Import SPSS Files
    7. 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 SAS Workspace Server on a Remote Machine
        3. Connect to a SAS Environment (Windows Only)
        4. Connect to SAS on Your Local Machine (Windows Only)
      4. 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
      5. Run Stored Processes
      6. Submit SAS Code
      7. Generate ODS Results
      8. Retrieve Generated SAS Data Sets
        1. Export JMP Data Tables to SAS
    8. Import Data from R
    9. 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
      4. Uninstall Previous Versions of the Excel Add-In
    10. Import Data from a Database
      1. Open Data from a Database
      2. Retrieve Data Using SQL Statements
      3. Structured Query Language (SQL): A Reference
        1. Use the SELECT Statement
        2. Sort Results
        3. Use the WHERE Statement
        4. Use the IN and BETWEEN Statements
        5. Use the LIKE Statement
        6. Use Aggregate Functions
        7. The GROUP BY and HAVING Commands
        8. Use Subqueries
        9. Save and Load SQL Queries
      4. Use the WHERE Clause Editor
    11. Read in Real-Time Data
    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
    5. Select Cells
    6. Edit Data
      1. Delete Rows and Columns
      2. Edit or Delete Cells
      3. Edit Column Names
      4. Recode Data
        1. Red Triangle Options for Recode
      5. View Patterns of Missing Data
        1. Example of Viewing Patterns of Missing Data
      6. Find and Replace Cell Values
        1. Find Window Options
        2. Search Actions
      7. Reorder Columns
      8. Group Columns
      9. Move Values
        1. Move Content into Another Window
      10. Use the Row Editor
        1. Row Editor Buttons
        2. Row Editor Options
      11. Context Menus for Rows and Columns
      12. Make Binning Formula
    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
  6. Set Column Properties
    1. The Column Info Window
    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. Assign Column Properties
      1. Formula
      2. Notes
      3. Range Check
      4. List Check
      5. Missing Value Codes
      6. Value Labels
      7. Value Scores
      8. Value Ordering
      9. Value Colors
        1. Create a Custom Color Theme
        2. Macros Options
      10. Color Gradient
      11. Axis
      12. Coding
      13. Mixture
      14. Row Order Levels
      15. Spec, Control, and Response Limits
      16. Design Role
      17. Factor Changes
      18. Sigma
      19. Units
      20. Distribution
      21. Time Frequency
      22. Map Role
      23. Supercategories
      24. Multiple Response
      25. Profit Matrix
      26. Create Your Own Column Property
      27. Response Probability
    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
    6. Compress Selected Columns
  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
  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 a Formula’s Orientation
      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
      2. Virtual Columns
        1. Transform Menu
        2. Combine Menu
        3. Aggregate Menu
        4. Date Time Menu
        5. Character Menu
        6. Row Menu
        7. Formula Menu
        8. Virtual Column Options
    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. Turn a Report Table Into a Matrix
    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 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
        1. Establish the Minimum and Maximum Axis Values
        2. Change the Axis Scale Type
        3. Change the Orientation for Tick Labels
        4. Change the Axis Increments
        5. Add and Remove Axis Labels
        6. Change the Numeric Format of an Axis
        7. Change Axis Label Font
        8. Rotate Axis Labels
        9. Copy and Paste Graph Contents
        10. Copy and Paste Axis Settings
      9. Change the Order of Values
      10. Customize Tick Marks and Tick Mark Labels
        1. Add Tick Marks, Grid Lines, or Labels
        2. Add Minor Tick Marks
        3. Adjust the Field Width of Labels
        4. Change Tick Mark Label Font Types and Sizes
        5. Rotate Tick Mark Labels
        6. Extend Divider Lines and Frames for Categorical Axes
      11. Add Reference Lines
      12. Add Geographical Images and Boundaries
      13. Drag and Drop an Image into a Graph
      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 CSV File
      2. Save as a Text File
      3. Save as a SAS Transport File
        1. Windows
        2. Macintosh
      4. Save as a SAS Data Set
        1. Windows
        2. Macintosh
      5. Save as a Microsoft Excel File
        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 Flash
      4. Setting the 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
      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. 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. Scripting-Only Preferences
  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