Working with Arrays & Restructuring and Merging Data Sets

SAS 9    |    Beginner
  • 14 videos | 52m 28s
  • Earns a Badge
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Merging data is a fundamental function of data manipution. Combining loops and arrays simplifies processing of repetitive data with minimal coding. Explore arrays and techniques for restructuring and combining data, including match merges.

WHAT YOU WILL LEARN

  • Describe the characteristics of arrays in sas
    Create an array in sas
    Process all the elements of an array in a sas program
    Create variables in an array in sas
    Perform calculations using arrays and the keyword of in sas
    Assign initial values in an array statement in sas
    Use the transpose procedure to manipulate data sets in sas
  • Use the transpose procedure to rotate data sets in sas
    Perform a match-merge on sas data sets
    Control a match-merge with output, drop, keep, first, and last
    Merge data sets with no common variable by using a series of separate data steps
    Use sas/access libname to match-merge a sas data set with an excel workbook
    Use rename to match-merge data sets with same-named variables
    Create and process an array and merge data sets in sas

IN THIS COURSE

  • 2m 12s
  • 4m 4s
  • Locked
    3.  Processing a SAS Array
    2m 52s
  • Locked
    4.  Using SAS Arrays to Create Variables
    5m 40s
  • Locked
    5.  Using SAS Arrays to Perform Calculations
    2m 44s
  • Locked
    6.  Assigning Initial Values to an Array
    3m 56s
  • Locked
    7.  Using the TRANSPOSE Procedure to Manipulate Data
    2m 44s
  • Locked
    8.  Rotating a Data Set with the TRANSPOSE Procedure
    2m 44s
  • Locked
    9.  Match-merging SAS Data Sets
    4m 25s
  • Locked
    10.  Manipulations with a Match-merge
    4m 45s
  • Locked
    11.  Match-merging Data Sets That Lack a Common Variable
    3m 28s
  • Locked
    12.  Match-merging a SAS Data Set and an Excel Workbook
    4m 4s
  • Locked
    13.  Match-merging Data Sets with Same-named Variables
    3m 10s
  • Locked
    14.  Exercise: Process an Array and Merging Data Sets
    5m 42s

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

Channel Data Visualization
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Channel Data Integration
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)

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 Inputs & Outputs
Rating 4.5 of 30 users Rating 4.5 of 30 users (30)
Book SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4