Customized Tools

%chkfreq Macro

Before analyzing any data, it is essential to have an overview of your data.

What variables are available? What are the possible values for each variable? How often do they occur? Are there any unusual values that need to be checked? What about the values of several variables combined?

The %chkfreq routine allows you to extract all this information into an Excel file.

Each tab contains a summary of a table: the list of variables, their values, and their frequencies.

How would you like to have access to this standard tool with validation documentation tailored to your company’s requirements?

Free Access to PROC DATASETS Tip Sheet! Email Me the Tip Sheet!