book

Using JMP 13

Name: Using JMP 13
Author: SAS Institute
ISBN: 9781629605647

by SAS Institute

September 2016

Intermediate to advanced

630 pages

15h 41m

English

SAS Institute

Read now

Unlock full access

Contents
Learn about JMP
Documentation and Additional Resources
Formatting Conventions
JMP DocumentationJMP Documentation LibraryJMP HelpAdditional Resources for Learning JMPTutorialsSample Data TablesLearn about Statistical and JSL TermsLearn JMP Tips and TricksTooltipsJMP User CommunityJMPer CableJMP Books by UsersThe JMP Starter WindowTechnical Support
Get Started
Introduction to Basic Features
Anatomy of a JMP Session
Data TablesData Table PanelsTable PanelColumns PanelRows PanelData GridContext Menu for ColumnsContext Menu for RowsCursor FormsOpen Data File Options
Platforms
Launch WindowsCast Selected Columns into Roles ButtonsReportsManage JMP Files and Open WindowsJMP Home Window on WindowsJMP Home Window ButtonsRecent FilesWindow ListRearrange Panels in the Home WindowJMP Home Window on MacintoshRecent FilesWindow ListSearch for Recently Opened Files on WindowsClose Multiple FilesDisplay and Arrange Open WindowsPreview JMP FilesUsing the Reveal FeatureJMP Starter Window
Import Your Data
Create Data Tables
About Importing Data to JMP
Import Microsoft Excel FilesPreview and Import the Microsoft Excel DataImporting a Microsoft Excel File with Hierarchical HeadingsImport a Microsoft Excel File DirectlyImport Data from SASImport SAS Data SetsCreate SAS Transport Files in SASConnect to SASConnect to a SAS Metadata ServerConnect to a Remote SAS Workspace ServerConnect to a SAS Environment (Windows Only)Connect to SAS on Your Local Machine (Windows Only)Open SAS Data Sets with SAS Query BuilderOpen SAS Data Sets through a SAS ServerBrowse SAS Data InformationOpen a SAS Data Set in JMPImport a Sample of a SAS Data SetOpen Password-Protected Data SetsUsing SAS Extended Attributes to Import MetadataRun Stored ProcessesSubmit SAS CodeGenerate ODS ResultsRetrieve Generated SAS Data SetsExport JMP Data Tables to SASBuild SQL Queries in Query BuilderConnect to a SQL DatabaseSelect Tables from a SQL DatabaseEdit the Conditions for Joining TablesBuild the SQL QuerySelect Columns from the Database TableMaintain Compatibility with JMP 12Create a Computed ColumnGroup the Common ValuesImport a Sample of the DataSelect Filters to Import a Subset of the DataImport Matching Data from an Existing Data TableWrite a Custom Expression to Import a Subset of the DataSort the Selected DataView the Query StatusWrite a Post-Query ScriptSave and Run the QueryOpen the Selected Data in JMPQuery Builder Red Triangle OptionsWrite SQL Statements in Query BuilderImport Data from a DatabaseConnect to a DatabaseOpen Data from a DatabaseWrite SQL Statements to Query a DatabaseStructured Query Language (SQL): A ReferenceUse the WHERE Clause EditorImport Text FilesText Import Wizard OptionsOpen a Text File in a Text Editing WindowImport Text from the Script EditorImport Data from the Internet or a Remote ComputerImport SPSS FilesImport Triple-S Survey DataImport HDF5 DataImport JSON FilesImport Data from MATLABImport Data from RImport Data Using the Excel Add-InTransfer Excel Data to a JMP Data TableAbout the JMP Add-In for ExcelUninstall the Excel Add-InCreate New Data Tables
Enter and Edit Data
Perform Basic Data Table Tasks
Enter Data
Copy and Paste DataAdd RowsAdd ColumnsFill Columns with Sequential DataFill OptionsEnter Cell FormulasSelect RowsLocate Next and Previously Selected RowsSelect ColumnsSelect Columns in a Data TableSelect Columns in the Columns ViewerLocate Next and Previously Selected ColumnsSelect CellsResize Rows and ColumnsOrganize DataDelete Rows and ColumnsRearrange ColumnsGroup ColumnsMove ValuesMove Content into Another WindowColor CellsEdit or Delete CellsEdit Column NamesHide and Exclude RowsExclude RowsHide RowsExclude ColumnsHide ColumnsView Patterns of Missing DataExample of Viewing Patterns of Missing DataFind and Replace Cell ValuesFind Window OptionsSearch ActionsUse the Row Editor to Edit Cells in a RowRow Editor ButtonsRow Editor OptionsContext Menus for Rows and ColumnsCompare Data TablesAssign Characteristics to Rows and ColumnsLabel Rows and ColumnsAssign Colors or Markers to RowsAssign a Color to RowsAdd Markers to RowsAssign Colors or Markers to Rows Based on Column ValuesCreate Color ThemesContinuous and Categorical Color ThemesCustom Color ThemesDelete Custom Color ThemesDelete Row CharacteristicsLock Columns in PlaceRestructure DataMake a Column into Multiple ColumnsMake Indicator ColumnsCombine ColumnsCompress Selected ColumnsMake Binning FormulaMake a New Formula ColumnTransform ColumnsTransform MenuCombine MenuAggregate MenuDistributional MenuDate Time MenuCharacter MenuRow MenuTransform Column OptionsRecode DataRed Triangle Options for RecodeRight-Click Options for RecodeGrouping Options for RecodeExample of Grouping Based on Character DifferenceExample of Grouping Based on Difference RatioEdit the Data TableChange Table NamesLock TablesCompress TablesUse Table VariablesUses for Table VariablesTable Variable ActionsConcatenating Data Tables with Table VariablesCreate and Save ScriptsSave a Report Script to a Data TableWrite a JSL Script for the Data TableRun, Edit, Delete, or Copy Scripts

