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 Next-Gen Sequencing for other subcategories.