JSL Syntax Reference • JSL Messages • Data Tables • Columns
Previous
 • 
Next
Columns
col<<Add Column Properties ("name", expression)
Adds the property "name" with the expression given. You can add any standard column property by name or a user-specified property.
col<<Add From Row States
Updates a row state column with any currently used row state changes that are not the default state.
col<<Add To Row States
Copies all row state values in a column that are not the default state to the currently used row state in the data table.
col<<Color Cells("color")
Colors the cells of the column within the data table grid. Use any quoted named color or 0 to clear the color.
col<<Color Cell by Value(Boolean)
Colors the cells of the column in the data table grid using the value color property.
col<<Copy Column Properties
Copies the column properties into the buffer.
col<<Copy From Row States
Copies all row state values currently used in the data table to a column.
col<<Copy to Row States
Copies all row state values in the column to the currently used row state in the data table.
col<<Data Type("type")
Sets the "type" for col; choices are "Numeric", "Character", "Rowstate".
col<<Delete Formula
Delete the formula from a column.
col<<Delete Property(name)
col<<Delete Column Property(name)
Delete the property name from a column.
col<<Eval Formula
Forces the formula to evaluate (perhaps again). If formula suppression is enabled, the evaluation is not performed.
col<<Exclude(0|1)
Turns the excluded or unexcluded state on, depending on the Boolean argument.
col<<Format("format", <width>, <decimal>, <"Use Thousands Separator">)
Sets the numeric display format specified.
col<<Formula(expression)
Sets the formula for the variable and evaluates it.
col<<Get Column Field Width
Returns the field width used for displaying data in the column.
col<<Get Data Type
Returns the data type of col.
col<<Get Format
Returns the format of the column.
col<<Get Formula
Returns the formula.
col<<Get Input Format
Returns the format used for input and storing of data for the column.
col<<Get List Check
Returns the list check definition. If list check is not defined for the column, a message is sent to the log stating so.
col<<Get Lock
Returns the current Lock setting.
col<<Get Modeling Type
Returns the modeling type of the column.
col<<Get Name
Returns the name of the column.
col<<Get Property
Returns the specified property definition. If the specified property is not defined for the column, a message is sent to the log stating so.
col<<Get Range Check
Returns the range check definition. If range check is not defined for the column, a message is sent to the log stating so.
col<<Get Role
Returns the preselected role of col.
col<<Get Script
Returns the script to reproduce the column.
col<<Get Selected
Returns 1 if the column is selected, or 0 otherwise.
col<<Get Value Labels
Returns the value labels definition. If value labels is not defined for the column, a message is sent to the log stating so.
col<<Get Use Value Labels
Returns 1 if the value labels are set to be used for the column, or 0 otherwise.
col<<Get Values
Returns the values in the column.
col<<Hide(Boolean)
Turns the Hide attribute on or off according to the Boolean argument given.
col<<Ignore Errors
Ignores formula evaluation errors in a column, and sets the cell value to missing when a formula error occurs.
col<<Input Format("format")
Sets the format used for input and storage for the column. The argument is the name of any JMP format (for example, "ddmmyyyy" for a date column).
date_col<<Is Transformed On SAS Export
Returns true if the data in the resulting SAS data set for the date column will be changed when it is exported to SAS.
col<<Label(Boolean)
Turns the Label attribute on or off according to the Boolean argument given.
col<<Lock(Boolean)
col<<Set Lock(Boolean)
Turns the Lock attribute on or off according to the Boolean argument given.
col<<Preselect Role("role")
Preselects the role for the column. Choices are "Y", "X", "Weight", "Freq", and "None", or "No Role".
col<<Set Scroll Locked(Boolean)
Turns the Scroll Lock attribute on or off according to the Boolean argument given.
col<<Set Display Width(n)
Sets the column display width to the n in pixels.
col<<Set Each Value(n)
Sets all the values in the column to n.
col<<Set Field Width(n)
Sets the field width for the column to n.
col<<Set Modeling Type("type")
Sets the modeling type for the variable. Choices are "Continuous", "Ordinal", "Nominal", "None", "Row State", "Unstructured", "Multiple Response", or "Vector".
col<<Set Name("name")
Sets the name for the column.
col<<Set Property ("name", {argument list})
Sets the property "name" to the expression given. You can set any standard column property by name or a user-specified property.
col<<Set Selected(Boolean)
Sets the column to be selected (true or 1) or not selected (false or 0).
col<<Set Values([matrix] or {list})
col<<Values([matrix] or {list})
Sets values for the matrix (for numeric variables) or list (for character variables).
col<<Suppress Eval(Boolean)
Turns off automatic calculation of formulas for the column.

Previous
 • 
Next
Help created on 9/19/2017