Scripting Guide • Extending JMP

For the latest version of JMP Help, visit JMP.com/help.

Previous
 • 
Next
Extending JMP
External Data Sources, Analytical Tools, and Automation
This chapter discusses scripting features that are particularly useful for production settings, such as the following:
•
a data feed for capturing real-time data from a laboratory instrument
•
using SAS, MATLAB, R, or Python through JMP Scripting Language (JSL)
•
using JMP with Microsoft Excel
•
connecting to databases
•
controlling JMP externally by OLE automation
•
parsing XML
•
communicating with REST web services
Some general JSL commands that might be of particular interest for use in a production setting include Caption, Speak, Print, Write, and Mail. These commands are described in “Functions that Communicate with Users” on page 287 in the “Programming Methods” chapter.
Contents 
Real-Time Data Capture on Windows 692
Create a Data Feed Object 692
Read in Real-Time Data 693
Manage a Data Feed with Messages 694
Examples of Data Feed 697
Dynamic Link Libraries (DLLs) 699
Using Sockets in JSL 702
Socket-Related Commands 703
Messages for Sockets 704
Database Access 705
Run Query Builder Queries 705
Open Database Function 706
Creating a Database Connection and Executing SQL 708
Writing a SQL Query 709
Working with SAS 710
Make a SAS DATA Step 710
Create SAS DATA Step Code for Formula Columns 710
SAS Variable Names 711
Connect to a SAS Metadata Server 711
Get the Values of SAS Macro Variables 715
Preferences 715
Sample Scripts 715
Working with MATLAB 717
Installing MATLAB 717
Working with R 718
Installing R 719
JMP to R Interfaces 720
R JSL Scriptable Object Interfaces 720
Conversion Between JMP Data Types and R Data Types 720
Troubleshooting 724
Examples 725
Working with Python 726
Install Python 727
How JMP Finds Python on Windows 728
JMP-to-Python Interfaces 730
Equivalent Data Types for Python Send() 730
Equivalent Data Types for Python Get() 731
JMP Scoping Operators and Python 732
Python Name() and Python Send() Examples 733
Additional Python Integration Examples 734
Working with Microsoft Excel 736
Parsing XML 736
OLE Automation 738
Communicate with REST Web Services 739
Examples of HTTP Requests 739

Previous
 • 
Next
Help created on 3/19/2020