The Column Info Window
Set Column Attributes and Properties
About the Column Info Window
About Modeling TypesThe Short-Integer FormatNumeric FormatsSpecify WidthNumeric Format OptionsInternational FormatsRow State ColumnsPermanently Select CellsInitialize DataColumn PropertiesBasic Column PropertiesFormulaNotesProperties That Validate Column ValuesRange CheckList CheckMissing Value CodesProperties That Attach Information to Column ValuesValue LabelsValue ScoresValue OrderingRow Order LevelsValue ColorsColor GradientProperties That Control the Display of ColumnsAxisUnitsProperties Used in Modeling and DOEResponse LimitsDesign RoleCodingMixtureFactor ChangesProperties Associated with Control Charts and CapabilitySpec LimitsControl LimitsSigmaProcess Capability DistributionProperties That Control How Columns Are Used in PlatformsDistributionTime FrequencyMap RoleSupercategoriesMultiple ResponseProfit MatrixInformative MissingVirtual Join PropertiesLink IDLink ReferenceAdditional PropertiesExpression RoleOtherProperties Assigned and Controlled by JMPResponse ProbabilityPredictingInformative Missing TermsColumn IDStandardize Attributes and Properties Across ColumnsRecode ValuesStandardize AttributesStandardize PropertiesDelete PropertiesExample of Standardizing a FormulaAssign a Preselected Analysis Role
Reshape Data
Create Subsets, Sort Data, and More
Create a Subset Data Table
Stratified SubsetsCreate a Subset Data Table from a ReportSort Data TablesStack ColumnsExample of Stacking into One ColumnExample of Stacking into More Than One ColumnSplit ColumnsExamples of Splitting ColumnsSplit a Column: Basic ExampleSplit a Column: Grouping Rows ExampleTranspose Rows and ColumnsExamples of Transposing Rows and ColumnsConcatenate Data TablesExample of Concatenating Data TablesExample of Concatenating Data Tables and Table VariablesJoin Data TablesExamples of Joining Data TablesExample of Joining by Row NumberExamples of a Cartesian JoinExamples of Joining By Matching ColumnsQuery and Join Data Tables with JMP Query BuilderAbout Links to Data Tables in JMP QueriesVirtually Join Data TablesUpdate Data TablesExample of Updating a Data TableAnonymize Data
Formula Editor
Construct Formulas
Formula Overview
Create a FormulaRefer to Values in Columns and Table VariablesUse Local VariablesIncorporate ParametersInsert ConstantsAdd OperatorsKeypad ReferenceUse Functions in a FormulaOrder Expressions in FormulasBuild a Formula in Order of PrecedenceStructure Formulas for Efficient EvaluationUse Formula Editor OptionsCalculate DerivativesSimplify Complex FormulasEvaluate FormulasSuppress EvaluationIgnore ErrorsView a Formula’s Values from the Formula EditorView a Formula in JSLEdit FormulasCorrect MistakesSelect ExpressionsDelete FunctionsCut, Copy, and PasteClick and DragCustomize FormulasHide and Show BoxingChange the Font SizeSpecify the Matrix SizeChange the Orientation of a FormulaOpen and Close ArgumentsExamples and TutorialsUse Basic Formula Editor FeaturesUse Local Variables in a FormulaUse the Munger FunctionInsert CharactersDelete CharactersFind the Position (Index) of a ValueFind a SubstringUse the Match Conditional FunctionUse the Delete Expression ButtonKeyboard ShortcutsGlossary of Terms
Summarize Data
The Table Summary Command
Summarize Columns
Launch Window RolesCreate a Summary TableAdd Summary StatisticsUse One or More Grouping ColumnsUse Quantile StatisticsChange the Format of the Statistics Column NameLink to the Original Data TableKeep the Summary Window OpenCreate a Two-Way Table of Summary Statistics by Adding a Subgroup VariableAdd a Statistics Column to an Existing Summary TableExplanation of StatisticsExample of Creating a Summary Table
JMP Reports
Navigate and Customize Report Windows
Navigate Reports
Use the Hand ToolAccess Report Display OptionsShow and Hide Parts of a ReportCombine Several ReportsRename a TitleIncrease Font SizesResize a WindowRed Triangle Options in a ReportLocal Data FilterRedo MenusSave Script MenusAutomatic RecalcColumn SwitcherThe Data FilterTypes of Filter ColumnsFiltering ModesThe Data Filter Control PanelChanging the Row State in the Data Table After Making Data Filter SelectionsRed Triangle Options for the Data FilterConditional Data FiltersGrouped by AND in Data FiltersAnimation in Data FiltersSave WHERE Clause in Data FiltersRed Triangle Options for VariablesOptions for All Types of VariablesOptions for Continuous VariablesOptions for Nominal or Ordinal VariablesOptions for Variables with the Multiple Response Modeling Type or Column PropertyReformat Report TablesModify Display Box Properties in a ReportTurn a Report Table Into a MatrixUse Conditional FormattingDisable or Enable a RuleAdd a RuleEdit a RuleSelect Points in GraphsSelect Rows in GraphsSelect a Rectangular Area of PointsSelect an Irregular-Shaped Area of PointsUse MarkersChange Marker ShapeChange Marker ColorsChange Marker SizeChange the Marker Drawing Mode and TransparencyAdd Outlines Around MarkersMarker Selection ModesSpecify Marker TransparencyExclude and Hide MarkersAdd Labels to MarkersChange Marker Shape or Colors Based On ValuesRemove the Row LegendChange the Appearance of GraphsResize GraphsUse Click and DragSpecify Size in PixelsZoom In and OutPin Hover Labels on a GraphChange Line WidthsChange the Background Color in a GraphChange the Color of Histogram BarsDisplay Coordinates and Temporary Reference LinesScroll and Scale AxesCustomize Axes and Axis Labels in the Axis Settings WindowScaleTick/Bin IncrementAxis Label RowReference LinesCustomize Axes and Axis Labels Using the Right-Click MenuExtend Divider Lines and Frames for Categorical AxesAdd and Remove Axis LabelsRotate Axis Labels and Tick MarksCopy and Paste Graph ContentsCopy and Paste Axis SettingsChange the Order of ValuesChange the Pattern and Format of Selected ObjectsAdd a Graph to a Data TableCustomize Graphical ElementsCreate Scripts for Graphical ElementsChange the Drawing Order of Graphical ElementsSave Your CustomizationsCopy Your CustomizationsAdd Images to a Graph or ReportPaste a Background Image into a GraphPaste an Image at the End of a ReportDrag and Drop an Image into a GraphImage ProcessingAdd Geographical Images and BoundariesExtract Data from an ImageAdd Annotations and Shapes to a ReportAdd AnnotationsAdd ShapesAdd a LineAdd a Polygon or Bezier CurveAdd an Oval or Rectangle
Save and Share Data
Get Your Data Out of JMP
Save and Share Data Tables
Save as a Microsoft Excel FileSave One Data Table as a Microsoft Excel WorkbookSave Multiple Data Tables as a Microsoft Excel WorkbookSave as a CSV FileSave as a Text FileWindowsMacintoshSave as a SAS Transport FileWindowsMacintoshSave as a SAS Data SetWindowsMacintoshSave Data Tables to a DatabaseReplace a Database with a Data TableEmail a Data TableSave and Share ReportsEmail a ReportSave the Report as Interactive HTMLInteractive HTML Contains DataWhich Reports Are SupportedCreate a Web ReportWeb Report OptionsSave as PowerPointCustom PowerPoint TemplatesSave as FlashSetting the Graphic DPISave Your Analysis as a ScriptSave Using the Layout CommandSave Parts of a Report in a Graphic FormatPrint ReportsCopy and Paste ReportsJMP JournalsCreate a New JournalPrevent ModificationsAppend Reports to a JournalAdd and Edit Outline LevelsControl the Display of Outline LevelsAdd a Graph or GraphicCustomize Journal ItemsSave the Journal in Another FormatWindowsMacintoshPrint a JournalDelete Items from a JournalExample of Making a Journal for a PresentationSave JMP SessionsSave Sessions upon ExitingSave Sessions ManuallyJMP Projects (Windows Only)Create a JMP ProjectSave a JMP ProjectClose a JMP ProjectOpen a JMP ProjectAdd Items to a JMP ProjectProject MenuDrag and Drop FilesCustomize the ProjectOpen FilesGroupsNotesFix Broken LinksSave a Log Window
Extend JMP
Create Dashboards
Combine Reports by Creating a Dashboard
Example of Creating a Dashboard with Two ReportsDetails about Using the Dashboard BuilderDashboard Builder Red Triangle OptionsSample DashboardsEdit a DashboardRearrange Reports in Dashboard Edit ModeFormat Text in a Text BoxPreview the DashboardView a Running DashboardView a Summary of the ReportRearrange Reports in a Running DashboardMaximize a Report in a Running DashboardResize Reports in a Running DashboardShare Reports with Users Working Outside JMPExample of Combining Windows to Create a DashboardExample of Adding a Selection Filter to a DashboardExample of Creating a JMP Query Dashboard and Add-In
Personalize JMP
Customize Menus and Toolbars
Personalize Toolbars and Menus on Windows
Change Customization SetsCustomization Set OptionsCreate ToolbarsCreate Main MenusCreate Menu Items and Toolbar ButtonsRearrange ToolbarsCopy and Paste Menus, Menu Items, Toolbars, and ButtonsRearrange Custom Menus, Menu Items, and ButtonsDelete Custom ItemsShow and Hide ItemsImport CustomizationsRemove CustomizationsPersonalize Toolbars on MacintoshPersonalize Menu Items on Macintosh
JMP Preferences
The Preferences Window
Overview
GeneralReportsGraphsStylesTablesPlatformsGraph Builder PreferencesPrintText Data FilesWindows SpecificMacintosh OS SettingsFontsCommunicationsFile LocationsScript EditorSAS IntegrationJSL DebuggerMenu PreferencesQuery Builder
Formula Functions Reference
Descriptions of Functions in the Formula Editor
Row Functions
Numeric FunctionsTranscendental FunctionsTrigonometric FunctionsCharacter FunctionsCharacter Pattern FunctionsComparison FunctionsConditional FunctionsProbability FunctionsDiscrete Probability FunctionsStatistical FunctionsRandom FunctionsDate Time FunctionsRow State FunctionsAssignment FunctionsParametric Model FunctionsFinance Functions
JMP Technical Details
Features That Support Multithreading
Conventions for Mapping JMP Attributes to SAS Extended Attributes
Index
Using JMP

Content preview from Using JMP 13

Create a Subset Data Table

You can produce a new data table that is a subset of all rows and columns, only highlighted rows and columns, or randomly selected rows from the active data table.

To create a subset

1. Select Tables > Subset.

Figure 6.2 The Subset Window

2. Specify the content that you want to subset. Select any combination of the following:

‒ Subset by (the levels within selected columns)

‒ Rows (all, selected, or random)

‒ Columns (all or selected)

In Figure 6.2, the sex column will be subset.

3. Customize your subset table further using the additional options.

4. Click OK to create the subset table.

Subset Options

Subset by

Subsets ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781629605647

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Using JMP 13

by SAS Institute

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.