Data Manipulation with SAS

SAS 9    |    Beginner
  • 13 videos | 54m 32s
  • Earns a Badge
Rating 4.3 of 38 users Rating 4.3 of 38 users (38)
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
  • 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Data Analytics Tools
Rating 4.3 of 32 users Rating 4.3 of 32 users (32)
Book Data Analytics with SAS: Explore Your Data and Get Actionable Insights With the Power of SAS
Channel SAS
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Errors & Validation
Rating 4.2 of 37 users Rating 4.2 of 37 users (37)
Course The SAS Environment
Rating 4.3 of 117 users Rating 4.3 of 117 users (117)
Course Working with Arrays & Restructuring and Merging Data Sets
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)