Example: Transposing the Data in the CLASS Data Set

  1. In the Tasks section, expand the Data folder, and then double-click Transpose Data. The user interface for the Transpose Data task opens.
  2. On the Data tab, select SASHELP.CLASS as the input data set.
  3. To the Variables to transpose role, assign the Age, Height, and Weight variables.
  4. Under the Output Data Set heading, select the Show output data check box.
  5. On the Options tab, complete these steps:
    1. Clear the Use prefix check box.
    2. Select the Select a variable that contains the names of the new variables check box.
    3. To the New column names role, assign the Name variable.
  6. To run the task, click Submit SAS Code Icon.
The output data set contains a column for each student in the Sashelp.Class data set. The rows of the table are Age, Height, and Weight.
Subset of Work.Transpose Data Set
Copyright © SAS Institute Inc. All rights reserved.