Knowledge Transfer Microsoft Certified Training Partner CTEC
Knowledge Transfer is a Microsoft Certified Gold Partner
Microsoft Certified Gold Training Partner
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
 
 Main Menu
 
Home
View Courses
Site Index
 
 


SAS Advanced Processing Overview


Topics:

Review:

  • Creating SAS datasets
  • Reading and Writing SAS datasets
  • Enhancing SAS Output, SAS Date Values, Accumulating SAS Totals
  • SAS datasets Compilation
  • Creating the PDV
  • Debugging Tools

Reading Complex External Files:

  • Reading PC Extract Files
  • Pointer Controls
  • The Trailing @
  • The Trailing @@)
  • INFILE Options

Functions:

  • Date and Time
  • Character
  • INDEX, LENGTH, SUBSTR
  • SCAN
  • INPUT and PUT Functions
  • Truncation, Arithmetic, Statistical
  • Logarithm
  • Random Sampling

DO Loops and Arrays:

  • The Iterative DO
  • DO WHILE
  • DO UNTIL
  • SAS Arrays

Table Lookups:

  • Input Control data set CNTLIN
  • Output Control data set CNTLOUT

Summary Reports:

  • SUMMARY / TABULATE (OPTIONAL)
  • PROC SUMMARY:  Statistics
  • Calculations, Multi Level
  • Calculations Between Levels
  • PROC TABULATE:  Hierarchies,
  • Calculations, Column / Row Totals

Workshop Practice Problems and Solutions

Optional Topics:

Utility Procs:

  • PROC DATASETS, PROC CATALOG, PROC COPY, PROC APPEND, PROC CPORT, PROC CIMPORT

Macro Variables:

  • Automatic Macro Variables
  • User Defined Macro Variables
  • Text Strings, Assign Indirect Variable Values
  • SYMBOLGEN / SYSPARM
  • Data Step Interface (SYMGET,SYMPUT)
  • Efficiency Techniques

 

View Printer Friendly Page


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

The SAS workshops have all been developed in house by our consultant/instructors.  Our instructors hold SAS Certifications in V8 and keep current through SAS Workshops and Consulting projects.  We offer a wide variety of on-site training courses.  All of our courses are modularized so the curriculum can be tailored to meet your training needs.