The SAS Data Set Characterization Utility
Most SAS programmers reach for two tools when they first receive a new SAS data set: PROC CONTENTS and PROC MEANS. They use PROC CONTENTS to review the data set metadata; the physical attributes of the variables such as name, label, type and length. They use PROC MEANS to determine the basic arithmetic characteristics of the numerical variables, such as the minimum, maximum and mean values. Doing this involves running two different SAS procedures, combing through two separate reports generated by SAS, and correlating the information about specific variables between the disparate reports. The SAS data set characterization utility generates a single report file that contains the best of both the CONTENTS and the MEANS procedures. It produces an Excel file with a single row of consolidated metrics for each variable found in the SAS data set. The variable’s metrics include its key metadata attributes, and for numeric variables its basic statistical metrics. Additionally, the report contains the number of missing values for character and numeric variables. Consequently, SAS programmers can utilize this utility to determine both the composition and the characteristics of a new SAS data set from a single amalgamated report. This presentation provides the details of the SAS data characterization utility and provides information on how SAS programmers can begin using it right away. PRESENTER: Michael Raithel, Westat SESSION ID: 1027 TOPIC: Programming: General Programming INDUSTRY: Non-Industry Specific AUDIENCE: Analyst, Business Analyst, Programmer SKILL LEVEL: Intermediate Learn more about SAS software ◉ Free SAS Online Training - https://www.sas.com/en_us/training/offers/free-training.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=RpLlL98Eo08 ◉ Contact SAS - https://www.sas.com/en_us/contact.geo.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=sgf-4406690&utm_content=RpLlL98Eo08 SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_confirmation=1 ABOUT SAS SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change. CONNECT WITH SAS SAS ► https://www.sas.com/contact SAS Customer Support ► https://support.sas.com SAS Communities ► https://communities.sas.com SAS Analytics Explorers ► https://explorers.sas.com Facebook ► https://www.facebook.com/SASsoftware Twitter ► https://www.twitter.com/SASsoftware LinkedIn ► https://www.linkedin.com/company/sas Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss