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

CHANNEL Data Integration
Likes 37 Likes 37  
COURSE Inputs & Outputs
Likes 12 Likes 12  
COURSE Introduction to Data Sets
Likes 36 Likes 36  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Creating & Reading Data Sets
Likes 25 Likes 25  
COURSE Introduction to Data Sets
Likes 36 Likes 36  
COURSE Inputs & Outputs
Likes 12 Likes 12