Automating Analyses Using JMP Scripts

gail_massari

 

See how to:

• Understand that JMP Scripts are written using JMP Scripting Language (JSL) and should be saved as a file with a .jsl extension
• Understand Data Import - first prerequisite for creating interactive scripts
  • From Excel or CSV: Get the Source Script from the imported data table
  • From Database using Query Builder, then save the "Run" script
• Understand importance of data prep and cleaning - second prerequisite for creating interactive scripts
  • Requires different strategies
  • Data Cleaning Script Assistant add-in assists with some of these tasks
  • In JMP 16, new Event Recorder feature will replace most cleanup strategies
• Learn basic shortcuts to Fix Character Data Values, Reshape Data Tables, Subset Rows, Transformations other Derived Variables, Reorder Columns, Delete Columns, Rename Variables, Change Data Type, Change Modeling Type, Change Display Format, Set Column Properties
• Save script to clipboard
• Create scripts interactively using an example
  • Import Production Data from CSV
  • Add Month Variable
  • Graph Sites by the Sum of Units as an ascending bar chart w/ Data Filter on Month
  • Summarize the Sum of Units by Month
  • Import Targets from Excel
  • Join Monthly Summary with Targets
  • Calculate Percent of Goal
  • Rename some columns with Victor
  • Graph
• Follow Best Practices
  • Use Good Names
  • Avoid Namespace Collisions (Names Default To Here)
  • Add comments, notes to yourself to make it easy for you to remember what you did, or for someone else to interpret your work
  • Generalize for New Data
    • Simplest: Save updated data with same filename
    • Next Level: Prompt user to select data with a naked Open()
    • Custom JSL: Most flexible
  • Use Absolute or Relative File References
• Runs scripts on a schedule
  • Use Windows Scheduler to launch script
  • For autorun, start script with //!
  • End script with Quit() to exit JMP

 Note: Q&A is included at times 27:41, 28:38, 29:43, 49:36 and 1:03:00.

 

Resources

• After this video was recorded, in JMP 16 an Enhanced Log with action recording capability was added. Watch the Enhanced Log video to learn how to access scripts using this shortcut. 
• Script for automating analyses and sharing reports
• Data Cleaning Script Assistant Add-In
• Hiller and Stephens Automating the Data Curation Workflow presentation from Americas Discovery Summit 2020

Adding Data Table References

 

 

 

 

 

 

Common Shortcuts

Automating Analyses in JMP 15.zip

Vball247

Did not see this comment added to video the video. But at around 50:50, demonstrating JMP syntax completion using CTRL+space, after typing "Gra" the video shows that "Graph Builder" did not show in the drop down menu. This is because the syntax completion is context sensitive.

 

If you had: 

dt = Current Data Table();

dt << Gra 

and typing "Gra" after the <<,  then type CTRL+space, then "Graph Builder" shows up in the drop down menu, because it is a message that a data table can accept. This is handy because it narrows down to only the script code that is applicable to the context of where you are in the script line. If you had "Big Class.jmp" open, then dt:Age << Gra would show a different menu, since this is a column or part of a datatable.

 

The video showed only the commands that might be used on an empty script line, like "Graph", "Graph 3D Box", "Graph Box...".