The DATASETS Procedure

Example 5: Describing a SAS Data Set

Procedure features:

CONTENTS statement option:

DATA=

Other features:

SAS data set option:

READ=

This example shows the output from the CONTENTS statement for the GROUP data set. The output shows the modifications made to the GROUP data set in Modifying SAS Data Sets.

Program

options pagesize=40 linesize=80 nodate pageno=1;

LIBNAME health 'SAS-library';

proc datasets library=health nolist;

   contents data=group (read=green) out=grpout;
   title  'The Contents of the GROUP Data Set';
run;

Output

The Contents of the GROUP Data Set

    
                       The Contents of the GROUP Data Set                      1

                             The DATASETS Procedure

Data Set Name        HEALTH.GROUP                     Observations          148
Member Type          DATA                             Variables             11
Engine               V9                               Indexes               1
Created              Wed, Sep 12, 2007 01:57:49 PM    Observation Length    96
Last Modified        Wed, Sep 12, 2007 04:01:15 PM    Deleted Observations  0
Protection           READ                             Compressed            NO
Data Set Type                                         Sorted                YES
Label                Test Subjects
Data Representation  WINDOWS_32
Encoding             wlatin1  Western (Windows)


                       Engine/Host Dependent Information

Data Set Page Size          8192
Number of Data Set Pages    4
First Data Page             1
Max Obs per Page            84
Obs in First Data Page      63
Index File Page Size        4096
Number of Index File Pages  2
Number of Data Set Repairs  0
Filename                    c:\Documents and Settings\mydir\My
                            Documents\procdatasets\health\group.sas7bdat
Release Created             9.0201B0
Host Created                XP_PRO

                   Alphabetic List of Variables and Attributes

 #   Variable   Type   Len   Format    Informat   Label

 9   BIRTH      Num      8   DATE7.    DATE7.
 4   CITY       Char    15
 3   FNAME      Char    15
10   HIRED      Num      8   DATE7.    DATE7.

                       The Contents of the GROUP Data Set                      2

                             The DATASETS Procedure

                   Alphabetic List of Variables and Attributes

 #   Variable   Type   Len   Format    Informat   Label

11   HPHONE     Char    12
 1   IDNUM      Char     4
 7   JOBCODE    Char     4
 2   LNAME      Char    15
 8   SALARY     Num      8   COMMA8.              current salary excluding bonus
 6   SEX        Char     2
 5   STATE      Char     3


                    Alphabetic List of Indexes and Attributes

                                                # of
                          Unique    NoMiss    Unique
            #    Index    Option    Option    Values    Variables

            1    vital    YES       YES          148    BIRTH SALARY


                                Sort Information

                              Sortedby       LNAME
                              Validated      NO
                              Character Set  ANSI

Top of Page