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.