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

Close Database Connection(db connection handle)
Convert File Path(path, <"absolute"|"relative">, <"posix"|"windows">, <base(path)>)
Indicates whether to copy the from path subdirectory structure to the to path. On Windows operating systems released after Windows XP, copying is always done recursively.
Create Database Connection( "dsn=Books;UID=johnsmith;password=Christmas" );
Create Database Connection( "dsn=Books;UID=johnsmith", Driver Prompt( 1 ) );
Create Database Connection( "Connect Dialog" );
File Size( "$SAMPLE_DATA/Big Class.jmp" );
13142
List of filenames. If "recursive" is not specified, directory names are included in the list.
exdt1 = Open( "$SAMPLE_DATA/Big Class.jmp" );
exdt2 = Open( "$SAMPLE_DATA/Animals.jmp" );
windows = Find All( Data Tables );
For( i = 1, i <= N Items( windows ), i++,
	Write( Char( windows[i] << Get Window Title ) || "\!N" )
);
Cities
Big Class
Animals
If the default directory was set using Set Default Directory(), JMP returns the specified path as long as Get Default Directory() and Set Default Directory() are in the same script.
The function supports .xlsx and Excel 1997 or later workbooks.
dt = JSON to Data Table(
	"[ { \!"name\!": \!"KATIE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 59, \!"weight\!": 95 }, { \!"name\!": \!"LOUISE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 61, \!"weight\!": 123 }, { \!"name\!": \!"JANE\!", \!"age\!": 12, \!"sex\!": \!"F\!h", \!"height\!": 55, \!"weight\!": 74 } ]"
);
l = JSON To List(
	"[ { \!"name\!": \!"KATIE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 59, \!"weight\!": 95 }, { \!"name\!": \!"LOUISE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 61, \!"weight\!": 123 }, { \!"name\!": \!"JANE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 55, \!"weight\!": 74 } ]"
);
Show( l );
Reads the text file at path into a JSL variable.
"best guess" attempts to detect the character set.
force("throw"|"alert"|"silent") is an optional argument that determines what happens if the character set cannot be detected.
Optional argument that specifies the end-of-line character. For example, "\!n" specifies a line feed character. "\!t" specifies a tab.
ReadOffsetFromBegin(n) specifies the zero-based offset to begin reading from the beginning of the file.
ReadOffsetFromEnd(n) specifies the zero-based offset to begin reading from the end of the file.
ReadLength(n) specifies the number of bytes to read from the file, either from the beginning of the file or from one of the offset values.
Base64Compressed(0|1) specifies how the blob is converted to a printable representation. 0, the default and recommended setting, uses JMP’s ASCII~HEX representation. 1 means the blob is compressed and converted to base 64 when printed.
Opens the data table or other JMP file or object created from a file named by the path. If no path is specified, the Open window appears. Also opens JSON and HDF5 files. Refer to the examples in the JMP Scripting Index for details about which arguments apply to specific file types.
The available character set options for importing text files are Best Guess, utf-8, utf-16, us-ascii, windows-1252, x-max-roman, x-mac-japanese, shift-jis, euc-jp, utf-16be, and gb2312.
colName: Specifies the column name used in the imported text file.
colType(Character | Numeric): Indicates whether the specified column contains character or numeric data.
colWidth(n): indicates the integer width of the specified column.
For ESRI shapefiles (.shp), this argument and its settings indicate the following:
Shape=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the shape number.
Part=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the part number.
X=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the decimal degree for the longitude (range of ±180°).
Y=numeric(n): Indicates the column number in the imported ESRI shapefile that contains the decimal degree for the latitude (range of ±90°).
An optional string that specifies the type of file that you are opening (for example, "text", "journal", "sas", "script", "png", and "jmp"). This can be useful if your file does not have a file extension, the file extension of the file does not match the contents of the file, or you want to import a JSL Blob. If you do not specify this string, the file opens in the default program for the file extension.
Note: The path argument should be used for a zip archive. The extension (.zip) is not required. See Zip Archives in JSL Messages for the messages that you can send to a zip archive. The basic functionality is to get a list of files in the zip archive, to read a file in the zip archive into either a string or a blob, and to write files into the zip archive. Note that reading a zip archive temporarily puts the contents into memory. Reading very large zip archives can cause errors.
Closes the specified JMP (.jrn, .jsl, .jrp, or .jmpappsource) file without saving and tries to reopen the file from disk. This argument deletes any changes made since the last time the file was opened.
To import a table from an HTML web page, use the URL as the filepath. The optional n argument specifies which table number, n, on the web page to open. If you omit the value, only the first table on the page is imported. The optional ColumnNames(n) specifies the row that contains column names. The optional DataStarts(n) specifies the row on which the data begins.
If the fields in the text file are quoted, setting this to True removes the quotes, and setting it to False does not remove the quotes. The default value is True.
Indicates that JMP should use the Worksheets settings for all worksheets in the Excel file to be opened as a data table.
Has Column Headers(Boolean) - Indicates the Excel file has column headers in the first row.
Number of Rows in Headers(n) - Specifies the number of rows in the Excel file used as column headers.
Headers Start on Row(n) - Specifies the row number in the Excel file where the column headers begin. Default is row 1.
Data Starts on Row(n) - Specifies the row number in the Excel file where the data begins.
Data Starts on Column(n) - Specifies the column number in the Excel file where the data begins.
Data Ends on Row(n) - Specifies the row number in the Excel file where data ends.
Data Ends on Column(n) - Specifies the column number in the Excel file where the data ends.
Replicated Spanned Rows(Boolean) - Indicates the Excel file contains spanned columns that should be imported into JMP as spanned columns.
Suppress Hidden Rows(Boolean) - Indicates that JMP should not import rows hidden in the Excel file.
Suppress Hidden Columns(Boolean) - Indicates that JMP should not import columns hidden in the Excel file.
Treat as Hierarchy(Boolean) - Indicates that JMP should treat multiple column headers (merged cells) as hierarchies when importing an Excel file. If True, the Excel file opens with the merged columns stacked (Tables > Stacked).
Note: You can import .xls worksheets from a web site by specifying worksheets arguments. .xlsx worksheets cannot be imported from a web site using Open().
Opens the database indicated by dataSourceName (or opened by the user) with the SELECT , SQLFILE, or tableName arguments.
A data table named outputTableName.
Open Database(
	"DSN=dBASE Files;DBQ=C:/Program Files/SAS/JMPPRO/14/Samples/Import Data/;",
	// SQL statement
	"SELECT HEIGHT, WEIGHT FROM Bigclass", // selected columns
	"hw" // name of the output data table
);
j = Parse JSON(
	"[ { \!"name\!": \!"KATIE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 59, \!"weight\!": 95 }, { \!"name\!": \!"LOUISE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 61, \!"weight\!": 123 }, { \!"name\!": \!"JANE\!", \!"age\!": 12, \!"sex\!": \!"F\!", \!"height\!": 55, \!"weight\!": 74 } ]"
);
Show( j );
j = {["age" => 12, "height" => 59, "name" => "KATIE", "sex" => "F", "weight" => 95], ["age" => 12, "height" => 61, "name" => "LOUISE", "sex" => "F", "weight" => 123], ["age" => 12, "height" => 55, "name" => "JANE", "sex" => "F", "weight" => 74]};
Show Files (Boolean)
The following script assigns Select JMP File as the window title; shows the JMP Samples/Data directory; shows JMP Files and All Files in the File name list and selects JMP Files; displays the Open window; and shows the sample data file name Hollywood Movies.jmp.
Pick File(
	"Select JMP File",
	"$SAMPLE_DATA",
	{"JMP Files|jmp;jsl;jrn", "All Files|*"},
	1,
	0,
	"Hollywood Movies.jmp"
);
When you specify the new directory name, include only the directory name, not the entire path.
When you specify the new name, include only the file name, not the entire path.
Set File Search Path( {"C:/JMP/13/source", "C:/Program Files/SAS/JMPPRO/14/Samples"} );
Set Path Variable("name", <value>)
Imports the specified Triple-S Survey (SSS) file. The SSS format consists of a pair of files: .xml or .sss, and a .csv, .dat, or .asc file. Both sets of files must have the same root name and be in the same folder.
dt = TripleS Import( "C:/Data/airlines.sss", Invisible, Use Labels for Imported Column Names( 0 ) );

Help created on 3/19/2020