book

JMP 11 Scripting Guide

Name: JMP 11 Scripting Guide
Author: SAS Institute
ISBN: 9781612906799

by SAS Institute

September 2013

Intermediate to advanced

652 pages

15h 5m

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 Window
Introduction
Welcome to the JMP Scripting Language
What JSL Can Do for You
Help with Learning JSLThe Scripting GuideThe Scripting IndexLet JMP Teach You JSLTerminologyBasic JSL Syntax
Getting Started
Let JMP Write Your Scripts
Capturing a Script for an Analysis Report
Capturing a Script for a Data TableCapturing a Script to Import a FileGluing Scripts Together
Scripting Tools
Using the Script Editor, Log Window, Debugger and Profiler
Using the Script Editor
Run a ScriptColor CodingAuto Complete FunctionsTooltipsSplit a WindowMatch Parentheses, Brackets, and BracesSelect a Block of TextDrag and Drop TextFind and ReplaceAutomatic FormattingAdd Code Folding MarkersAdd More Folding KeywordsAdvanced OptionsSet Preferences for the Script EditorWorking with the LogShow the Log in the Script WindowSave the LogDebug or Profile ScriptsDebugger and Profiler WindowUsing the Execution ButtonsVariable ListsDebugger OptionsWork with BreakpointsCreate a BreakpointDelete BreakpointsDisable and Enable BreakpointsSpecify and Clear Conditional Expressions on BreakpointsSpecify Break OptionsRun the Script to the CursorTips for Setting BreakpointsView VariablesTips for Managing VariablesWork with WatchesModify Preferences in DebuggerPersistent Debugger SessionsExamples of Debugging and Profiling ScriptsUsing Breakpoints and Watching Global VariablesStepping Into, Over, and OutWatching Variables in Different Scopes and NamespacesUsing the Debugger with Interactive ScriptsUsing the JSL Profiler
JSL Building Blocks
Learning the Basics of JSL

