Process Description

Transpose Tall to Wide

Most of the processes in JMP Genomics software assume that the input SAS data set has a particular data structure. JMP Genomics software distinguishes between tall and wide SAS data sets.

A tall SAS data set has samples as columns, and molecular entity (such as marker, gene, clone, protein, or metabolite) as rows.

A wide SAS data set is the transpose of a tall data set, having the samples as rows and molecular entity as columns.

When specifying the input SAS data set for a process, it is important to know the required form. Most of the processes associated with genetic analyses require a wide structure, whereas most of those for microarray and proteomics analyses use a tall structure.

The Transpose Tall to Wide data set utility transposes a tall SAS data set into a wide SAS data set.

What do I need?

Two data sets are needed to transpose tall to wide. The first is the tall data set to be transposed, A second data set, the Experimental Design Data Set (EDDS), is needed to transpose from tall to wide. This required data set tells how the experiment was performed, providing information about the columns of the primary experimental data.

For detailed information about the files and data sets used or created by JMP Genomics software, see Files and Data Sets.

Output/Results

One wide output data set is generated by this process.