This course focuses on the following key areas: reading raw data files and SAS data sets; investigating and summarizing data by generating frequency tables and descriptive statistics; creating SAS variables and recoding data values; sub setting data; combining multiple SAS files; creating listing, summary, HTML, and graph reports.

Duration : 24 Hours

This course focuses on how to manage SAS data set input and output, work with different data types, and manipulate data. Specifically, the course discusses using the DATA step to control SAS data set input and output, combine SAS data sets, summarize data, procss data iteratively with DO loops and arrays, and perform data manipulations and transformations.

Duration : 24 Hours

This course focuses on how to access, manage, summarize, and present data using SAS Enterprise Guide. The course teaches students how to navigate the menu-driven interface of SAS Enterprise Guide to accomplish tasks such as accessing local SAS and Microsoft Excel tables and remote relational databases; creating user-defined formats; managing, manipulating, and joining data using the SQL query builder; generating descriptive statistics, tabular summary reports, and ActiveX graphs.

Duration : 16 Hours

This course focuses on using SQL as a data query and manipulation tool. You learn to use the SQL procedure as a data retrieval tool within SAS programs. Specifically, you learn how to perform queries on data; retrieve data from multiple tables; create views, indexes, and tables; and update or delete values in existing tables and views. Using features of the SQL procedure to debug, test and optimize the performance.

Duration : 24 Hours

This course focuses on the components of the SAS macro facility and how to design, write, and debug macro systems. Emphasis is placed on understanding how programs with and without macro code are processed.

Duration : 16 Hours