Working with Arrays & Restructuring and Merging Data Sets
SAS 9
| Beginner
- 14 Videos | 52m 28s
- Earns a Badge
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 SAScreate an array in SASprocess all the elements of an array in a SAS programcreate variables in an array in SASperform calculations using arrays and the keyword OF in SASassign initial values in an ARRAY statement in SASuse the TRANSPOSE procedure to manipulate data sets in SAS
-
use the TRANSPOSE procedure to rotate data sets in SASperform a match-merge on SAS data setscontrol a match-merge with OUTPUT, DROP, KEEP, FIRST, and LASTmerge data sets with no common variable by using a series of separate DATA stepsuse SAS/ACCESS LIBNAME to match-merge a SAS data set with an Excel workbookuse RENAME to match-merge data sets with same-named variablescreate and process an array and merge data sets in SAS
IN THIS COURSE
-
1.SAS Array Overview2m 12sUP NEXT
-
2.Creating a SAS Array4m 4s
-
3.Processing a SAS Array2m 52s
-
4.Using SAS Arrays to Create Variables5m 40s
-
5.Using SAS Arrays to Perform Calculations2m 44s
-
6.Assigning Initial Values to an Array3m 56s
-
7.Using the TRANSPOSE Procedure to Manipulate Data2m 44s
-
8.Rotating a Data Set with the TRANSPOSE Procedure2m 44s
-
9.Match-merging SAS Data Sets4m 25s
-
10.Manipulations with a Match-merge4m 45s
-
11.Match-merging Data Sets That Lack a Common Variable3m 28s
-
12.Match-merging a SAS Data Set and an Excel Workbook4m 4s
-
13.Match-merging Data Sets with Same-named Variables3m 10s
-
14.Exercise: Process an Array and Merging Data Sets5m 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.