Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Cutting-Edge Techniques and SAS Macros to Clean, Prepare and Manage Data

SAS Users
34K subscribers
<__slot-el>
<__slot-el>
1.6K views 3 years ago #LearnSAS #SASUsers #SASGF
This presentation provides an overview of a new SAS book, The Data Detectives Toolkit: Cutting-Edge Techniques and SAS Macros to Clean, Prepare and Manage Data, which helps you keep data preparation on schedule and within budget. You will discover efficient and low-cost ways to automate creating project documentation, such as codebooks describing your variables, catalogues describing your data sets and crosswalks showing the relationship of variables across data sets. These macros also automatically create quality control reports identifying the anomalies in your data, including out-of-range values, incomplete format definitions, v …...more
...more
Cutting-Edge Techniques and SAS Macros to Clean, Prepare and Manage Data
This presentation provides an overview of a new SAS book, The Data Detectives Toolkit: Cutting-Edge Techniques and SAS Macros to Clean, Prepare and Manage Data, which helps you keep data preparation on schedule and within budget. You will discover efficient and low-cost ways to automate creating project documentation, such as codebooks describing your variables, catalogues describing your data sets and crosswalks showing the relationship of variables across data sets. These macros also automatically create quality control reports identifying the anomalies in your data, including out-of-range values, incomplete format definitions, validation of skip patterns, variables with no variation in their value, variables missing labels or assigned formats. The only requirement for producing these documents and reports is having SAS data sets with formats and labels. Traditionally, these documents are produced at the end of the project with a great deal of programming and manual effort, but these tools allow the programmer to seamlessly create these documents and reports at any time during the data preparation task. Producing these documents early in data collection improves data quality, as well as communication between the data collection team and client. The SAS macros covered in this presentation are provided as open source code and can be downloaded from the SAS author page for this book. PRESENTER: Kim Chantala, RTI International SESSION ID: 1177 TOPIC: Data Management INDUSTRY: Government (Federal, State and Local), Health Care AUDIENCE: Analyst, Progammer,Researcher SKILL LEVEL: Intermediate Learn more about SAS software ◉ Free SAS Online Training - https://www.sas.com/en_us/training/of... ◉ Contact SAS - https://www.sas.com/en_us/contact.geo... SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS #SASGF https://www.youtube.com/SASUsers?sub_... 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 ►   / sassoftware   Twitter ►   / sassoftware   LinkedIn ►   / sas   Blogs ► https://blogs.sas.com RSS ►https://www.sas.com/rss

Follow along using the transcript.

SAS Users

34K subscribers