Reporting on SAS Information Maps

5

Like any good SAS professional, I subscribe to the SAS Samples RSS feed. The other day I found this sample that shows how to create a PDF report about the contents of a SAS Information Map.

It's a nice example: it shows how to use the INFOMAPS engine and ODS to create a simple report to show what's in an information map. But we can do much more. Information Maps are a richer data source than regular SAS data sets: they can contain calculations, folders, filters, and more.

Here is an example that I wrote that shows:

  • Information maps in a particular SAS folder
  • The data items for a particular map, including the folder hierarchy, item type (category or measure), description, and SAS syntax name
  • The list of filters, if any, that are defined for the information map, including folder hierarchy, descriptions, and an indication as to whether the filter includes one or more prompts

The example uses the new Information Map dictionary tables that were added in SAS 9.2. (Note: this example reports only on relational information maps, not OLAP. The INFOMAPS engine does not support OLAP data sources.)

The complete SAS program is available here, and this link is an example of the result. The following picture is an excerpt from the report you'll get.

Sample output

If you want to create a SAS program that reads the actual data rows from a map, that's easy. Use SAS Enterprise Guide to open the Information Map into your project. You'll wind up with a task and SAS program as part of your process flow. You can run the task just as it is, or copy the code and adapt it for your own use.

Share

About Author

Chris Hemedinger

Senior Manager, SAS Online Communities

+Chris Hemedinger is the manager of SAS Online Communities. Since 1993, Chris has worked for SAS as an author, a software developer, an R&D manager and a consultant. Inexplicably, Chris is still coasting on the limited fame he earned as an author of SAS For Dummies.  He also hosts the SAS Tech Talk webcasts each year from SAS Global Forum, connecting viewers with smart people from SAS R&D and the impressive work that they do.

5 Comments

  1. Chris Gerdvil on

    This is a very usefull tip. But, how do I programmatically determine the data table the Information map is dependant on?

  2. Yes, just confirmed this. Try something like:

    proc infomaps ;
    update infomap "Cars" mappath="/Shared Data/Maps";
    list datasources;
    run;

    The output goes to the SAS log:

    Total datasources: 1

    Data source: Sample Data.CARS_1993
    ID: CARS_1993
    Name: CARS_1993
    Description:

  3. Pingback: Five strategies to eliminate passwords from your SAS programs - The SAS Dummy

  4. Pingback: Which tables contribute to that SAS information map? - The SAS Dummy

Leave A Reply

Back to Top