BeOptimized - Tips and Tricks

Get dataset metadata info using functions and dictionary tables

Getting quickly metadata information on your datasets could be useful in some context of conditional execution of SAS programs (e.g.: Don't execute this step if empty dataset). Different methods exists to achieve that: using metadata functions, using Proc contents, or dictionary tables.

Details

This tips and tricks will describe different methods which can be used to extract metadata information from your datasets :

  • Use SAS function together with macros
  • Use Proc Contents but store information in dataset as the place of report
  • Use dictionary tables.
All the methods will be used on a sample dataset and we will compare them on the basis of the pro's and con's.

Prerequisites

You have some SAS experience and would like to get information on your metadata.


Go back to your selection


This site uses cookies. .

By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.