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