Data Manipulation with SAS
SAS 9
| Beginner
- 13 videos | 54m 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
-
4m 23s
-
3m 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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
