A custom task to check your data cardinality

6

The other day I showed how to check your data cardinality by using a simple SAS program. I also promised to provide a custom task that makes the process even easier within SAS Enterprise Guide.

Today I'm delivering on that promise. I've just added the custom task to the support.sas.com site. Here's what it looks like:

This task has two useful features. First, it allows you to interactively view the cardinality of your data variables. Click the Get cardinalities button to submit a small SAS program that counts the unique data values. As long as the data are not too large, the operation can complete quickly – perhaps in a few seconds. The task offers a Cancel option if it takes too long.

Second, the task creates an output data set and simple report that contain the calculated cardinalities.

The task works with SAS Enterprise Guide 4.3 and later. The simple instructions for installing and using it are in the README.pdf file that's included in the package.

>> Download the "Check Data Cardinality" task

Related topics

Your data ain't good looking, but it has a nice cardinality
How to store data about your data in your data

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.

6 Comments

  1. Pingback: Your data ain’t good looking, but it has a nice cardinality - The SAS Dummy

  2. Fails on 30 million rows, runs out of memory, probably too many unique values! Still, it is a very handy tool for smaller datasets. And I really like when we can use these without admin privileges (just add a dll to the right directory).

    • Chris Hemedinger
      Chris Hemedinger on

      Gady, thanks for sharing. SAS Enterprise Guide offers several built-in "PROC EYEBALL" techniques including the Characterize Data task, the Data Explorer (with "Quick Stats" feature), the Scatter Plots Matrix, and more.

  3. Pingback: 11 super-useful custom tasks for SAS Enterprise Guide - The SAS Dummy

Leave A Reply

Back to Top