book

JMP 13 Scripting Guide

Name: JMP 13 Scripting Guide
Author: SAS Institute
ISBN: 9781629605760

by SAS Institute

September 2016

Intermediate to advanced

722 pages

17h 10m

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
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 SyntaxBook Conventions
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 ScriptStop a ScriptEdit a ScriptColor CodingAuto Complete FunctionsTooltipsSplit a WindowMatch Parentheses, Brackets, and BracesSelect a Rectangular Block of TextSelect Fragmented 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 VariablesLocal NamespacesNamed NamespacesShow Symbols, Clear Symbols, and Delete SymbolsLock and Unlock SymbolsHide a Global VariableRules for Name ResolutionVariable Names Used as ArgumentsResolving Unscoped NamesScoping OperatorsScoped Column NamesUnscoped Column NamesSet the Current Data Table RowTroubleshooting Variables and Column NamesTroubleshooting Variables and KeywordsFrequently Asked Questions about Name ResolutionAlternatives for Gluing Expressions TogetherIterateForWhileSummationProductBreak and ContinueBreakContinueConditional FunctionsIfMatchChooseInterpolateStepCompare Incomplete or Mismatched DataMissing ValuesInquiry FunctionsGeneral Element TypesSpecific Element TypesObject AttributesHost InformationVersion Information
Types of Data
Working with Numbers, Strings, Dates, Currency, and More
Numbers and Strings
Unicode CharactersPath 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 FunctionsConcatMungerRepeatRegular ExpressionsRegexRegex MatchSpecial Characters in Regular ExpressionsEscaped Characters in Regular ExpressionsGreedy and Reluctant Regular ExpressionsBackreferences and Capturing GroupsLookaround AssertionsPattern MatchingPatterns and Case
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 ListConcatenate ListsInsert a Nested List in an Existing ListIndexing into a List with Another 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 MatricesConcatenationTransposeIndexing into a Matrix or List with Another Matrix or ListMatrices 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 FilesFile and Directory OperationsSelect a Directory or FileGet a List of FilenamesScripting BY GroupsEncrypt and Decrypt ScriptsEncryption and Global VariablesEncrypting Scripts in Data TablesAdditional Numeric OperatorsDerivativesAlgebraic ManipulationsMaximize and MinimizeLeast Squares ExampleScheduling ActionsFunctions 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 HDF5 FilesImport ESRI ShapefilesImport a Password-Protected Microsoft Excel 2007 FileImport a DatabaseSet the Current Data TableName a Data TableSave a Data TableHide a Data TableInvisible Data TablesPrivate Data TablesPrint a Data TableResize a Data TableClose a Data TableSet and Get 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 TablesVirtually Join Data TablesReplace Data in Data TablesCreate a Table Using TabulateFind Missing Data PatternsCompare Data TablesCreate a Summary TableSubscribe 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
Example of Scripting a Platform
Send Messages to a PlatformConventions for Messages and ArgumentsSend Multiple MessagesFind Messages for ObjectsInterpret the Show Properties ListSpecify Which Columns to AnalyzeCreate Column ReferencesSpecify Multiple Column Names at OnceEnable Users to Specify ColumnsSpecify a By VariableFilter by Value or ColumnEnable User InputExecute Embedded Red Triangle OptionsMake Platforms InvisibleSpecify Report TitlesCommon Messages for Platform WindowsScripting Considerations by PlatformCategoricalScripting for SupercategoriesControl ChartsCustomize Tests in Control Chart BuilderRun Alarm ScriptsSet Phase LimitsDistributionDOEGlobal VariablesFit ModelFit GroupEffectsSend FunctionStandard Least SquaresNeural and Neural NetPartial Least Squares and PLSProcess CapabilitySpecification Limits in JSL ScriptsUsing a Limits Data Table and JSLScatterplot 3DExplorer OutliersScripting-Only Messages and Arguments by PlatformBivariateChoiceClusteringControl ChartCumulative DamageCustom ProfilerDistributionFit Life by XFit ModelFit Parametric SurvivalLife DistributionMultivariateNeuralPareto PlotPartitionSurface PlotText ExplorerTime SeriesVariability
Display Trees
Create and Interact with Windows
Navigate JMP Reports
Compatibility WarningExamples of Common Display BoxesView the Display TreeShow Display Box PropertiesDisplay Box Object ReferencesLearning What You Can Do with a Display BoxCreate a Reference By SubscriptingSend Messages to Display BoxesThe << OperatorNesting and PrecedenceCustomize Reports with the Send to Report and Dispatch FunctionsCreate a JournalUsing Common MessagesExample of Creating a ReportConstruct Custom WindowsExample of Creating a Graph BoxExtract Values from a WindowExtract Values: Method OneExtract Values: Method TwoExtract Values: Method ThreeConstructors for New WindowsContainer Display BoxesDisplay Element BoxesInput Selector Display BoxesFiltering Display BoxesExamples of Combined Display BoxesExample of Slider Boxes and Range Slider BoxesExample of a Calendar and Date SelectorExample of Constructing a Summary Results ReportInteract with a Closing WindowUpdate an Existing DisplayAppendPrependDeleteSib AppendSet Function and Set ScriptGet and Set Selected Values of Display Elements That Return ListsSend Messages to Constructed DisplaysConstruct Display Boxes That Contain PlatformsExamples of Creating a Dashboard from Two ReportsDashboard with One Row of ReportsDashboard with TabsHow to Dock Tabs in Tab BoxesExample of Creating a Cluster Platform Launch WindowExample of Constructing a Custom PlatformModal WindowsConstruct a Modal WindowConstruct a Column DialogComparison of Column Dialog and New WindowConstructors for Column DialogsScript Editor CommandsConvert Deprecated Dialog to New WindowComparison of New Window and the Deprecated DialogNew Window ExampleExample of Deprecated DialogDifferences Between New Window and the Deprecated DialogStrings and ListsList Boxes and Check BoxesLine Up ItemsRadio BoxesText Edit BoxesNumber Edit BoxesOptional Scripts in New WindowTechnical DetailsWriting Tab Box and Tab Page Box Scripts
Scripting Graphs
Editing and Creating Two-Dimensional Graphs
Adding Scripts to Graphs
Specify the Order of Graphical ElementsCopy and Paste Frame Contents or SettingsCreate New Graphs from ScratchCustomize GraphsGraph ElementsPlot FunctionsGradient FunctionGet the Properties of a Graphics FrameAdd a LegendAdd Lines, Arrows, Points, Shapes, and TextDraw LinesDraw ArrowsDraw MarkersDraw Pies and ArcsDraw Regular Shapes: Circles, Rectangles, and OvalsCirclesRectanglesOvalsDraw Irregular Shapes: Polygons and ContoursPolygonsContoursAdd TextSpecify ColorsSpecify TransparencyAdd Fill PatternsSpecify Line TypesDraw with PixelsInteractive GraphsHandle()Mousetrap()Drag FunctionsTroubleshoot Interactive GraphsCreate Background Maps
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 CommandsArguments
Extending JMP
External Data Sources, Analytical Tools, and Automation
Real-Time Data Capture
Create a Datafeed ObjectDatafeed OptionsRead in Real-Time DataManage 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 AccessCreating a Database Connection and Executing SQLWriting a SQL QueryWorking 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 ServerMake the ConnectionAutomatically Connect SAS LibrariesView SAS LibrariesOpen SAS Data SetsSave SAS Data SetsRun a Stored ProcessSubmit SAS Code from JMPPreferencesSample ScriptsWorking with MATLABInstalling MATLABHow JMP Finds MATLABTest Your InstallWorking with RInstalling ROverride Default R Install LocationHow 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 Microsoft ExcelParsing XMLOLE Automation
Creating Applications
Application Builder
Create Applications with Application Builder
Example of Creating an ApplicationApplication Builder TerminologyDesign an ApplicationApplication Builder WindowApplication Builder Red Triangle OptionsCreate an ApplicationCreate a New ApplicationManage ModulesModal Dialog ModulesArrange and Remove ObjectsCustomize Object PropertiesWrite ScriptsEdit or Run an ApplicationOptions for Saving ApplicationsAdditional Examples of Creating ApplicationsParameterizing VariablesFiltering Data in Multiple ReportsSelecting DatesCompile Add-Ins with the JMP Add-In BuilderCompile Scripts into an Add-In Using Add-In BuilderEdit 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-InManage JMP Add-InsInstall Add-InsView Your Add-InsUpdate Add-InsDisable, Enable, and Remove Add-Ins
Common Tasks
Getting Started with Sample Scripts
Run a Script at Start Up
Convert Character Dates to Numeric DatesFormat 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 12 to JMP 13Compatibility IssuesDeprecated JSL
Glossary
Terms, Concepts, and Placeholders
Index
Scripting GuideSymbolsABCDEFGHIJLMNOPQRSTUVW-Z

Content preview from JMP 13 Scripting Guide

What JSL Can Do for You

JMP can automatically save scripts to reproduce any data table or analysis in its current state. You can pause any time in your analysis to save a script to a script window (or script editor), in a data table, or in an analysis report. You can then modify the script as needed for future projects. When you are finished with your work, you can then save a script to reproduce your final results.

Here are some examples where JSL scripts can be helpful:

• Suppose you need to describe an analysis process in detail, from beginning to end. An example is to create an audit trail for a governing agency, or for peers reviewing your journal article.

• Suppose you have a set of analysis steps that should be followed routinely by ...

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

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

JMP 13 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.