• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
0- - 0
Job Meter = High

SAS Programming

30 Hours
Online Instructor-led Training
USD 1399 (USD 2800)
Save 50% Offer ends on 31-Dec-2023
SAS Programming course and certification
318 Learners

About this Course
After the course, attendees will have a thorough knowledge of the internals of the SAS System, be able to write advanced DATA Steps, combine and transpose SAS files and deal with many kinds of data manipulation problems, as well as being able to write more efficient programs.

Target Audience

SAS users who wish to extend their knowledge of SAS software. The course builds on the tools and techniques taught in the SAS Fundamentals course.

SAS Programming

Course Details & Curriculum

P1 DATA Step Internals

  • Course Objectives
  • Refresher on SAS and the SAS Environment
  • DATA Step Processing Logic
  • Compilation and Execution
  • Workshop Session

P2 Data Handling

  • Functions and Call Routines
  • Formatting Techniques
  • Workshop Session

P3 DATA Step Processing

  • Data Set Options
  • Select Statements
  • Loops
  • Arrays
  • Workshop Session

P4 Reading Data from SAS Files

  • SET Applications
  • Sampling from SAS Data Files (Optional)
  • Workshop Session

P5 Combining SAS Files

  • MERGE Applications
  • UPDATE Applications
  • Table Lookups
  • Workshop Session

P6 Summarising and Transposing Data

  • Data Summarisation
  • Data Transposition
  • DATA Step Methods (Optional)
  • Workshop Session

P7 Reading From/Writing to External Files

  • Review of Simple Methods
  • Format Modifiers
  • Files with Delimiters
  • Importing Data from Microsoft Excel
  • Read, Test and Read in the Rest (Optional)
  • Reading Files with a Constant Number of Repeating Groups (Optional)
  • Creating Reports using DATA_NULL_Steps (Optional)
  • Workshop Session

P8 Managing the SAS Environment

  • Data Libraries
  • Password Protection (Optional)
  • System Options and Utilities
  • Autoexec Files
  • Batch Processing
  • Workshop Session

P9 Advanced Reading of External Files (Optional)

  • Reading Variable Length Data
  • Reading with Transposition
  • Reading Files with a Varying Number of Repeating Groups
  • Further Examples of Using the Trailing @ Sign
  • Multiple Input Files
  • Workshop Session

Didn't find what you are looking for?  Contact Us