SAS Alliance Silver Member



SAS Training

There is no "standard" SAS course. Every session is the result of a discussion between the client and BI Knowledge Sharing, resulting in a customized result. Below you will find examples of typical BI Knowledge Sharing training sessions.

SAS Enterprise Guide

SAS Enterprise Guide

The SAS Enterprise Guide training offers users who are perhaps less technical an environment and an opportunity to take advantage of the full power of SAS without programming. The session usually lasts 2 days and after attending this session, users will be able to access data, build new tables with new columns, combine several tables and create information on the data in a textual or graphical format.

Depending on the audience, a certain amount of time is dedicated to integration with traditional SAS programming.

The session also covers more advanced topics such as creating and using parameters.

SAS Basics

Depending on the requirements of the client, this training lasts between 3 to 5 days and introduces the participants to SAS programming.

Attendees will become familiar with SAS concepts and syntax rules. After attending this session users will be able to write SAS code for:

  • Simple DATA step processing.
  • Data manipulation (adding variables, removing variables, subsetting data).
  • Combining tables using DATA step SET or MERGE statements.
  • Creating simple list reports.
  • Data summarization.
  • Creating tabular reports.
  • Creating SAS tables from raw data (.txt, .csv, … ).
  • Getting data from or putting data into Microsoft Excel or MS/Access.
SAS Basics SAS Basics SAS Basics

SAS Advanced

This session tends to last between 3 to 5 days and focuses on advanced DATA step programming. Attendees should already have some experience with SAS programming.

During this session, users will gain experience and knowledge about:

  • A large set of DATA step functions.
  • ARRAY processing and DO LOOP processing.
  • Building and using formats.
  • Efficiency considerations.
  • Processing complex raw data files.
  • Combining tables.
  • The usage of hash tables.

The SQL procedure is optional and can be covered on request.

SAS Macro Processing

Within the SAS macro processing training users will learn the full power of the SAS macro facility:

  • Understand the macro environment
  • Static and dynamic macro variables
  • Symbol tables (global and local)
  • Macro definitions and macro calls
  • Parameters in macros
  • Macro functions
  • Generating code with CALL EXECUTE
SAS Macro Processing SAS Macro Processing SAS Macro Processing SAS Macro Processing

SAS Report Writing

This session focuses on the reporting procedures in SAS. Typically the session covers the REPORT and TABULATE procedure. Both procedures are discussed in detail and a comparison between both procedures is presented.
Within this training, attention is given to ODS to enable building tabular reports, highlighting for instance the lowest value in a column or the highest value in a row.
Several examples are built, creating very complex output content.

Efficiency Techniques in SAS

The efficiency techniques promoted in this session are based on almost 30 years of SAS experience in several projects and on different platforms, with different data bases and different SAS releases. This particular session is updated and adapted continuously and provides ready to use techniques to reduce CPU time, space requirements and memory requirements.

The session provides performance improvement tips for:

  • Sorting data.
  • Table lookup.
  • Combining data.
  • Summarizing data.
  • Accessing DBMS data.
  • Using indexes.
  • Space considerations.

All topics are illustrated through real life applications, and provide comparisons between the usage of different techniques.

After a session a user sent us an e-mail with the following text:

“After implementing the suggested optimization, the CPU time decreased from10.440 sec to 2.331 sec!!! A nice case illustrating the added value of SAS efficiency training”.

Graphics in SAS

Several third party end-user tools enable building graphical information using point-and-click. Often, users need customized graphical presentations, where the author of the graphs has full control on any detail.

The SAS Graph training is a 2-days session that teaches the attendees to build charts and plots in 2D and 3D as well as to present data on geographical maps. Attendees will enhance their graphs using SYMBOL statements, PATTERN statements, customized AXIS presentations and LEGEND information. Users will get an idea of the full set of graphical procedures, such as for instance the GBARLINE procedure, the GKPI procedure or the SGPLOT procedure.

Some time is dedicated to ODS Layout to create high quality PDF output, combining several graphs on one page. This is compared to the GREPLAY/TEMPLATE processing in SAS Graph.
The attendees will get an introduction to Annotate.

Building SAS/AF Applications

Users can attend a basic session, where they learn to build simple FRAME applications, exploiting object linking, drag and drop or model-view concepts. They will learn simple SCL programming to add additional program logic to the applications. They will be introduced in the power of SCL lists and they will build applications that generate and execute SAS code
Users can also take a more advanced session, learning to build advanced data entry applications, using table viewers or form viewers, they will add model SCL and viewer SCL. Finally they will build their own sub-classes.

SAS DI Studio

This 3 day session guides you through the process of creating ETL flows