SAS Tutorial | Missing value imputation using SAS

SAS Users
9,964 views April 12, 2021

What is missing value imputation and how do you do it? In this SAS How To Tutorial, SAS’ Jeff Thompson explains why you may encounter missing values (“missingness”) and three ways to impute a missing value: 1) Plug in a summary statistic 2) Use a distributional method 3) Build a model using variables that don’t have missing information to predict the variable that is missing He then walks through a few pipeline examples to impute missing values in SAS Model Studio. Download the Data Access the data Jeff’s uses on GitHub: https://github.com/sascommunities/sas-howto-tutorials/tree/master/modelcomparison Content Outline 00:00 – Intro 00:14 – What is missing value imputation? 00:40 – Three reasons you may encounter missing values (“missingness”) 03:02 – Modeling algorithms that can handle missing values 03:27 – Ways to impute a missing value overview 04:46 – Trick: using missing value indicators can give you better predictive models 05:21 – Demo in SAS Model Studio: study the data for missingness 06:48 – Review model pipelines to handle the missing values 06:57 – Pipeline example: No impute; building a model using complete case analysis 14:29 – Pipeline example: Distribution impute 15:59 – Pipeline example: Indicators and default impute 21:23 – Compare the models Other videos from Jeff: ◉ How to compare models in SAS – https://www.youtube.com/watch?v=jRr3yrRKZp4 ◉ Transforming Variables in SAS – https://www.youtube.com/watch?v=zzz1QJlYJq8 Learn more about SAS Software ◉ AI and machine learning courses – https://www.sas.com/en_us/training/programs/aiml-courses.geo.html ◉ Machine Learning Using SAS Viya Training – https://learn.sas.com/course/view.php?id=343 ◉ AI & Machine Learning Professional Training – https://www.sas.com/en_us/training/academy-data-science/ai-machine-learning-certification.html?utm_source=youtube.com&utm_medium=referral&utm_campaign=learn-certification ◉ Learn about Model Studio – https://support.sas.com/en/software/model-studio-support.html ◉ Video: How to Choose a Machine Learning Algorithm with Aurora – https://www.youtube.com/watch?v=-oZcf0QEzYM ◉ SAS Studio Community – https://communities.sas.com/t5/SAS-Studio/bd-p/sas_studio ◉ SAS Solutions for Data Scientists – https://www.sas.com/sas/offers/data-science-experience.html SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS 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 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

Keyboard shortcuts

On. Switch them off if they collide with your assistive tools; ? still opens this sheet.

Go to

Press g then the letter.

  • gh Latest
  • gs Sources
  • gm Media
  • gv Videos
  • gp Podcasts
  • gc Calendar
  • gd Decoder
  • gz Dataviz
  • ga Datasets
  • gb Blog
  • gk Markets
  • gj Careers
  • gn Prompt Notebook

On this page

  • / Focus search, where there is one
  • t Back to top
  • ? This list
  • Esc Close