Adds n columns to dt at the position indicated.
Turns off display updating to allow for quick updating of a data table. Use End Data Update in conjunction with this command to turn display updating back on.
Creates n new formula columns, substituting references to column1 with columns from the list into the formula from the original column.
Color Theme("theme")
Uses the specified quoted marker theme: "standard", "hollow", "paired", "classic", or "alphanumeric".
For Color by Column, assigns colors in a chromatic sequential fashion based on the values in the highlighted column.
Creates a new table ("name") from the rows of dt and dt2.
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.
dt<<Data View(<"options">)
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.
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.
Toggles selected rows in dt from excluded to unexcluded or vice versa.
Returns the values from all columns of dt in a matrix. Character columns are numbered according to the levels, starting at 1.
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.
In PopAgeGroup.jmp, the Country and Year columns are labeled. The following script returns a list of the labeled column names.
Returns the name of the table.
Returns the script in the property name.
Returns a list of selected columns as column references. Include the "string" argument to return the selected columns in a string.
Toggles selected rows in dt from hidden to unhidden or vice versa.
Combines data tables dt and table side to side. For details about joining tables, see the Using JMP book.
Toggles selected rows in dt from labeled to unlabeled or vice versa.
Assigns marker n to the selected rows.
dt<<Move Selected Columns("To First"|"To Last"|After(col))
dt<<Move Rows("At Start"|"At End"|After(n))
Adds a new column named "name" after the last column in dt. Can also be used as a command: New Column("name", attributes).
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<<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.
Reorders columns in dt, row state first, then character, then numeric.
Reorders columns in dt to continuous, then ordinal, then nominal.
Reorders columns in dt to alphanumeric order by name.
Reverses columns in dt from current order.
Finds the table property name and runs it as a JSL script.
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.
Randomly selects the given percentage p of the rows in the data table, or the number of rows n.
Selects the rows in dt where the condition evaluates as true.
dt<<Set Dirty(Boolean)
Gives a "name" to the table.
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.
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.
Creates a new table ("name") by combining the values from several columns in dt into one column newcol.
Creates a new table ("name") from the rows that you specify in dt.
Creates a new table of summary statistics for the col that you specify, according to groups and subgroups.
Creates a new table ("name") from the rows and columns that you specify.
Adds the property "name" with the expression given. You can add any standard column property by name or a user-specified property.
Sets the "type" for col; choices are "Numeric", "Character", "Rowstate".
Sets the numeric display format specified.
Returns the modeling type of the column ("Continuous" or "Ordinal" or "Nominal").
Preselects the role for the column. Choices are "Y", "X", "Weight", "Freq", and "None", or "No Role".
Sets the modeling type for the variable. Choices are "Continuous", "Ordinal", or "Nominal".
Sets the property "name" to the expression given. You can set any standard column property by name or a user-specified property.
Sets the column to be selected (true or 1) or not selected (false or 0).
Assigns the color n to the selected rows.
row<<Markers("marker")
Assigns the "marker" to the selected rows.
dtf<<Display(col, <Size(x, y)>, "Blocks Display"|"List Display"|"Single Category Display"|"Checkbox Display")