Column propertiesAllows you to configure the properties of one or more columns.
⌘I
Allows you to define the name for the variable. The name labels the column and is used to refer to them in lists and formulae.
Choose from the following options:
When checked the data in the Column is calculated using the formula entered into the accompanying box. See Formulas for full details.
Available when Custom is selected for Data Format.
Choose from Left, Centre, Right or Natural
A column defined with Natural alignment with align the contents based upon the script used within it. For languages that run right-to-left, such as Arabic or Hebrew, right alignment will be used. For languages that display left-to-right left alignment will be used. It is also possible to mix languages within the single column and each row will display with the appropriate alignment based on it's contents. For example:
Enter the width of the column in pixels. Click the button to automatically calculate the width based upon the current data.
Any number of filters can be defined for each column in a dataset. Filters work with any type of data column.
Each filter can compare the value of each observation for a particular variable with a constant. Once defined, these filters may be applied, as required, when performing analyses. Filter have a to allows you to select them when performing analyses. The following operators are available:
| = | True when the value equals the constant |
| <> | True when the value does not equal the constant |
| > | True when the value is greater than the constant |
| < | True when the value is less than the constant |
| >= | True when the value is greater than or equal to the constant |
| <= | True when the value is less than or equal to the constant |
Clicking on a filter in the Filters list will update the Filters preview panel to show only rows that match the filter being defined.
This tab is shown when the column type is Code List, it is shown instead of the Filters tab. It allows you to define labels for values in the column. For example 1 = Male, 2 = Female.
Each entry consists of a Code and a Label
Clicking on a code list entry in the Code List panel will update the Filters preview panel to show only rows that match the item being defined.
Allows you to define the axis label for the variable when used in a graph. If left blank the Variable name will be used.
Allows configuration of the axis for this column when used in any type of plot. Choose from:
Values outside of a manual axis will not be included in the plot.Sets the minimum value for the axis
Sets the maximum value for the axis
Sets the number of divisions on the axis.
Open the help system for this dialog.
Saves the configuration for the current column and moves to the previous column.
Saves the configuration for the current column and moves to the next column.
Closes the Column Properties dialog and abandons the changes to the current column
Saves the configuration for the current column and closes the dialog box.
Warnings and errors are shown in the bottom left side of the dialog box. They are displayed in red. You must correct the issue before you can save any changes to the column.