Data Errors & Validation
SAS 9
| Beginner
- 13 videos | 43m 17s
- Earns a Badge
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
-
3. Examining Data Errors4m 35s
-
4. Handling Data Errors2m 57s
-
5. Validating Data Using PRINT and WHERE3m 1s
-
6. Validating Data Using FREQ and TABLES3m 59s
-
7. Validating Data Using MEANS and VAR2m 58s
-
8. Validating Data Using UNIVARIATE and VAR3m 13s
-
9. Cleaning Data at the Source3m 12s
-
10. Cleaning Data Using Assignment Statements2m 22s
-
11. Cleaning Data Using Conditionals in the DATA Step2m 30s
-
12. Creating Variables with DATA Step Assignments3m 31s
-
13. Creating Values Using Operators and SAS Functions2m 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.
