Using JMP 12 by SAS Institute I.n.c. -- Read -- Imperial Library of Trantor

Index

Contents Learn about JMP

Documentation and Additional Resources Formatting Conventions JMP Documentation

JMP Documentation Library Discovering JMP Using JMP Basic Analysis Essential Graphing Profilers Design of Experiments Guide Fitting Linear Models Specialized Models Multivariate Methods Quality and Process Methods Reliability and Survival Methods Consumer Research Scripting Guide JSL Syntax Reference 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

Get Started

Introduction to Basic Features Manage JMP Files and Open Windows

JMP Home Window on Windows

JMP Home Window Buttons Recent Files Window List Projects Rearrange Panels in the Home Window

JMP Home Window on Macintosh

Recent Files Window List

JMP Starter Window JMP Personalization Window 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 Close Multiple Files Display and Arrange Open Windows

Using the Reveal Feature

Preview JMP Files Anatomy of a JMP Session

Import Your Data

Create Data Tables About Importing Data to JMP Import Microsoft Excel Files

Preview and Import the Microsoft Excel Data 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

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 an SQL Database Select Tables from an SQL Database

Edit the Conditions for Joining Tables

Build the SQL Query

Select Columns from the Database Table 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 Preview Options Open a Text File in a Text Editing Window Import Text from the Script Window

Import Remote Files and Web Pages Import SPSS Files 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

Add Rows Add Columns

Adding Multiple 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 Edit Data

Delete Rows and Columns Edit or Delete Cells Edit Column Names View Patterns of Missing Data

Example of Viewing Patterns of Missing Data

Find and Replace Cell Values

Find Window Options Search Actions

Reorder Columns Group Columns Move Values

Move Content into Another Window

Use the Row Editor

Row Editor Buttons Row Editor Options

Context Menus for Rows and Columns

Edit Data Tables

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

Compare Data Tables

Assign Characteristics to Rows and Columns

Hide and Exclude Rows Exclude Rows and Columns Hide 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 New Formula Column Virtual Columns

Transform Menu Combine Menu Aggregate Menu Distributional Menu Date Time Menu Character Menu Row Menu Virtual Column Options

Recode Data

Red Triangle Options for Recode Right-Click Options Grouping Options Example of Grouping Based on Character Difference Example of Grouping Based on Difference Ratio

The Column Info Window

Set Column Attributes and Properties The Column Info Window

About Data Types and Modeling Types The Short-Integer Format Numeric Formats

Specify Width Numeric Format Options International Formats

Row State Columns

Permanently Select Cells

Fill in Initial Data Values

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

Properties That Control How Columns Are Used in Platforms

Distribution Time Frequency Map Role Supercategories Multiple Response Profit Matrix Informative Missing

Additional Properties

Expression Role Other

Properties Assigned and Controlled by JMP

Response Probability Predicting Informative Missing Terms

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

Update Data Tables

Example of Updating a Data Table

Anonymize Data

Formula Editor

Construct Formulas Create a Formula Reference Columns and Table Variables Use Local Variables

Incorporate Parameters

Insert Constants Add Operators

Keypad Reference

Use Functions 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

Change the Font Size Hide and Show Boxing 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 Key

Keyboard Shortcuts Glossary of Terms

Summarize Data

The Table Summarize Command Summarize Columns

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 Platforms

Launch and Report Windows Launch Windows

Cast Selected Columns into Roles Buttons

Columns Filter Menu

Platforms That Support Multithreading Navigating 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

How to Access Analysis Options

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 Animation Save WHERE Clause

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 Property

Format 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 Plots

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

Alter Plot and Chart Appearances

Resize Plots and Graphs

Use Click and Drag Specify Size in Pixels

Zoom In and Out 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 Geographical Images and Boundaries Drag and Drop an Image into a Graph

Image Processing

Extract Data from an Image

Add Graphics Elements to a Report

Annotations Add Shapes

Add a Line Add a Polygon or Bezier Curve Add an Oval or Rectangle

Add Graphics Customize Graphical Elements

Create Scripts for Graphical Elements Change the Drawing Order of Graphical Elements Save Your Customizations Copy Your Customizations

Save and Share Data

Get Your Data Out of JMP Save and Share Data Tables

Save as a Microsoft Excel File

Windows Macintosh

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 E-mail a Data Table

Save and Share Reports

E-mail a Report Save the Report as Interactive HTML

Interactive HTML Contains Data Which Reports Are Supported

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

Personalize JMP

Customize Menus, Toolbars, and Add New Features Personalize Toolbars and Menus on Windows

Change Customization Sets 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 Add-Ins

Manage JMP Add-Ins

Install Add-Ins View Your Add-Ins Update Add-Ins Disable, Enable, and Remove Add-Ins

JMP Preferences

The Preferences Window Overview General Reports Graphs Styles Tables Platforms

Graph Builder Preferences

Print Text Data Files Windows Specific Mac OS Settings Fonts Communications File Locations Script Editor SAS Integration JMP Updates 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

Index

Using JMP Symbols Numerics A B C D E F G H I J K L M N O P Q R S T U V W-Z

← Prev
Back
Next →

← Prev
Back
Next →