A named argument that defines the type of resources that you want to close. The allowable types are: Data Tables, Reports, and Journals.
Close Database Connection(db connection handle)
Copies files from one directory to another, optionally copying subdirectories. The directory name is created in the to path and should not be part of the to path argument.
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 ) );
Enable the user to select the data source, specify "Connect Dialog":
Create Database Connection( "Connect Dialog" );
File Size( "$SAMPLE_DATA/Big Class.jmp" );
13142
Returns a list of filenames in the path given.
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.
This list is configured using the Set File Search Path() function. See Set File Search Path({path or list of paths}).
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.
|
Moves a file from the specified path to another specified path with the same or different file name.
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°).
|
If the imported text file uses an end of field character other than the one specified by End of Field, this argument specifies the character used.
If the imported text file uses an end of line character other than the one specified by End of Line, this argument specifies the character used.
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.
Tip: If the table you are importing contains images, they are first imported as text. To load the images in your JMP data table, run the automatically generated table script named Load Pictures. A new expression column containing the images is created. See Expression Role in the Using JMP book for details about expression columns.
Runs the specified JSL file instead of opening it. Include a Boolean argument or an expression that contains a Boolean value. If the script begins with //!, which automatically runs the script, include the Boolean value (0) to open the script instead.
Determines whether scripts run when you open downloaded data tables. Also provides an option to display a window that prompts users to examine or open the data table. If they select Examine, the scripts are disabled. See Options for Downloaded Data Tables that Contain Scripts in the Scripting Guide for examples.
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"} );
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.
Optional. Hides the table from view. The data table appears only in the JMP Home Window and the Window menu. Hidden data tables remain in memory until they are explicitly closed, reducing the amount of memory that is available to JMP. To explicitly close the hidden data table, call Close(dt), where dt is the data table reference returned by TripleS Import.
dt = TripleS Import( "C:/Data/airlines.sss", Invisible, Use Labels for Imported Column Names( 0 ) );