Data Manipulation

SAS 9    |    Beginner
  • 13 Videos | 54m 32s
  • Earns a Badge
Likes 19 Likes 19
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

  • Playable
    1. 
    Executing Statements Conditionally
    4m 23s
    UP NEXT
  • Playable
    2. 
    Using the ELSE Statement in a Conditional
    3m 31s
  • Locked
    3. 
    Using IF and WHERE to Subset Observations
    4m 32s
    FREE ACCESS
  • Locked
    4. 
    Using IF-THEN DELETE to Subset Observations
    3m 18s
    FREE ACCESS
  • Locked
    5. 
    Combining SAS Data Sets
    2m 15s
    FREE ACCESS
  • Locked
    6. 
    Using APPEND to Combine Data Sets
    5m 48s
    FREE ACCESS
  • Locked
    7. 
    Using the FORCE option to an APPEND Procedure
    3m 46s
    FREE ACCESS
  • Locked
    8. 
    Using SET in a DATA Step to Concatenate Data Sets
    3m 56s
    FREE ACCESS
  • Locked
    9. 
    Using RENAME to Change Variable Names
    3m 39s
    FREE ACCESS
  • Locked
    10. 
    Merging Data Sets One-To-One
    3m 9s
    FREE ACCESS
  • Locked
    11. 
    Merging Data Sets One-To-Many
    2m 18s
    FREE ACCESS
  • Locked
    12. 
    Merging Data Sets with Nonmatches
    4m 56s
    FREE ACCESS
  • Locked
    13. 
    Exercise: Validating, Cleaning, and Combining Data
    9m 1s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

COURSE Creating & Reading Data Sets
Likes 29 Likes 29  
CHANNEL Data Visualization
Likes 66 Likes 66  
CHANNEL Data Integration
Likes 55 Likes 55  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Introduction
Likes 97 Likes 97  
BOOK SAS Certified Specialist Prep Guide: Base Programming Using SAS 9.4
COURSE Creating Reports
Likes 16 Likes 16