SAS Programming 3: Advanced Techniques and Efficiencies

This course is for SAS programmers who prepare data for analysis.

Duration 3 Days
Certificate SAS Global
Language English

Fees 1950

Power up your staff’s skills and boost your business


or Call us on 732-593-8343

About Program

This course is for SAS programmers who prepare data for analysis. The comparisons of manipulation techniques and resource cost benefits are designed to help programmers choose the most appropriate technique for their data situation.

This course can help prepare you for the following certification exam(s): SAS Advanced Programming for SAS 9.

Format of Training

Taught by certified instructors at high-tech facilities across the country

All the benefits of the classroom without the travel

  • Join the classroom right from your desktop
  • Led by an expert instructor who can virtually look over your shoulder
  • Ask questions and get answers in real-time
  • Access the latest software via a virtual lab
  • Receive 20 business days' access to a recording of your course
  • Discuss, share, exchange ideas with participants from different countries

Training Features

  • benchmark computer resource usage
  • control memory, I/O, and CPU resources
  • create and use indexes
  • combine data horizontally
  • use hash and hiter DATA step component objects and arrays as lookup tables
  • compress SAS data sets
  • sample your SAS data sets
  • create and use SAS data views
  • safely reduce the length of numeric variables
  • create user-defined functions and informats.

Course Curriculum


  • course logistics
  • creating course data files

Efficient SAS Programming

  • identifying computer resources related to efficiency

Controlling I/O Processing and Memory

  • SAS DATA step processing
  • controlling I/O
  • reducing the length of numeric variables
  • compressing SAS data sets
  • using SAS views

Accessing Observations

  • access methods
  • accessing observations by number
  • creating an index
  • using an index

DATA Step Arrays

  • introduction to lookup techniques
  • one-dimensional arrays
  • multidimensional arrays
  • loading a multidimensional array from a SAS data set

DATA Step Hash and Hiter Objects

  • hash object methods
  • loading a hash object from a SAS data set
  • DATA step hiter object

Combining Data Horizontally

  • DATA step merges and SQL procedure joins
  • using an index to combine data
  • combining summary and detail data
  • combining data conditionally

User-Defined Functions and Formats


  • user-defined functions
  • user-defined formats

Learning More


  • areas of support from SAS
  • other courses to consider

Course Fees






Enroll Now