Columns
col<<Add Column Properties(name, expression)
Adds the quoted column 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)
DescriptionÂ
Colors the cells of the column within the data table grid. Use any quoted named color or 0 to clear the color.
Note
See Color Cells the Data Tables chapter in the Scripting Guide for examples.
col<<Color Cell by Value(Boolean)
Description
Colors the cells of the column in the data table grid using the value color property.
Note
See Color Cells the Data Tables chapter in the Scripting Guide for examples.
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, <Format(format string)>, <Input Format(format string)>, <width>)
col<<Set Data Type(type, <Format(format string)>, <Input Format(format string)>, <width>)
Description
Sets the data type tocol.
Required Argument
type
Specifies the "Numeric", "Character", "Row State", or "Expression" data type.
Optional Arguments
Format(format string)
Specifies the way the data are displayed, such as h:m for hours and minutes. The format string argument is quoted.
Input Format(format string)
Specifies the way the data are input. The format string argument is quoted.
width
(Optional for numeric data) Specifies 1, 2, or 4 (the number of bytes in the column).
col<<Delete Formula
Deletes the formula from a column.
col<<Delete Property(name)
col<<Delete Column Property(name)
Deletes the quoted 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(Boolean)
Turns the excluded or unexcluded state on, depending on the Boolean argument.
col<<Format(<width>, <decimal places>, <"Use Thousands Separator">)
col<<Format("Best", <width>, <"Use Thousands Separator">)
col<<Format(("Fixed Dec"|"Percent"), <width>, <decimal places>, <"Use Thousands Separator">)
col<<Format("Pvalue", <width>)
col<<Format(("Scientific"|"Engineering"|"Engineering SI"), <width>, <decimal places>)
col<<Format("Precision", <width>, <decimal places>, <"Use Thousands Separator">, <"Keep Trailing Zeroes">, <"Keep All Whole Digits">)
col<<Format("Currency", <"Currency Code">, <width>, <decimal places>, <"Use Thousands Separator">)
col<<Format("Datetime", <width>, <input format>)
col<<Format(("Latitude DDD"|"Latitude DDM"|"Latitude DMS"|"Longitude DDD"|"Longitude DDM"|"Longitude DDM"), <width>, <decimal places>, ("PUN"|"DIR"|"PUNDIR"))
col<<Format("Custom", Formula(...), <width>, <input format>)
Description
Sets the numeric display specified format.
Arguments
See Numeric Formats in Using JMP for more information about the arguments.
Examples
col<<Format( 10, 2, "Use thousands separator");
col<<Format( "Currency", "EUR", 20 );
col<<Format( "m/d/y", 10 );
col<<Format( "Precision", 10, 2, "Keep trailing zeroes", "Keep all whole digits" );
col<<Format( "Latitude DDD", "PUNDIR"); // "PUN" for punctuation, "DIR" for direction, PUNDIR for both
col<<Format( "Custom", Formula( Abs( value ) ), 15 );
Notes
For a list of currency codes, see Currency in the Scripting Guide. The currency code is based on the locale if the code is omitted.
col<<Formula(expression)
col<<Set 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 Data Type Length
Returns the data type and length of the data column. Only the data type is returned if the data length is not fixed, as with character columns.
col<<Get Format
Returns the format of the column.
col<<Get Formula
Returns the formula.
col<<Get Hidden
Returns 1 if the column is hidden.
col<<Get Input Format
Returns the format used for input and storing of data for the column.
col<<Get Labeled
Returns 1 if the column is labeled.
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 Scroll Locked
Returns 1 if the column is scroll locked.
col<<Get Selected
Returns 1 if the column is selected, or 0 otherwise.
col<<Get Stored Values
Returns the values in the columns without considering the Missing Value Codes column property.
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 quoted 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 specified role for the column. Choices are "Y", "X", "Weight", "Freq", and "None", or "No Role".
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 Excluded
Excludes the column.
col<<Set Field Width(n)
Sets the field width for the column to n.
col<<Set Hidden
Hides the column.
col<<Set Labelled
Uses the column’s data values for labels.
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. The name argument is quoted.
col<<Set Property (name, expression)
Sets the quoted property name to the expression given. You can set any standard column property by name or a user-specified property.
Examples
The following example adds the Value Colors column property to the sex column, with pink for females and blue for males.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Column( "sex" ) << Set Property( "Value Colors", {"F" = 78, "M" = 69} );
The following example adds a custom column property named Date recorded to the height column.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
Column( "height" ) << Set Property( "Date recorded", 05Jan1990 );
Notes
Column Properties in the Scripting Guide provides more examples. See The Column Info Window in Using JMP for more information about each property.
col<<Set Scroll Locked(Boolean)
Turns the Scroll Lock attribute on or off according to the Boolean argument given.
col<<Set Selected(Boolean)
Sets the column to be selected or not selected.
col<<Set Use for Marker
col<<Use for Marker
Uses the values in the column as markers in graphs. Designed to use with expression columns and character columns that have IDs. In the Big Class Families.jmp sample data table, the picture column is specified to use as markers in graphs. Not supported in Bubble Plot.
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.
col<<Use For Marker(Boolean)
Uses the values in the column as markers in graphs or turns off the option. Designed to use with expression columns and character columns that have IDs. In the Big Class Families.jmp sample data table, the picture column is specified to use as markers in graphs.