Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
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.

c0227.gif (5910 bytes)

Figure 2.27: 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.

Chapter Contents
Chapter Contents
Previous
Previous
Next
Next
Top
Top

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.