JSL Syntax Rules
Value SeparatorsCommasParenthesesSemicolonsDouble QuotesSpacesNumbersNamesCommentsOperatorsGlobal and Local VariablesShow Symbols, Clear Symbols, and Delete SymbolsLock and Unlock SymbolsAlternatives for Gluing Expressions TogetherIterateForWhileSummationProductBreak and ContinueBreakContinueConditional FunctionsIfMatchChooseInterpolateStepCompare Incomplete or Mismatched DataMissing Numeric ValuesMissing Character ValuesInquiry FunctionsGeneral Element TypesSpecific Element TypesObject AttributesHost InformationVersion InformationName ResolutionScoping OperatorsScoping Data Table ColumnsUnscoped Table Column NamesSet the Current Data Table RowFrequently Asked Questions
Types of Data
Working with Numbers, Strings, Dates, Currency, and More
Numbers and Strings
Path VariablesCreate and Customize Path VariablesRelative PathsFile Path SeparatorsDate-Time Functions and FormatsDate-Time ValuesProgram with Date-Time FunctionsExamples of Common Date-Time FunctionsExtract Parts of DatesArithmetic on DatesTime IntervalsTwo- and Four-Digit YearsDate-Time Values in Data TablesChange Date-Time Input and Display FormatsCurrencyHexadecimal and BLOB FunctionsWork with Character FunctionsConcatMungerRepeatUse Pattern Matching and Regular ExpressionsPatterns and CaseRegular Expressions
Data Structures
Working with Collections of Data
Lists
Evaluate ListsAssignments with ListsPerform Operations in ListsFind the Number of Items in a ListSubscriptsLocate Items in a ListList OperatorsIterate through a ListMatricesConstruct MatricesConstruct Matrices from ListsConstruct Matrices from ExpressionsSubscriptsSingle ElementMatrix or List SubscriptsSingle SubscriptsDelete Rows and ColumnsSelect Whole Rows or ColumnsAssignment through SubscriptsOperator AssignmentRanges of Rows or ColumnsInquiry FunctionsComparisons, Range Checks, and Logical OperatorsNumeric OperationsBasic ArithmeticNumeric (Scalar) Functions on MatricesConcatenationTransposeMatrices and Data TablesMove Data into a Matrix from a Data TableMove Data into a Data Table from a MatrixSummarize ColumnsMatrices and ReportsLoc() FunctionsLoc()Loc Nonmissing()Loc Min() and Loc Max()Loc Sorted()Ranking and SortingSpecial MatricesConstruct an Identity MatrixConstruct a Matrix with Specific ValuesCreate a Diagonal MatrixCreate a Column Vector from Diagonal ElementsCalculate Diagonal Quadratic FormsReturn the Sum of Diagonal ElementsGenerate a Row Vector of IntegersReshape a MatrixCreate Design MatricesFind the Direct ProductInverse Matrices and Linear SystemsInverse or InvGInverseSolveSweepDeterminantDecompositions and NormalizationsEigenvaluesCholesky DecompositionSingular Value DecompositionOrthonormalizationOrthogonal PolynomialsQR DecompositionUpdate Inverse MatricesBuild Your Own Matrix OperatorsStatistical ExamplesRegression ExampleANOVA ExampleAssociative ArraysCreate Associative ArraysWork with Associative ArraysFind the Number of KeysAdd and Delete Keys and ValuesFind Keys or Values in an Associative ArrayIterate through an Associative ArrayApplications for Associative ArraysAssociative Arrays in Graph TheoryAssociative Arrays in Set Operations
Programming Methods
Complex Scripting Techniques and Additional Functions
Lists and Expressions
Stored expressionsQuoting and unquoting expressionsQuote an expression as a stringStore scripts in global variablesRetrieve a stored expression, not its resultMaking lots of substitutionsEvaluate expressions inside listsEvaluate expressions inside expressionsParsing strings into expressions, and vice versaSummaryMacrosManipulating listsIn-place operatorsNot in-place operatorsSubstitutingManipulating expressionsSubstitutingAdvanced Scoping and NamespacesNames Default To HereHandling Unqualified Named Variable ReferencesNames Default To Here and Global VariablesExample of Using the Names Default To Here() FunctionScoped NamesPredefined ScopesExample of Using the Window ScopeExample of Using the Here ScopeNamespacesUser-Defined Namespace FunctionsNamespace MessagesUsing Namespace ReferencesNamespaces and Included ScriptsExamples of User-Defined NamespacesReferencing Namespaces and ScopesResolving Named Variable ReferencesBest Practices for Advanced ScriptingAdvanced Programming ConceptsThrowing and Catching ExceptionsFunctionsRecursionIncludesLoading and Saving Text FilesScripting BY GroupsOrganize Files into ProjectsEncrypt and Decrypt ScriptsEncryption and Global VariablesEncrypting Scripts in Data TablesAdditional Numeric OperatorsDerivativesAlgebraic ManipulationsMaximize and MinimizeLeast Squares ExampleScheduling ActionsRunning a Script at Start UpFunctions that Communicate with UsersWriting to the LogShowPrintWriteSend information to the UserBeepSpeakCaptionStatusMsgMail
Data Tables
Working with Data Table Objects
Get Started
Basic Data Table ScriptingOpen a Data TableTest for an Open Data TablePrompt Users to Open a Data TableShow Only Specific ColumnsCreate a New Data TableImport DataImport Data from a Text FileImport Data from a Microsoft Excel FileImport SAS Data SetsImport Web Pages and Remote FilesImport ESRI ShapefilesImport a Password-Protected FileImport a DatabaseSet the Current Data TableName a Data TableSave a Data TableHide a Data TablePrint a Data TableResize a Data TableClose a Data TablePerform Actions on All Open Data TablesCreate Journals and LayoutsAdvanced Data Table ScriptingStore Summary Statistics in Global VariablesCreate a Table of Summary StatisticsSubset a Data TableSubset Data Using the Data FilterDefine the Context of a Data FilterSort a Data TableStack Values in a Data TableSplit Values in a Stacked Data TableTranspose a Data TableVertically Concatenate Data TablesHorizontally Concatenate Data TablesReplace Data in Data TablesCreate a Table Using TabulateFind Missing Data PatternsCompare Data TablesSubscribe to a Data TableMove Data Between Matrices and Data TablesColumnsSend Messages to Data Column ObjectsCreate ColumnsAdd Several Columns at OnceGroup ColumnsGet Column Groups or NamesSelect a Column GroupRename a Column GroupMove a Column GroupSelect ColumnsRearrange and Move ColumnsAdd a Column SwitcherCompress Selected ColumnsDelete ColumnsObtain Column NamesColumn AttributesSet or Get a Column NameSet or Get Column ValuesSet or Get Value LabelsSet or Get Data and Modeling TypesSet or Get FormatsSet, Get, or Evaluate a FormulaSet and Get Range and List ChecksGet a Column ScriptPreselect RolesLock a ColumnColumn PropertiesRowsAdd RowsDelete RowsSelect RowsFind RowsMove RowsAssign Colors and Markers to RowsColor CellsHide, Exclude, and Label RowsIterate on Rows in a TableSet the Current RowWhat is the Current Row?How Many Rows and Columns?Iterate a Script on Each RowReturn Row ValuesAdd Sequence DataRow States and OperatorsAbout Row StatesAbout Row State OperatorsAssign Row StatesStore Row State InformationSet or Get Row StatesIdentify Row State ChangesExclude, Hide, Label, and SelectColors and MarkersThe Numbers behind Row StatesAccessing Data ValuesSet or Get Values by Column NameAdditional Ways to Access Data ValuesAdd Metadata to a Data TableTable VariablesTable ScriptsFormulasDelete MetadataCalculationsPre-Evaluated StatisticsColumnwise FunctionsRowwise FunctionsCalculator Formulas
Scripting Platforms
Create, Repeat, and Modify Analyses
Overview
Scripting Analysis Platforms
Launching Platforms Interactively and Obtaining the Equivalent ScriptLaunch a PlatformSave ScriptMake Some ChangesSyntax for Platform ScriptingBY Group ReportsSaving BY Group ScriptsSending Script Commands to a Live AnalysisConventions for Commands and ArgumentsSending Several MessagesLearning the Messages an Object Responds toHow to Interpret the Listing from Show PropertiesLaunching PlatformsSpecifying ColumnsPlatform Action CommandInvisible ReportsTitlesGeneral Messages for Platform WindowsOptions for All PlatformsByTitleAxesAutomatic RecalculationAdditional NotesSpline FitsFit Model EffectsFit Model Send CommandDOE ScriptingTuning CommandsScatterplot ScriptingControl ChartsRunning Alarm ScriptsExample: X- and R-ChartsExample: X- and S-charts with Varying Subgroup SizesExample: Individual Measurement and Moving Range ChartsExample: UWMA ChartsExample: EWMA ChartsExample: NP-ChartsExample: P-ChartsExample: U-ChartsExample: C-ChartsPhases
Display Trees
Create and Use Windows
Manipulating Displays
Introduction to Display BoxesDisplayBox Object ReferencesSubscriptsWildcardsSending MessagesLearning What You Can do with a Display BoxFind a Window QuicklyCustomizing ReportsUsing the << OperatorNesting and PrecedencePlatform ExampleWindowHow to Access Built-in WindowsUsing the Pick WindowsConstructing Display TreesBasicsExampleUpdating an Existing DisplayAppend, Prepend, and DeleteUpdating a numeric columnControlling Text WrapInteractive Display ElementsExamplesCheck BoxRadio BoxCombo BoxList BoxButton BoxPopup BoxSlider BoxTab BoxText BoxText Edit BoxCol List BoxCol Span BoxLine Up BoxBorder BoxPanel BoxJournal BoxComplete ExampleExamples of Getting and Setting Values of Interactive Display ElementsAdvanced ExampleSend Messages to Constructed DisplaysBuild Your Own Displays from ScratchConstruct Display Boxes Containing PlatformsConstruct a Custom PlatformSheetsJournalsPicture Display TypeModal WindowsConstructing Modal WindowsGeneral-Purpose Modal WindowComparing Dialog and New WindowData Column Dialog BoxesArrangementAssign Dialogs to VariablesUnload Results from Column DialogsConstructing Dialogs and Column DialogsScripting the Script EditorSyntax Reference
Scripting Graphs
Create and Edit 2-Dimensional Plots
Adding Scripts to Graphs
Ordering Graphics Elements Using JSLAdding a Legend to a GraphCreating New Graphs From ScratchMaking Changes to GraphsGraphing ElementsPlotting FunctionsGradient FunctionGetting the Properties of a Graphics FrameAdding a LegendDrawing Lines, Arrows, Points, and ShapesLinesArrowsMarkersPies and ArcsRegular Shapes: Circles, Rectangles, and OvalsCirclesRectanglesOvalsIrregular Shapes: Polygons and ContoursPolygonsContoursAdding textColorsTransparencyFill patternsLine typesDrawing With PixelsInteractive graphsHandleMouseTrapDrag FunctionsTroubleshooting
Three-Dimensional Scenes
Scripting in Three Dimensions
About JSL 3-D Scenes
JSL 3-D Scene BoxesSetting the Viewing SpaceSetting Up a Perspective SceneSetting up an Orthographic SceneChanging the ViewThe Translate CommandThe Rotate CommandThe Look At CommandThe ArcBallGraphics PrimitivesPrimitives ExampleControlling the Appearance of PrimitivesSize and WidthStippling PatternFill PatternOther uses of Begin and EndDrawing Spheres, Cylinders, and DisksConstructionCylindersDisksSpheresLightingDrawing TextUsing Text with Rotate and TranslateUsing the Matrix StackLighting and NormalsCreating Light SourcesLighting ModelsNormal VectorsShading ModelMaterial PropertiesAlpha BlendingFogExampleBézier CurvesOne-Dimensional EvaluatorsTwo-Dimensional EvaluatorsUsing the mousePick CommandsParameters
Extending JMP
External Data Sources, Analytical Tools, and Automation
Real-Time Data Capture
Create a Datafeed ObjectOptionsManage a Datafeed with MessagesExamples of DatafeedReading DataSet Up a Live Control ChartStore the Script in a Data TableDynamic Link Libraries (DLLs)Using Sockets in JSLSocket-Related CommandsMessages for SocketsDatabase AccessAdditional Database CommandsWorking with SASMake a SAS DATA StepCreate SAS DATA Step Code for Formula ColumnsSAS Variable NamesGet the Values of SAS Macro VariablesConnect to a SAS Metadata Server on WindowsMake the ConnectionView SAS LibrariesOpen SAS Data SetsSave SAS Data SetsRun a Stored ProcessSubmit SAS Code from JMPPreferencesSample ScriptsWorking with MATLABInstalling MATLABInstall MATLAB on WindowsInstall MATLAB on MacintoshHow JMP Finds MATLABTest Your InstallWorking with RInstalling RHow JMP Finds RTesting Your SetupJMP to R InterfacesR JSL Scriptable Object InterfacesConversion Between JMP Data Types and R Data TypesJMP Scoping Operators and RUsing R Name() with R Send()TroubleshootingRecording OutputCharacter VectorsElement NamesExamplesSending a Data Table to RCreating Objects in RUsing R Functions and GraphicsSimple Matrix Addition in RA Bootstrap SampleWorking with ExcelOLE AutomationAutomating JMP through Visual BasicStarting a JMP ApplicationLaunching an AnalysisCreating and Populating a Data TableExample ProgramsAn Example: Automating JMP From Excel 2007Automating JMP through Visual C++Steps for Automating JMPExample Program
Creating and Sharing Applications
Application Builder and Add-In Builder
Application Builder
ExampleApplication Builder TerminologyDesign an ApplicationApplication Builder WindowRed Triangle OptionsCreate an ApplicationCreate a New Blank ApplicationManage ModulesModal Dialog ModulesArrange and Remove ObjectsCustomize Object PropertiesWrite ScriptsEdit or Run an ApplicationOptions for Saving ApplicationsAdditional ExamplesParameterized VariablesDate PickerJMP Add-InsCreate an Add-In Using Add-In BuilderEdit an Add-InRemove an Add-In from the Add-Ins MenuUninstall an Add-InShare an Add-InInstalling Multiple Add-InsRegister an Add-In Using JSLCreate an Add-In ManuallyExample of a addin.def FileExample of a JMP Add-In
Common Tasks
Getting Started with Sample Scripts
Convert Character Dates to Numeric Dates
Format Date/Time Values and Subset DataCreate a Formula ColumnExtract Values from an Analysis into a ReportCreate an Interactive Program
Compatibility Notes
Changes in Scripting from JMP 10 to JMP 11
Glossary
Terms, Concepts, and Placeholders
Index
Scripting GuideSymbolsABCDEFGHIJLMNOPQRSTUVW-Z

Content preview from JMP 11 Scripting Guide

Convert Character Dates to Numeric Dates

Data might appear to be numeric in the data table. However, the column properties specify a character data type. To manipulate the data as date/time values, you must convert the column to a numeric column.

Convert Dates.jsl (Figure 16.1) creates a data table, converts the character column to numeric, and applies the y/m/d format by sending messages to the column (Figure 16.2).

Figure 16.1 Script for Converting Character Dates to Numeric Dates

Figure 16.2 Converting Character Dates (Before and After)

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: 9781612906799

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

JMP 11 Scripting Guide

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.