Data Errors & Validation

SAS 9    |    Beginner
  • 13 videos | 43m 17s
  • Earns a Badge
Rating 4.2 of 37 users Rating 4.2 of 37 users (37)
If data values do not correlate to SAS statements, data errors will be detected during program execution. Explore data errors and the process of validating and cleaning data.

WHAT YOU WILL LEARN

  • Describe how sas handles errors in raw data files
    Describe procedures and techniques for validating and cleaning data in sas
    Use the sas log to examine data errors
    Use conditionals to handle data errors in sas
    Use the print procedure with the where statement to validate data in sas
    Use the freq procedure with the tables statement to validate data in sas
    Use the means procedure with the var statement to validate data in sas
  • Use the univariate procedure with the var statement to validate data in sas
    Open the source data to clean data for sas
    Use assignment statements in the data step to clean data in sas
    Use if-then and else statements in the data step to clean data in sas
    Use the assignment statement in the data step to create variables in sas
    Use operators, including sas functions, to create data values

IN THIS COURSE

  • 4m 12s
  • 4m 14s
  • Locked
    3.  Examining Data Errors
    4m 35s
  • Locked
    4.  Handling Data Errors
    2m 57s
  • Locked
    5.  Validating Data Using PRINT and WHERE
    3m 1s
  • Locked
    6.  Validating Data Using FREQ and TABLES
    3m 59s
  • Locked
    7.  Validating Data Using MEANS and VAR
    2m 58s
  • Locked
    8.  Validating Data Using UNIVARIATE and VAR
    3m 13s
  • Locked
    9.  Cleaning Data at the Source
    3m 12s
  • Locked
    10.  Cleaning Data Using Assignment Statements
    2m 22s
  • Locked
    11.  Cleaning Data Using Conditionals in the DATA Step
    2m 30s
  • Locked
    12.  Creating Variables with DATA Step Assignments
    3m 31s
  • Locked
    13.  Creating Values Using Operators and SAS Functions
    2m 33s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel SAS
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Channel DigComp
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Scrum Foundation: Best Practices
Rating 4.6 of 99 users Rating 4.6 of 99 users (99)
Book SAP S/4HANA Financial Accounting Configuration: Learn Configuration and Development on an S/4 System, Second Edition
Course Working with Arrays & Restructuring and Merging Data Sets
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)