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

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

Tip of the Day:September 4

From sasCommunity
Jump to: navigation, search

sasCommunity Tip of the Day

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

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.

Feel free to comment on this tip.

Prior tip - Next tip - Random Tip

Submit a Tip