Data Manipulation

SAS 9
  • 13 Videos | 57m 32s
  • Earns a Badge
Likes 14 Likes 14
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
  • Locked
    4. 
    Using IF-THEN DELETE to Subset Observations
    3m 18s
  • Locked
    5. 
    Combining SAS Data Sets
    2m 15s
  • Locked
    6. 
    Using APPEND to Combine Data Sets
    5m 48s
  • Locked
    7. 
    Using the FORCE option to an APPEND Procedure
    3m 46s
  • Locked
    8. 
    Using SET in a DATA Step to Concatenate Data Sets
    3m 56s
  • Locked
    9. 
    Using RENAME to Change Variable Names
    3m 39s
  • Locked
    10. 
    Merging Data Sets One-To-One
    3m 9s
  • Locked
    11. 
    Merging Data Sets One-To-Many
    2m 18s
  • Locked
    12. 
    Merging Data Sets with Nonmatches
    4m 56s
  • Locked
    13. 
    Exercise: Validating, Cleaning, and Combining Data
    9m 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.

YOU MIGHT ALSO LIKE

Likes 7 Likes 7  
Likes 35 Likes 35  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 8 Likes 8  
Likes 10 Likes 10  
COURSE SQL Developer
Likes 152 Likes 152