Data Manipulation
SAS 9
13 Videos | 57m 32s - Earns a Badge
Depending on the situation, you may need to manipulate a SAS data set to generate the desired analytical report. Explore the manipulation of data sets, including merging and combining sets.
WHAT YOU WILL LEARN
-
use the IF-THEN statement and the IF-THEN DO statement to execute statements conditionally in SAS
use the ELSE statement to execute alternative actions in an IF-THEN statement in SAS
use the subsetting IF statement and the WHERE statement to subset observations in SAS
use the IF-THEN DELETE statement to subset observations in SAS
describe the methods for combining data sets in SAS
use the APPEND procedure to append a SAS data set to another SAS data set
use the FORCE option with the APPEND procedure to append one SAS data set to another SAS data set -
use the SET statement in a DATA step to concatenate two or more SAS data sets
use the RENAME= data set option to change the names of variables in SAS
merge SAS data sets one-to-one based on a common variable using MERGE and BY statements in a DATA step
merge SAS data sets one-to-many based on a common variable using MERGE and BY statements in a DATA step
use the IN= option to control the observations in the output SAS data set
validate and clean data sets and combine them with an append operation and a concatenation
IN THIS COURSE
-
1.Executing Statements Conditionally4m 23sUP NEXT
-
2.Using the ELSE Statement in a Conditional3m 31s
-
3.Using IF and WHERE to Subset Observations4m 32s
-
4.Using IF-THEN DELETE to Subset Observations3m 18s
-
5.Combining SAS Data Sets2m 15s
-
6.Using APPEND to Combine Data Sets5m 48s
-
7.Using the FORCE option to an APPEND Procedure3m 46s
-
8.Using SET in a DATA Step to Concatenate Data Sets3m 56s
-
9.Using RENAME to Change Variable Names3m 39s
-
10.Merging Data Sets One-To-One3m 9s
-
11.Merging Data Sets One-To-Many2m 18s
-
12.Merging Data Sets with Nonmatches4m 56s
-
13.Exercise: Validating, Cleaning, and Combining Data9m 1s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.
