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.
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.
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:
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:
The SQL procedure is optional and can be covered on request.
Within the SAS macro processing training users will learn the full power of the SAS macro facility:
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.
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:
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”.
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.
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.