Scripting Guide - SAS Support

1 Version 10. Scripting Guide The real voyage of discovery consists not in seeking new landscapes, but in having new eyes.. Marcel Proust JMP, A Business Unit of SAS. SAS Campus Drive Cary, NC 27513 The correct bibliographic citation for this manual is as follows: SAS Institute Inc. 2012. JMP 10. Scripting Guide . Cary, NC: SAS Institute Inc. JMP 10 Scripting Guide Copyright 2012, SAS Institute Inc., Cary, NC, USA. ISBN 978-1-61290-195-4. All rights reserved. Produced in the United States of America. For a hard-copy book: No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, or otherwise, without the prior written permission of the publisher, SAS Institute Inc. For a Web download or e-book: Your use of this publication shall be governed by the terms established by the vendor at the time you acquire this publication.

2 The scanning, uploading, and distribution of this book via the Internet or any other means without the permission of the publisher is illegal and punishable by law. Please purchase only authorized electronic editions and do not participate in or encourage electronic piracy of copyrighted materials. Your Support of others' rights is appreciated. Government Restricted Rights Notice: Use, duplication, or disclosure of this software and related documentation by the government is subject to the Agreement with SAS Institute and the restrictions set forth in FAR , Commercial Computer Software-Restricted Rights (June 1987). SAS Institute Inc., SAS Campus Drive, Cary, North Carolina 27513. 1st printing, March 2012. 2nd printing, July 2012. 3rd printing, November 2012. SAS Publishing provides a complete selection of books and electronic products to help customers use SAS software to its fullest potential.

3 For more information about our e-books, e-learning products, CDs, and hard-copy books, visit the SAS Publishing Web site at or call 1-800-727-3228. SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies. Technology License Notices Scintilla is Copyright 1998-2003 by Neil Hodgson NEIL HODGSON DISCLAIMS. ALL WARRANTIES WITH REGARD TO THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF. MERCHANTABILITY AND FITNESS, IN NO EVENT SHALL NEIL HODGSON BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF. USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS.

4 ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. XRender is Copyright 2002 Keith Packard. KEITH PACKARD DISCLAIMS ALL WARRANTIES WITH REGARD. TO THIS SOFTWARE, INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS, IN NO. EVENT SHALL KEITH PACKARD BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR. ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION. OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH. THE USE OR PERFORMANCE OF THIS SOFTWARE. ImageMagick software is Copyright 1999-2011, ImageMagick Studio LLC, a non-profit organization dedicated to making software imaging solutions freely available. bzlib software is Copyright 1991-2009, Thomas G. Lane, Guido Vollbeding. All rights reserved. FreeType software is Copyright 1996-2002, The FreeType Project ( ).

5 All rights reserved. Get the Most from JMP . Whether you are a first-time or a long-time user, there is always something to learn about JMP. Visit to find the following: live and recorded Webcasts about how to get started with JMP. video demos and Webcasts of new features and advanced techniques schedules for seminars being held in your area success stories showing how others use JMP. a blog with tips, tricks, and stories from JMP staff a forum to discuss JMP with other users Contents JMP Scripting Guide 1 Learn about JMP. Documentation and Additional Resources .. 19. Book Conventions .. 21. JMP Documentation .. 21. JMP Documentation Suite .. 22. JMP Help .. 25. JMP Books by Users .. 25. JMPer Cable .. 25. Additional Resources for Learning JMP .. 25. Tutorials .. 25. The JMP Starter Window .. 26. Sample Data Tables .. 26. Learn about Statistical and JSL Terms.

6 26. Learn JMP Tips and Tricks .. 26. Tooltips .. 27. Access Resources on the Web .. 27. 2 Introduction Welcome to the JMP Scripting Language .. 29. What JSL Can Do for You .. 31. Help with Learning JSL .. 31. The Scripting Guide .. 31. The Scripting Index .. 32. Let JMP Teach You JSL .. 32. Terminology .. 33. Basic JSL Syntax .. 36. 3 Getting Started Let JMP Write Your Scripts .. 37. Capturing a Script for an Analysis Report .. 39. 6. Capturing a Script for a Data Table .. 41. Capturing a Script to Import a File .. 41. Gluing Scripts Together .. 42. 4 Scripting Tools Using the Script Editor, Log Window, and Debugger .. 47. Using the Script Editor .. 49. Run a Script .. 49. Color Coding .. 49. Auto Complete Functions .. 50. Tooltips .. 50. Match Parentheses, Brackets, and Braces .. 51. Drag and Drop Text .. 52. Find and Replace .. 52. Automatic Formatting.

