Home Page Icon
Home Page
Table of Contents for
Jump into JMP® Scripting, Second Edition
Close
Jump into JMP® Scripting, Second Edition
by Rosemary Lucas, Wendy Murphrey
Jump into JMP Scripting, Second Edition, 2nd Edition
About this Book
Acknowledgments
Section 1
Introduction to JSL
Chapter 1: Make JMP Work for You
Overview
Capturing Scripts from Your Analyses
Capturing Scripts from Imported Data
Capturing Scripts from Data Manipulations
Creating a Combined Script
Summary
Chapter 2: Stitching It Together
Overview
Stitching Saved Scripts Together
Combining Summary Data with an Analysis
Combining Data Import, Summary, and Two Analyses
Summary
Chapter 3: The Double Layer Cake
Overview
Folding Back the Layers of the Results
The Analysis Layer
The Report Layer
Summary
Chapter 4: JSL Language Foundations
Overview
Fundamental Concepts
Data Structures
Namespaces
Name Resolution
Conditional Logic
Looping
Summary
Chapter 5: Close Your Eyes and Jump!
Overview
The Script Editor
Resources Available at Your Fingertips
What to Do in Times of Trouble
Summary
Chapter 6: The Dashboard and Application Builders
Overview
Combine Windows, the Dashboard Builder, and the Application Builder
Summary
Chapter 7: Advanced Topics
Overview
Building Custom Dialogs
Navigating Reports Programmatically
Expression Handling
Defensive Programming Strategies
Summary
Section 2
Jump On!
Chapter 8: Rows, Columns, and Tables
Question 8.1: I can manipulate a data table interactively, such as by selecting and deleting rows, by adding new columns, and so on. How can I get JMP to produce the script for these actions?
Question 8.2: How can I select rows where more than one condition is true? How can I select rows where at least one of the specified conditions is true?
Question 8.3: There are already rows selected in my data table. How can I select additional rows without deselecting any of the currently selected rows?
Question 8.4: How can I select from the currently selected rows?
Question 8.5: How can I perform a Select Where on numeric datetime values?
Question 8.6: How can I determine the number of selected, excluded, or hidden rows in a data table?
Question 8.7: I am attempting to select some rows, and then create a subset data table. When no rows are selected, all the rows are included in the subset data table. How can I create a subset only i
Question 8.8: How can I determine the number of selected columns in a table? How can I get a list of the selected columns? 201
Question 8.9: I want to delete all the character columns in a data table. How can I do this?
Question 8.10: Are there any JSL commands for recoding data, as in Cols ► Recode?
Question 8.11: I have a set of values that I want to use as the control limits for a data table column. How can I use these values to create the Control Limits column property?
Question 8.12: How can a character column containing datetime values be converted to a numeric column of JMP date values using a script?
Question 8.13: I can replace all the missing numeric values in a table with zeros interactively by performing Edit ► Search ► Find and Replace. How can I do the same procedure usin
Question 8.14: How can I delete the formula from every column in my data table?
Question 8.15: How can I use a variable in a new column with a formula?
Question 8.16: How can I add multiple columns with formulas in a loop? I want one new column for each continuous column that calculates the mean by a grouping column
Question 8.17: How can I get a list of all open data tables?
Question 8.18: How can I open and concatenate multiple files that have the same format?
Question 8.19: I have imported several files and performed some data cleanup. How can I concatenate all the open tables without knowing exactly how many tables are open?
Chapter 9: Dialog Windows
Question 9.1: How can I prompt the user to select columns to be used in an analysis?
Question 9.2: How can I stop a script if a user clicks the Cancel button in a dialog window?
Question 9.3: How can I prompt the user to select a file in a specific directory? I want to display only those files of a specific type, such as text
Question 9.4: Can a wildcard character be used to open several data tables that contain specific characters in the filename? 228
Question 9.5: How can I can prompt the user for information, and then use that value in the SQL string for extracting data from a database?
Question 9.6: How can I prompt the user to select starting and ending dates, as well as a title to be used in a report?. 232
Question 9.7: How can I populate a Combo Box based upon what a user selects in another Combo Box, and then generate a subset table that meets the selection criteria?
Question 9.8: How can I use Column Switcher to affect multiple graphs in the same window?
Question 9.9: Is it possible to show or hide a display box based upon a user’s prior selection in the same window?
Question 9.10: Why does the Excel Wizard open when I import data from my New Window?
Question 9.11: When I try to limit the columns shown in a Col List Box to numeric, no columns appear. Why?
Chapter 10: Analyses
Question 10.1: How can I save the Parameter Estimates table from my Bivariate analysis into a new data table?
Question 10.2: How can I save the Parameter Estimates table from my Bivariate analysis into a new data table when I am using a By variable?
Question 10.3: I am using the Neural platform and need to add the Prediction Profiler to the Neural report. How can I do this? 252
Question 10.4: How do I use global variables for limit values in a Control Chart script?
Question 10.5: For a control chart, how do I request that JMP open and use a table of saved limits rather than those limits calculated at run time?
Question 10.6: How do you save limits from the Control Chart analysis into the column property?
Question 10.7: How do you save limits from the Control Chart analysis into a new table?
Question 10.8: How can I use spec limits that are stored in a separate data table?
Question 10.9: I have many variables in my data table and want to perform a Stepwise regression analysis, and then run my new model. How do I script this?
Question 10.10: I need to close the Fit Model dialog window. How do I reference it?
Question 10.11: How can I use a list in place of the Fit Model effects?
Question 10.12: How do I save X number of principal components of my multivariate analysis to the data table? I also want to include the eigenvectors in my report and save them into a new data table
Question 10.13: How can I save the Mahalanobis outlier, Jackknife distances, and T-square values of the outlier analysis to the data table?
Chapter 11: Graph Components
Question 11.1: How do I replace the default axis label with a different label in Graph Builder?
Question 11.2: The font size, type, style, and color of the axis labels need to be changed in my report. How do I accomplish this?
Question 11.3: How do I specify a different font for the tick labels on my graph?
Question 11.4: The tick labels on an axis need to be rotated and formatted to two decimal places. How is this done?. 280
Question 11.5: How can I specify the order of values on an axis?
Question 11.6: How do I add a reference line on any graph?
Question 11.7: How can I remove a reference line?
Question 11.8: How do I add annotations to my graph using a script?
Question 11.9: I have a spec limits table with columns holding limits for each process variable. I want to plot these limits on Oneway plots. How can I do this?
Question 11.10: How can I get consistent legend colors when using a local data filter with Graph Builder?
Chapter 12: Reports and Journals
Question 12.1: At the top of my report, there is a text string that begins “Where...”. How can I remove this information from my report and instead show it in the top OutlineBox?
Question 12.2: How can I use a variable in a Where statement so that the window title and Where text show the actual variable values rather than the variable name?
Question 12.3: How can I arrange my report so that I have two graphs per row?
Question 12.4: How can I get a handle to the journal window so that I can save it?
Question 12.5: How can I change the name of the journal window?
Question 12.6: How do I insert the contents of a data table into a journal, under a specific OutlineBox?
Question 12.7: I need to save my report as a .jrp file in my script. How is this done?
Question 12.8: How can I use a map as a filter?
Question 12.9: How do I create a tabbed report?
Question 12.10: My graph has a local data filter. How can I save both components as one interactive HTML file?
Index
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
Index
Next
Next Chapter
Jump into JMP® Scripting, Second Edition
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