SPD Engine Data Set Options

LISTFILES= Data Set Option

Specifies whether the CONTENTS procedure lists the complete pathnames of all of the component files of an SPD Engine data set.

Valid in:	PROC CONTENTS only
Default:	NO

Syntax
Details
Example

Syntax

LISTFILES=YES | NO

YES: lists the complete pathnames of all of the component files of an SPD Engine data set.
NO: does not list the pathnames.

Details

The LISTFILES= data set option is used only with the SPD Engine and the CONTENTS procedure to list the complete pathnames of all of the component files of an SPD Engine data set.

Example

proc contents data=hrdept.names (listfiles=yes);

The following CONTENTS procedure output shows the complete pathnames of all of the component files:

LISTFILES=YES

                          The SAS System                         1

                      The CONTENTS Procedure

Data Set Name        HRDEPT.NAMES    Observations          1249854
Member Type          DATA            Variables             11     
Engine               SPDE            Indexes               1      
Created              Tuesday,        Observation Length    120    
                     October 02,                                  
                     2007 01:46:23                                
                     PM                                           
Last Modified        Tuesday,        Deleted Observations  0      
                     October 02,                                  
                     2007 01:47:21                                
                     PM                                           
Protection                           Compressed            NO     
Data Set Type                        Sorted                NO     
Label                                                             
Data Representation  WINDOWS_32                                   
Encoding             wlatin1                                      
                     Western                                      
                     (Windows)                                    

                Engine/Host Dependent Information

        Blocking Factor (obs/block)              546     
        Data Partsize                            16776960
        -   Alphabetic List of Index Info        -       
        Index                                    Id      
        KeyValue (Min)                           64587   
        KeyValue (Max)                           64587   
        Number of discrete values                1       
        -   Metadata Files                       -       
        d:\hrdir1\names.mdf.0.0.0.spds9          -       
        -   Data Files                           -       
        d:\hrdird\names.dpf.d__sasmb.0.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.1.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.2.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.3.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.4.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.5.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.6.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.7.2.spds9   -       
        d:\hrdird\names.dpf.d__sasmb.8.2.spds9   -       
        -   Index Files                          -       
        d:\hrdiri\names.idxid.d__sasmb.0.2.spds9 -       
        d:\hrdiri\names.hbxid.d__sasmb.0.2.spds9 -       

           Alphabetic List of Variables and Attributes
 
                  #    Variable      Type    Len

                  7    Address01     Char     27
                  8    Address02     Char      9
                  9    City          Char     12
                  3    CostCenter    Num       8
                  5    FirstName     Char      8
                  2    Id            Num       8

          Alphabetic List of Variables and Attributes
 
                  #    Variable      Type    Len

                  4    LastName      Char     18
                  6    MiddleName    Char      9
                 10    State         Char      2
                 11    ZipCode       Char     10
                  1    i             Num       8

             Alphabetic List of Indexes and Attributes
 
                                       # of
                                     Unique
                       #    Index    Values

                       1    Id            1

Top of Page