Working with Arrays & Restructuring and Merging Data Sets

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

  • Playable
    1. 
    SAS Array Overview
    2m 12s
    UP NEXT
  • Playable
    2. 
    Creating a SAS Array
    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 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 37 Likes 37  
Likes 12 Likes 12  
Likes 36 Likes 36  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 25 Likes 25  
Likes 36 Likes 36  
Likes 12 Likes 12