Publication date: 08/13/2020

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.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).
.