Table Attributes Task :: SAS(R) Studio 3.3: User's Guide

About the Table Attributes Task

The Table Attributes task enables you to create these types of reports:

a default report that includes the following data attributes: the date on which the table was created and last modified, the number of rows, the encoding, any engine-dependent or host-dependent information, and an alphabetic list of the variables and their attributes.
an enhanced report displays the table and variable attributes. Unlike the default report, you can specify the order of the contents in the report. From this report, you can determine the table type, the date on which the table was created and modified, the number of observations, the variable labels, and the variable types.

In this example, you want to view the table attributes for the Sashelp.Pricedata data set.

To create this example:

In the Tasks section, expand the Data folder and double-click Table Attributes. The user interface for the Table Attributes task opens.
On the Data tab, select the SASHELP.PRICEDATA data set.
On the Options tab, deselect the Default report check box.
To run the task, click .

Here is a subset of the results for the Table Attributes task. These results are the enhanced report for the Sashelp.Pricedata data set.

An output data set also opens on the WORK.TableAttributes tab.

Option Name	Description
Default report	contains the output from the DATASETS procedure. This report includes the following data attributes: the date on which the table was created and last modified, the number of observations, the encoding, any engine-dependent or host-dependent information, and an alphabetic list of the variables and their attributes.
Enhanced report	contains the output from the DATASETS procedure. The REPORT procedure is used to create the enhanced report. This report displays the table and variable attributes. From this report, you can determine the table type, the date on which the table was created and modified, the number of observations, the variable labels, and the variable types.
Sort variables by	sorts the rows in the variable table by variable name, variable order in the table, variable type, variable format, or variable label. Note: This option affects only the enhanced report.
Order sequence	specifies whether to sort the rows in the table by ascending or descending order. Note: This option affects only the enhanced report.
Location to save output data	specifies the location of the output table. By default, this table is saved to the temporary Work library.