VERBOSE= Table Option

Specifies whether the CONTENTS procedure output includes details about compressed blocks, data partition size, and indexes.

Valid in: SPD Server
Default: NO
Interaction: Corresponding macro variable is SPDSVERB.

Syntax

VERBOSE=YES | NO

Required Arguments

YES

requests detail information about compressed blocks, data partition size, and indexes. This option can be used only with PROC CONTENTS.

NO

suppresses detail information about compressed blocks, data partition size, and indexes. This is the default value.

Example

Request details of the compressed blocks, data partition size, and indexes for the table CLASS.
PROC CONTENTS data=mylib.class(verbose=yes);
run;
Output 14.4: Verbose Details for the Table CLASS
Engine/Host Dependent Information

             Blocking Factor (obs/block)                992
             ACL Entry                                  NO
             ACL User Access(R,W,A,C)                   (Y,Y,Y,Y)
             ACL UserName                               ANONYMOU
             ACL OwnerName                              ANONYMOU
             Data set is Ranged                         NO
             Data set is a Cluster                      NO
             Alphabetic List of Index Info              .
             Index                                      Name
             KeyValue (Min)                             Alfred
             KeyValue (Max)                             William
             # of Discrete values                       19
             Index                                      age_sex
             KeyValue (Min)                             11.000000   ,F
             KeyValue (Max)                             16.000000   ,M
             # of Discrete values                       11
             Compressed Info                            .
             # Compressed blocks                        1
             Raw data blocksize                         32736
             # blocks with overflow                     0
             Max overflow chain len                     0
             Block # for max chain                      0
             Min overflow area                          0
             Max overflow area                          0
             Data Partsize                              16793568

See Also

SPD Server macro variables:
Last updated: February 8, 2017