JSL Syntax Reference • JSL Messages • Data Tables
上一个
 • 
下一个
Data Tables
dt<<Add Column Properties(property argument, ...)
Add the specified properties to the selected column.
dt<<Add Multiple Columns("prefix", n, position, attributes)
Adds n columns to dt at the position indicated.
dt<<Add Rows(count, <rownum>)
dt<<Add Rows(assignment list)
Add the number of rows specified to the bottom of the data table or starting at the rownum specified.
dt<<Add Scripts to Table(script, ...)
dt<<Add Properties to Table(script, ...)
Adds the specified scripts to the data table.
dt<<Anonymize(<columns(list)>, <Output Table Name(string)>);
Removes unique identifiers from data, some column properties, and table scripts. Applies to a data table or selected columns.
dt<<Begin Data Update
Holds off display updating to allow for quick updating of data table cells. Use End Data Update in conjunction with this command to turn display updating back on.
Notes
Begin Data Update does not affect the data refresh due to some other table manipulations. For example, when you delete or add columns, the data table is updated and then the data update begins.
dt<<Clear Column Selection
Deselects all selected columns. When columns are deleted, the display is refreshed.
dt<<Clear Row States
Cancels any row states in effect.
dt<<Clear Select
Turns off the current selection.
dt<<Clone Formula Column(column, n, Substitute Column Reference(column1, {list}))
Creates n new formula columns, substituting references to column1 with columns from the list into the formula from the original column.
dt<<Close Data Grid(Boolean)
Closes the data table grid.
dt<<Close Side Panels(Boolean)
Closes the side panel in a data table.
dt<<Color or Mark by Column(col, <optional arguments>)
dt<<Color by Column(col, <optional arguments>)
Function
Assigns colors or markers according to the values of a data table column. If no optional arguments are provided, row states are used.
Arguments
Color Number(n)
Uses the specified quoted JMP color.
Color Theme("theme")
Uses the specified quoted color theme.
Marker Theme("named argument")
Uses the specified quoted marker theme: "standard", "hollow", "paired", "classic", or "alphanumeric".
Continuous Scale
For Color by Column, assigns colors in a chromatic sequential fashion based on the values in the highlighted column.
Reverse Scale
Reverses the color scheme in use.
Excluded Rows
Applies the row states to excluded columns.
Make Window with Legend
Creates a separate window with a legend.
dt<<Color Rows by Row State
Colors the rows in the data table grid using the color assignments by row states. Send the message again to turn off the row colors.
dt<<Compress Selected Columns({column1, ...})
Compresses the listed columns into the most compact form that is possible. Columns with character data are compressed to 1 byte if there are fewer than 255 levels. Columns with numeric data are compressed to 1 byte if the numeric values are between -127 and 127.
dt<<Concatenate(dt2, ..., Keep Formulas, Output Table Name("name"))
Creates a new table ("name") from the rows of dt and dt2.
dt<<Copy Table Script
Copies the script to recreate the data table onto the clipboard so that it can be pasted somewhere else.
dt<<Data Filter(<Mode(...)>, <Add Filter (...)>)
Constructs a data filter. If no arguments are specified, the Add Filter Columns window appears.
Arguments for Mode() include Select(), Show(), and Include(). They are all Boolean. Select defaults to true(1), and Show and Include default to false (0).
Arguments for Add Filter() include Columns(), and Where(). Columns() takes one or more column names separated by commas. You can add one or more WHERE clauses to define the filter.
There are several additional arguments. For more information, see 数据过滤器 in the Using JMP book and Subset Data Using the Data Filter in the Scripting Guide.
dt<<Get Header Height
Returns the column header’s display height (in pixels).
dt<<Data View(<"options">)
Duplicates the data table in a new window. If you specify one of the following quoted arguments, the new data table includes only the corresponding rows.
excluded
Quoted. The new data table includes only the rows that are marked as excluded in the original data table.
labeled | labelled
Quoted. The new data table includes only the rows that are marked as labeled in the original data table.
hidden
Quoted. The new data table includes only the rows that are marked as hidden in the original data table.
selected
Quoted. The new data table includes only the rows that are selected in the original data table.
dt<<Delete Columns(col, col2, ...)
dt<<Delete Column
Deletes column(s) from the data table dt. Specify which column or columns to delete. Without an argument, deletes the selected columns, if any. Delete Column is a synonym.
dt<<Delete Rows(<n>)
dt<<Delete Rows({n, o, p, ...})
dt<<Delete Rows({n::q})
Deletes the currently selected rows or rows specified.
dt<<Delete Table Property("name")
Deletes a table property (for example, a script).
dt<<Delete Table Variable("name")
Deletes a table variable.
dt<<End Data Update
Resumes display updating after a Begin Data Update message. These commands are used for quick updates of the data table when many changes have to be made. Speed is gained by turning off display updating.
dt<<Exclude
dt<<Unexclude
Toggles selected rows in dt from excluded to unexcluded or vice versa.
dt<<Get All Columns As Matrix
Returns the values from all columns of dt in a matrix. Character columns are numbered according to the levels, starting at 1.
dt<<Get As Matrix
Returns values from the numeric columns of dt in a matrix.
dt<<Get As Report
Returns the data table as a report.
Example
The following script returns Big Class.jmp as a report and displays it and a distribution in one window.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dtRpt = dt << Get As Report;
distRpt = V List Box(
	dt << Distribution(
		Continuous Distribution( Column( :weight ) ),
		Nominal Distribution( Column( :age ) )
	)
);
New Window( "Example", H List Box( dtRpt, distRpt ) );
dt<<Get Column Names("arguments")
Returns a list of column names in a data table. The "arguments" restrict the names retrieved as follows:
"Numeric", "Ordinal", "Rowstate", "Continuous", "Ordinal", and "Nominal" get only the specified types of columns. More than one can be specified. "String" returns a list of strings rather than a list of column references.
dt<<Get Column Reference(list or matrix of col names)
Returns the column reference of the strings in the list or matrix. If no list or matrix is used, JMP returns all column names.
dt<<Get Display Width
Returns the column display width in pixels.
dt<<Get Excluded Rows
Returns the currently excluded rows in the data table.
dt<<Get Hidden Rows
Returns the currently hidden rows in the data table.
dt<<Get Labeled Columns
dt<<Get Labelled Columns
Returns the currently labeled columns in the data table.
Example
In PopAgeGroup.jmp, the Country and Year columns are labeled. The following script returns a list of the labeled column names.
dt = Open( "$SAMPLE_DATA/PopAgeGroup.jmp" );
dt << Get Labeled Columns;
{:Country, :Year}
dt<<Get Labeled Rows
dt<<Get Labelled Rows
Returns the currently labeled rows in the data table.
dt<<Get Name
Returns the name of the table.
dt<<Get Path
Returns the absolute path for the JMP data table. Note that this function is not for imported data that is not saved yet.
dt<<Get Property("name")
Returns the script in the property name.
dt<<Get Row Change Function
Returns the expression that is evaluated when a row is selected.
dt<<Get Row ID Width
Returns the row ID display width in pixels.
dt<<Get Row States
Returns a vector containing the row state for every row in the data table or data filter.
dt<<Get Rows Where(WHERE clause)
Returns the rows in the data table that match the specified where criteria. Some examples are as follows:
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Get Rows Where( :sex == "M" );
dt << Get Rows Where( :sex == "M" & :age < 15 );
dt<<Get Script
Returns as an expression a script to recreate the data table.
dt<<Get Selected Columns(<"string">)
Returns a list of selected columns as column references. Include the "string" argument to return the selected columns in a string.
Examples
dt << Get Selected Columns();
{:age, :sex, :height}
dt << Get Selected Columns( "string" );
{"age", "sex", "height"}
dt<<Get Selected Rows()
Returns the selected rows.
dt<<Get Table Script Names()
Returns a list of the names of all the scripts and properties in the data table.
dt<<Get Table Variable("name")
Returns the value from the variable or script name.
dt<<Get Table Variable Names()
Returns a list of the names of all the variables in the data table.
dt<<Go To Row(n)
Locates and selects row number n in dt.
dt<<Group Columns({col1, col1, ...})
dt<<Group Columns("group name", col, n)
Groups the columns specified under the specified group name. You can provide either a list of columns to group, or a column name and the number of columns to group. In the latter case, the number n specifies to group the column given with the n-1 columns that follow.
dt<<Hide
dt<<Unhide
Toggles selected rows in dt from hidden to unhidden or vice versa.
dt<<Invert Row Selection
Selects any row currently deselected and deselects any row currently selected.
dt<<Is Dirty
Returns 1 if the table has been modified from its saved state. Otherwise, returns 0.
dt<<Join(With(table), <Private>, <Invisible>, Select(columns), Select With(columns), (By Matching Columns(col1=col2, ...)|Cartesian|By Row Number), <Merge Same Name Columns>, <Match Flag>, <Copy Formula(Boolean)>, <Suppress Formula Evaluation(Boolean)>, Update, <Drop Multiples(Boolean, Boolean)>, <Include Non Matches(Boolean, Boolean)>, <Preserve Main Table Order>, <Output Table Name("name"))>
Description
Combines data tables dt and table side to side. For details about joining tables, see 连接数据表 in the Using JMP book.
Returns
A data table.
Arguments
Private
Optional. Does not open the resulting data table. Using private data tables saves memory for smaller tables. However, for large tables (for example, 100 columns and 1,000,000 rows), using a private data table is not helpful the data requires a lot of memory.
Invisible
Optional. Opens the data table but hides it. The table is in the JMP Home Window’s Window List.
With(dataTable)
The secondary data table.
Select(columns)
Selects the columns from the main table to be added to the output table. Optional.
Select With(columns)
Selects the columns from the secondary table to be added to the output table.
By Matching Columns(col1=col2, ...)|Cartesian|By Row Number
Determines the method for joining the tables. By Matching Columns(col1=col2, ...) updates the first table with data from second table (the default method). Cartesian joins two tables using a Cartesian method, where it forms a new table consisting of all possible combinations of the rows from two original tables. JMP crosses the data in the first table with the data in the second to display all combinations of the values in each set. By Row Number joins the two tables side by side. By Matching Columns is the default value.
Merge Same Name Columns
Optional. Merges columns with the same name. Off by default.
Match Flag
Optional. Off by default. Omits the Match Flag column from the joined data table when you are matching by column.
Copy Formula(Boolean for main table, Boolean for secondary table)
Optional. Copies the formulas from the table that you are joining. On by default.
Suppress Formula Evaluation()
Optional. Prevents JMP from evaluating columns’ formulas during the creation of the new table. On by default. Use Suppress Main Table Formula Evaluation to suppress evaluation only in the main table. Use Suppress Second Table Formula Evaluation to suppress evaluation only in the secondary table.
Update
Optional.Replace the data in the main table with the corresponding data from the secondary table.
Drop Multiples(Boolean for main table, Boolean for secondary table)
Optional. Includes all rows from the data table, even when there is no matching value. If you do not check the boxes associated with Drop multiples in either table, a Cartesian join is performed within each group of matching column values. Off by default.
Include Non Matches(Boolean for main table, Boolean for secondary table)
Optional. Includes non-matching columns. Off by default.
Preserve Main Table Order
Optional. Maintains the order of the original data table in the joined table, instead of sorting by the matching columns. On by default.
Output Table Name("name"))
Optional. The name of the resulting table.
dt<<Journal
Makes a journal from the data table. Only the data grid is included, not notes, variables, or scripts.
dt<<Journal Link
Adds a link to the data table in the current journal. If a journal does not exist, a new one is created.
dt<<Label
dt<<Unlabel
Toggles selected rows in dt from labeled to unlabeled or vice versa.
dt<<Last Modified
Returns the date on which the data table was last saved.
dt<<Layout
Makes a layout window from the data table. Only the data grid is included, not notes, variables, or scripts.
dt<<Lock Data Table
Locks the data table so that data and column properties cannot be added or changed.
dt<<Make Indicator Columns( <Prepend Column Name(Boolean)>, <Include Missing(Boolean)>);
Creates indicator columns of 0 and 1 values for the specified categorical column.
Example
The following example creates indicator columns for the sex column. Prepend Column Name creates columns named sex_F and sex_M. Otherwise, the columns are named after each level (F and M). Include Missing includes missing values.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Make Indicator Columns(
	Columns( :sex ),
	Prepend Column Name( 1 ),
	Include Missing( 1 )
);
dt<<Make RowState Handler
Creates a row state handler function. The argument of the function holds the rows whose row states get changed.
dt<<Make SAS Data Step
Returns the data table as a SAS Data Step.
dt<<Make SAS Data Step Window
Returns the data table as a SAS Data Step and places it in a SAS script window.
dt<<Marker by Column(col)
Assigns markers according to the values of a data table column.
dt<<Markers(n)
Assigns marker n to the selected rows.
dt<<Maximize Display
Forces the data table to remeasure all of its columns and zoom to the best-sized window.
dt<<Move Selected Columns("To First"|"To Last"|After(col))
Moves the selected columns in the data table to the specified position.
dt<<Move Rows("At Start"|"At End"|After(n))
Moves the selected rows in the data table to the specified position.
dt<<New Column("name", attributes)
Adds a new column named "name" after the last column in dt. Can also be used as a function: New Column("name", attributes).
dt<<New Data Box()
Makes a data table view in a display box tree. Useful for displaying the data table and report in one window. A data browser box is created when you send the New Data Box message to the data table object.
Example
The following script creates a data table view and report in one window. The data table is placed in a data browser box. The width of that box is set to 800 pixels. Because auto stretch is turned off, the data table view remains 800 pixels wide even if you stretch the right border of the window.
dtA = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp", invisible );
nw = New Window( "Example",
	H List Box(
		V List Box( dtbox = dtA << New Data Box() ),
		dtA << Distribution(
			Continuous Distribution( Column( :NPN1 ) ),
			Continuous Distribution( Column( :PNP1 ) )
		)
	)
);
dtbox << Set Auto Stretching( 0, 0 ) << Set Width( 800 );
dt<<New Data View
Opens a duplicate of the data table. The second data table is identical to and linked to the original data table, so that any changes made in one are reflected in the other. Closing either data table also closes the other and all references to the data tables are deleted.
This can be useful to show an invisible data table.
dt<<New Script("name", script)
dt<<Set Property("name", script)
Creates a new table property using the specified name that stores the specified script.
Use New Script() or Set Property() rather than the deprecated New Property() and New Table Property().
dt<<New Table Variable("name", value)
dt<<Set Table Variable("name", value)
Creates a new table variable with the specified name and value.
dt<<Next Selected
Scrolls data table down to show the next selected row that is not already in view.
dt<<Original Order
Restores saved order of columns in dt.
dt<<Previous Selected
Scrolls data table up to show the previous selected row that is not already in view.
dt<<Print Window(<"Show Dialog">)
Prints the window. If the optional argument "Show Dialog" is specified, the print window is displayed. Otherwise, the window is printed to the default printer using the current settings, and no print window is displayed.
dt<<JMP Query Builder
Builds a query containing one or more data tables.
dt<<Reorder By Data Type
Reorders columns in dt, row state first, then character, then numeric.
dt<<Reorder By Modeling Type
Reorders columns in dt to continuous, then ordinal, then nominal.
dt<<Reorder By Name
Reorders columns in dt to alphanumeric order by name.
dt<<Rerun Formulas
Recalculates all formula-based data table variables. Recalculations are performed in the proper dependency order.
dt<<Reverse Order
Reverses columns in dt from current order.
dt<<Revert
Reverts to the most recently saved version of dt.
dt<<Run Formulas
Performs all pending formula evaluations, including evaluations that are pending as a result of evaluating other formulas.
dt<<Run Script("name")
Finds the table property name and runs it as a JSL script.
dt<<Save("path")
dt<<Save As("path")
Saves the table under the "path" given.
For information about supported formats, see 关于向 JMP 导入数据 in the Using JMP book.
dt<<Save Database("connection_information", "table_name", <Replace>)
Save the data table to the database named using the connection and table name specified. The Replace option replaces the existing database with the current database.
dt<<Save Script to Script Window
Saves a script to reproduce the data table in a Script Journal window.
dt<<Select All Rows
Selects all rows in the data table.
dt<<Select Excluded
Selects only those rows in the data table that are currently excluded.
dt<<Select Hidden
Selects only those rows in the data table that are currently hidden.
dt<<Select Labeled
Selects only those rows in the data table that are currently labeled.
dt<<Select Randomly(p|n)
Randomly selects the given percentage p of the rows in the data table, or the number of rows n.
dt<<Select Rows({list})
Selects the rows given in the list of row numbers.
dt<<Select Where(condition)
Selects the rows in dt where the condition evaluates as true.
dt<<Set Dirty(Boolean)
Marks the data table as changed, even if no changes have been made.
dt<<Set Header Height(num)
Sets the column header’s display height to the number of specified pixels.
dt<<Set Label Columns(column_1, ...)
Assigns the specified columns as label columns.
dt<<Set Matrix(matrix)
Inserts matrix into a data table, adding new columns and rows as necessary.
dt<<Set Name("name")
Gives a "name" to the table.
dt<<Set Property("name", script)
See dt<<New Script("name", script).
dt<<Set Label Columns("name", ...)
dt<<Set Label Columns
Turns on the Label attribute for the specified columns. If no columns are listed, turns Label attribute off.
dt<<Set Row ID Width(expr)
Sets the row ID display width to the expr in pixels.
dt<<Set Row States(matrix)
Sets the row states for all rows in the data table.
dt<<Set Scroll Lock Columns("name", ...)
Locks scrolling for the specified columns. If no columns are listed, unlocks scrolling.
dt<<Set Table Variable("name", value)
See dt<<New Table Variable("name", value).
dt<<Sort(By(columns), order("Descending" or "Ascending"), Output Table Name("name"))
Creates a new table ("name") by rearranging the rows of dt according to the values of one or more columns.
dt<<Split (Split(column), Split by(column), Group(column), <Private> | <Invisible>, <Remaining Columns(Keep All | Drop All | Select(columns))>, <Copy formula(0|1)>, <Suppress formula evaluation(0|1)>, <Sort by Column Property("Value Ordering" {"string", "string"} | "Row Order Levels")>, <Output Table ("name")>)
Un-stacks multiple rows for each Split column into multiple columns as identified by the Split by column. The Split and Split by arguments are required.
dt<<Stack(Stack(columns), ID(columns), Stacked(newcol), Output Table Name("name"))
Creates a new table ("name") by combining the values from several columns in dt into one column newcol.
dt<<Subscribe( "keyname"(<"client">), On Delete Columns | On Add Columns | On Add Rows | On Delete Rows | On Rename Column | On Close | On Save | On Rename ( function ) )
Subscribes to a data table to get messages regarding changes in the data table.
dt<<Subset(Columns(columns), Rows(matrix), Linked, Table Name("name"), Copy Formula(1|0), Suppress Formula Evaluation(1|0), Sampling Rate(rate))
Creates a new table ("name") from the rows that you specify in dt.
dt<<Summary(<Private>, <Invisible>, Group(column), Subgroup(column), <N>, <Mean(column)>, <Std Dev(column>, <Min(column)>, <Max(column)>, <Range(column)>, <Sum(column)>, <CV(column)>, Freq(<freq column>), Weight(<weight column>), Include marginal statistics, Link to original data table(0), statistics column name format("stat(column)" | "column" | "stat of column" | "column stat")
Creates a new table of summary statistics for the col that you specify, according to groups and subgroups.
dt<<Suppress Formula Eval(Boolean)
Turns off automatic calculation of formulas for data table dt.
dt<<Text to Columns
Makes a set of text columns or indicator columns from a delimited text column.
Example
dt = Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
dt << Text To Columns(
	delimiter( "," ),
	columns( :Brush Delimited )
);
dt<<Transpose(Columns(columns), Rows(matrix), Output Table Name("name"))
Creates a new table ("name") from the rows and columns that you specify.
dt<<Ungroup Columns({col1, col1, ...})
Ungroups the columns defined in the list argument.
dt<<Unsubscribe("keyname", On Delete Columns | On Add Columns | On Add Rows | On Delete Rows | On Close | On Col Rename | All)
Releases any previous subscriptions to the data table.