Popis kurzu
Learn How To
- Apply your skills from SAS Programming 2
- Understand and control DATA step processing
- Manipulate data with functions
- Convert column type
- Create custom formats
- Merge tables
- Conditionally process data
- Restructure tables
Štruktúra kurzu
Case Study Kickoff
- Data Discovery
- SAS Programming 2 Review
Prepare Data
- Manipulate data with functions.
- Use special functions to convert column type.
- Direct DATA step output.
- Use conditional processing.
- Apply SAS formats.
- Use assignment statements to create new columns.
Merge Data
- Create and use a custom format.
- Sort data to prepare for merge.
- Merge tables and identify matching rows.
Transpose and Report
- Restructure data with the TRANSPOSE procedure.
- Manipulate transposed data to make meaningful reports.