JMP Genomics Starter | SAS Data Set Utilities | Tables

Tables
Click on a button corresponding to a SAS data set table utility. These utilities can be grouped into four major purposes: inspection, consolidation, reduction, and reversible reorganization. A multi-purpose DATA STEP utility is also available.
Inspection
The Column Contents process is an excellent way to quickly view all or part of a data set, and obtain a high-level summary along with detailed variable attributes. It can also be used in planning for, and verifying the outcome of, other utilities.
Consolidation
Two major operations can be performed to consolidate data from multiple data sets into one. They are outlined below.
Rowwise
Columnwise
Reduction
Using the Subset utility, a data set can be subsetted based on observation filter criteria and variables to drop. Therefore, both rows and columns can be reduced in the output subset data set.
Reorganization
Processes for reversible stacking and transposition of tables are available. They are outlined below.
Converting a tall SAS data set and Experimental Design Data Set (EDDS) into a stacked SAS data set where all observations of interest are placed in a single column.
Converting a stacked SAS data set into a tall SAS data set and corresponding EDDS.
Tall or wide transposition (see Tall and Wide Data Sets) with the use of an EDDS
Converting a tall SAS data set (samples as columns, molecular entity as rows) and EDDS into a wide SAS data set (samples as rows, molecular entity as columns).
Converting a wide SAS data set (samples as rows, molecular entity as columns) into a tall SAS data set (samples as columns, molecular entity as rows) and EDDS.
General transposition of columns and rows without the use of an EDDS
This reversible process is not tall- or wide-specific.
Multi-purpose DATA STEP Utility
A very general mechanism for performing ad hoc manipulations and modifications on a SAS data set is available in the DATA Step process.
Caution: This process requires knowledge of SAS DATA Step and other commands. Please refer to Base SAS documentation (http://support.sas.com/documentation/) for more information. You should not attempt to use this process unless you have some experience with SAS programming.
See SAS Data Set Utilities for other subcategories.