Columns

Click on a button corresponding to a SAS data set column utility. Refer to the table below for guidance.

Process	Choose this process for...
Change Labels	Creating, removing, or changing the labels for one or more variables in a SAS data set
Change Lengths	Changing the lengths of variables in a SAS data set Tip: Reduce disk space and computational time by shortening long character variables. Note: This process does not change the length of numeric variables.
Rename	Renaming one or more primary data variables in a tall data set, and creating a new Experimental Design Data Set (EDDS) to accompany it
Reorder	Rearranging the column order in a data set Tip: This is especially useful for reorganizing a data set formed by merging two or more disparate data sets.
Filter Wide Columns Based on Tall Rows	Removing columns from a wide data set based on a filter specified using variables from the corresponding tall data set to filter its rows
Combine Columns	Combining columns of a tall data set together, computing a summary statistic, and creating an accompanying reduced EDDS Example: This process can be used to average and combine replicate runs of data from an experiment into one column.
Statistics for Columns	Computing a variety of summary statistics for variables in a SAS data set
Transform	Modifying a SAS data set by performing a mathematical transformation on all specified variables

See SAS Data Set Utilities for other subcategories.