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.
