SAS® 9.4 Cert Prep: Part 03 Exploring and Validating Data

Offered By: LinkedIn Learning

Tags

Sass Courses Data Analysis Courses Data Sorting Courses Data Validation Courses Data Exploration Courses Data Formatting Courses

Course Description

Overview

Prepare to take the SAS 9.4 certification exam. Learn how to explore and validate SAS data, in this SAS Institute cert prep course.

Syllabus

Introduction

Sort your data with SAS

1. Exploring Data

Exploring data with procedures
Demo: Exploring data with SAS procedures

2. Filtering Rows

Filtering rows with the WHERE statement
Combining expressions in a WHERE statement
Demo: Filtering rows with basic operators
Using special WHERE operators
Creating and using macro variables
Demo: Filtering rows using macro variables

3. Formatting Columns

Formatting data values in results
Common formats for numeric values
Common formats for date values
Demo: Formatting data values in results

4. Sorting Data and Removing Duplicates

Sorting data
Identifying and removing duplicates
Demo: Identifying and removing duplicate values

Taught by

SAS Institute

Related Courses

Rails with Active Record and Action Pack
Johns Hopkins University via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn Everyday Excel, Part 1
University of Colorado Boulder via Coursera Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera