Home Page Icon
Home Page
Table of Contents for
Row Functions
Close
Row Functions
by SAS Institute
Using JMP 11
Contents
Learn about JMP
Documentation and Additional Resources
Book Conventions
JMP Documentation
JMP Documentation Suite
JMP Help
JMP Books by Users
JMPer Cable
Additional Resources for Learning JMP
Tutorials
The JMP Starter Window
Sample Data Tables
Learn about Statistical and JSL Terms
Learn JMP Tips and Tricks
Tooltips
Access Resources on the Web
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
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 Files
Display and Arrange Open Windows
Using the Reveal Feature
View Preview of Data (Windows Only)
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 (Windows)
Import a Microsoft Excel File Directly
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 SAS
Import SAS Data Sets
Create SAS Transport Files in SAS
Connect to SAS
Connect to a SAS Metadata Server
Connect to a SAS Workspace Server on a Remote Machine
Connect to a SAS Environment (Windows Only)
Connect to SAS on Your Local Machine (Windows Only)
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
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
Uninstall Previous Versions of the Excel Add-In
Import Data from a Database
Open Data from a Database
Retrieve Data Using SQL Statements
Structured Query Language (SQL): A Reference
Use the SELECT Statement
Sort Results
Use the WHERE Statement
Use the IN and BETWEEN Statements
Use the LIKE Statement
Use Aggregate Functions
The GROUP BY and HAVING Commands
Use Subqueries
Save and Load SQL Queries
Use the WHERE Clause Editor
Read in Real-Time Data
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
Select Cells
Edit Data
Delete Rows and Columns
Edit or Delete Cells
Edit Column Names
Recode Data
Red Triangle Options for Recode
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
Make Binning Formula
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
Set Column Properties
The Column Info Window
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
Assign Column Properties
Formula
Notes
Range Check
List Check
Missing Value Codes
Value Labels
Value Scores
Value Ordering
Value Colors
Create a Custom Color Theme
Macros Options
Color Gradient
Axis
Coding
Mixture
Row Order Levels
Spec, Control, and Response Limits
Design Role
Factor Changes
Sigma
Units
Distribution
Time Frequency
Map Role
Supercategories
Multiple Response
Profit Matrix
Create Your Own Column Property
Response Probability
Standardize Attributes and Properties across Columns
Recode Values
Standardize Attributes
Standardize Properties
Delete Properties
Example of Standardizing a Formula
Assign a Preselected Analysis Role
Compress Selected Columns
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
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 a Formula’s Orientation
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
Virtual Columns
Transform Menu
Combine Menu
Aggregate Menu
Date Time Menu
Character Menu
Row Menu
Formula Menu
Virtual Column Options
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
Turn a Report Table Into a Matrix
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 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
Establish the Minimum and Maximum Axis Values
Change the Axis Scale Type
Change the Orientation for Tick Labels
Change the Axis Increments
Add and Remove Axis Labels
Change the Numeric Format of an Axis
Change Axis Label Font
Rotate Axis Labels
Copy and Paste Graph Contents
Copy and Paste Axis Settings
Change the Order of Values
Customize Tick Marks and Tick Mark Labels
Add Tick Marks, Grid Lines, or Labels
Add Minor Tick Marks
Adjust the Field Width of Labels
Change Tick Mark Label Font Types and Sizes
Rotate Tick Mark Labels
Extend Divider Lines and Frames for Categorical Axes
Add Reference Lines
Add Geographical Images and Boundaries
Drag and Drop an Image into a Graph
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 CSV File
Save as a Text File
Save as a SAS Transport File
Windows
Macintosh
Save as a SAS Data Set
Windows
Macintosh
Save as a Microsoft Excel File
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 Flash
Setting the 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
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
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
Scripting-Only Preferences
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
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
Formula Functions Reference
Next
Next Chapter
Row Functions
Contents
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
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