As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Tips:Detailed Directory Listing from PROC CONTENTS

From sasCommunity
Jump to: navigation, search

You can get a detailed directory listing of the files in a SAS data library without having to print all of the detail information for each and every SAS data set in it.

proc contents data    = sashelp._all_
              memtype = data
              details
              nods;
run;

The code (at right) produces a Library Members listing (notice the use of _ALL_ to select all the data sets in SASHELP):

The DETAILS option enables the more detailed "Library Members" listing and the NODS option turns off that pesky listing of individual data set details. The listing is called "Library Members" and contains the following information:

  • Name - Name of the SAS data set, Index, Catalog, etc.
  • Member Type - Data, Index, Catalog, etc.
  • Level - If the SAS data library is composed of concatenated directories, this is the concatenation level at which this file can be found
  • Obs, Entries, or Indexes - The number of: Observations if a SAS data set, Entries if a SAS catalog, and Indexes if an Index file
  • Vars - Number of variables if this is a SAS data set
  • Label - The label if the file has one
  • File Size - Size of the file
  • Last Modified - Date-time stamp of when the file was last modified

This is great information to have if you need to conduct a quick visual inspection of a SAS data library you are not familiar with.

Submitted by Michael A. Raithel, The man who wrote the book on performance. Contact me at my Discussion Page.