The Data Table

Splitting Columns

You can split selected columns to output a new column whenever the value of a variable changes. Select Data arrow Split Columns ... to display the Split Columns dialog.

Split Columns Dialog

Figure 2.22: Split Columns Dialog

Select a column from the candidate list and click on the Split Column button to designate a column to split.

Select a variable from the candidate list and click on the Split By button to designate a variable to split the first column by.

You can use the default names or type in new names for the split column if the type of the Split By column is character. Numeric columns do not have default names.

Previous | Next | Top of Page