7 52. Set Preferences for the Script Editor .. 53. Working with the Log .. 55. Show the Log in the Script Window .. 56. Save the Log .. 56. Debug Scripts .. 56. Debugger Window .. 56. Work with Breakpoints .. 59. View Variables .. 62. Work with Watches .. 62. Modify Preferences in Debugger .. 63. Persistent Debugger Sessions .. 63. Examples of Debugging Scripts .. 63. 5 JSL Building Blocks Learning the Basics of JSL .. 69. JSL Syntax Rules .. 71. Value Separators .. 71. Numbers .. 74. Names .. 74. Comments .. 75. Operators .. 75. Global and Local Variables .. 79. Show Symbols, Clear Symbols, and Delete Symbols .. 80. 7. Lock and Unlock Symbols .. 81. Alternatives for Gluing Expressions Together .. 81. Iterate .. 82. For .. 82. While .. 83. Summation .. 84. Product .. 85. Break and Continue .. 85. Conditional Functions .. 87. If .. 87. Match .. 88. Choose.

8 90. Interpolate .. 91. Step .. 91. Compare Incomplete or Mismatched Data .. 92. Inquiry Functions .. 95. Name Resolution .. 97. Scoping Operators .. 98. Frequently Asked Questions .. 101. 6 Types of Data Working with Numbers, Strings, Dates, Currency, and More .. 103. Numbers and Strings .. 105. Path Variables .. 105. Create and Customize Path Variables .. 107. Relative Paths .. 108. File Path Separators .. 108. Date-Time Functions and Formats .. 108. Date-Time Values .. 109. Program with Date-Time Functions .. 109. Date-Time Values in Data Tables .. 115. Currency .. 119. Hexadecimal and BLOB Functions .. 120. Work with Character Functions .. 122. Concat .. 122. Munger .. 123. 8. Repeat .. 124. Use Pattern Matching and Regular Expressions .. 125. 7 Data Structures Working with Collections of Data .. 129. Lists .. 131. Evaluate Lists .. 131. Assignments with Lists.

9 132. Perform Operations in Lists .. 132. Find the Number of Items in a List .. 132. Subscripts .. 132. Locate Items in a List .. 133. List Operators .. 134. Iterate through a List .. 137. Matrices .. 137. Construct Matrices .. 138. Subscripts .. 139. Inquiry Functions .. 142. Comparisons, Range Checks, and Logical Operators .. 142. Numeric Operations .. 143. Concatenation .. 145. Transpose .. 146. Matrices and Data Tables .. 146. Matrices and Reports .. 149. Loc Functions .. 149. Ranking and Sorting .. 151. Special Matrices .. 151. Inverse Matrices and Linear Systems .. 156. Decompositions and Normalizations .. 159. Build Your Own Matrix Operators .. 164. Statistical Examples .. 164. Associative Arrays .. 168. Create Associative Arrays .. 168. Work with Associative Arrays .. 170. Applications for Associative Arrays .. 173. Associative Arrays in Graph Theory.

10 175. Associative Arrays in Set Operations .. 178. 9. 8 Programming Methods Complex Scripting Techniques and Additional Functions .. 181. Lists and Expressions .. 183. Stored expressions .. 183. Macros .. 192. Manipulating lists .. 192. Manipulating expressions .. 194. Advanced Scoping and Namespaces .. 198. Names Default To Here .. 198. Scoped Names .. 201. Namespaces .. 204. Referencing Namespaces and Scopes .. 209. Resolving Named Variable References .. 212. Best Practices for Advanced Scripting .. 214. Advanced Programming Concepts .. 214. Throwing and Catching Exceptions .. 215. Functions .. 216. Recursion .. 217. Includes .. 217. Loading and Saving Text Files .. 218. Scripting BY Groups .. 218. Organize Files into Projects .. 219. Encrypt and Decrypt Scripts .. 221. Encrypting Scripts in Data Tables .. 223. Additional Numeric Operators .. 224. Derivatives.