该帮助的版本不再更新，请参见https://www.jmp.com/support/help/zh-cn/15.2 获取最新的版本.


JSL Syntax Reference • JSL Messages • Data Tables • Columns
上一个
 • 
下一个
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", <Format("format string")>, <Input Format("format string")>, <width>)
col<<Set Data Type("type", <Format("format string")>, <Input Format("format string")>, <width>)
Description
Sets the "type" for col; choices are "Numeric", "Character", "Rowstate", or "Expression".
Arguments
type
Specifies the “Numeric”, “Character”, “Row State”, or “Expression” data type.
Format
(Optional) Specifies the way the data are formatted, such as h:m for hours and minutes.
Input Format
(Optional) Specifies the way the data are displayed, such as h:m.
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 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(<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 “数值格式” in the Using JMP book for details about the arguments.
Examples
<<Format( 10, 2, "Use thousands separator");
<<Format( "Currency", "EUR", 20 );
<<Format( "m/d/y", 10 );
<<Format( "Precision", 10, 2, "Keep trailing zeroes", "Keep all whole digits" );
<<Format( "Latitude DDD", "PUNDIR"); // "PUN" for punctuation, "DIR" for direction, PUNDIR for both
<<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 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 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.
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.
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 ““列信息”窗口” in the Using JMP book for details 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 (true or 1) or not selected (false or 0).
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<<UseForMarker(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.