Tips and Tricks catalog consists of a serie half-day/full-day of knowledge transfer sessions in the SAS programming language, organized by a motivated SAS expert who combines theory and demonstrations to help you refresh your SAS skills or discover new techniques.
Designed for employees, these sessions are held at your office in one of your meeting rooms or remotly but for single employees only and is part of the SAS coaching service .
All sessions last 3 hours and can be conducted in French or English.
Starting with a new software and programming language is not easy. This tips and tricks helps you to understand the basics in SAS and how to access your data , sample data and help files in order to start in the good direction.
Base SAS contains couple of very nice procedures to create reports on your data . This tips and tricks shows you an overview of the most popular including The Proc Tabulate which is one of the most powerful SAS reporting Procedure.
A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Different SCD strategies could be implemented and this tips and tricks is focused on SCD1 where records are updated no history is kept and SCD2 where history is kept,
Indexes are special reference tables that the SAS engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. In this tips and tricks we will discuss how you can create and use SAS indexes.
By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.