SAS Course Content
Overview:
SAS (Statistical Analysis System) is the statistical and information system that performs data management and statistical analysis. The system’s analysis tools range from simple descriptive statistics Level to advanced statistical design. It is made up of a number of modules with specialized procedures for analysis relating to various disciplines. The main functionalities of its components are intended to be accessed via application programming interfaces, in the form of statements and procedures.
Training Objectives of SAS:
SAS is one of the premier data analysis software in the market. It utilizes a specialized data set table proprietary to SAS, however it’s System has modules to be able to read and write to many other data base products like Oracle and ODBC compliant products like MS-SQL Server or PROGRESS. The data presentation capabilities range from simple lists and tables to multi dimensional plots and high-resolution graphics.
Target Students / Prerequisites:
Students must be belonging to Technical Background and familiar with Programming Skills.
INTRODUCTION
- Introduction to SAS Integrated Systems.
- Components of SAS System.
- SAS Runs on Different Platforms.
- Use of Different Platforms.
- Accessing the data from External Source.
- Other Integrations.
- Accessing the Data from different sessions.
- Real-time monitoring in SAS with server integrations.
- Working with structure of SAS.
Working in the SAS Environment
- Defining and managing SAS Windows.
- Creating and managing SAS Libraries.
- Overview of SAS Data states.
- Types of Libraries.
- Storing files temporarily and permanently.
- Referencing SAS files.
CREATION DATABASE FROM RAWDATA
- Steps to create a SAS dataset.
- Referencing a SAS data library.
- Referencing a SAS data library.
- Using different statement to get data.
- Referencing a Raw data file.
- Writing a data step program.
CREATING AND REDEFFING VARIABLES
- Use with different conditional statements.
DEBUGGING & INTERPRETING ERROR MESSAGES
- DEBUGGING &INTERPRETING ERROR MESSAGES
AUTOMATIC VARIABLES
- Use of automatic variables.
- Types of automatics variables.
- Use of _N_, _ERROR_, _NULL_.
- Testing your programs.
- Using put statement.
- Automatic Variable.
ENHANCING YOUR OUT WITH ODS
- Concepts of out put delivery system.
- How ODS works and viewing output of ODS in different format.
- HTML, RTF, PDF etc..
COMBINATION THE SAS DATASETS
- One-o-one reading, Concatenation, Interleaving, Match merge, Function.
SAS/SQL (MODULE-3)
- Introduction to SQL.
- Understanding SQl through SAS.
- Using procedure SQL statements.
- SQl Statements.
PROCEDURES IN BASE SAS
- Procedure Print.
- Procedure Format.
- Procedure Contents.
- Procedure Options.
- Procedure Append.
- Procedure Compare.
- Procedure Transpose.
- Procedure Options.
- Procedure Import.
- Procedure Export.
- Procedure Forms.
- Procedure Datasets.
- Procedure Format.
- Procedure Tabulate.
- Procedure Explode.
- Procedure Chart, Gchart, Gplot.
- Procedure Report.
ADVANCED PROGRAMMING MACROS
- Introduction to Macros.
- Defining Macro facility.
- Generating SAS code using Macros.
- Placing text using Macro variable.
- Passing Macro Elements.
- Macro Execution Process.
- Macro Statements.
- Quoting Function.
- Quoting Function.
- SAS System options.
GRAPHS (MODULE-4)
- Introduction to graphics.
- Introduction to graphics.
- Types of Graphics (with latest models)
- Defining procedure Graphics.
SAS / ACCESS (MODULE-5)
- Introduction of SAS/ CONNECT.
- Single user.
- Multi user.
- Remote SQL pass through services.
- Data transfer services.
- SAS/CONNECT system options.
- Starting and stopping SAS/ CONNECT.
- Post installation setup for SAS/ CONNECT software.
SAS/ STATISTICS (MODULE-10)
- Correlation analysis.
- Regression Analysis
- Mean.
- Univeriant.
- ANOVA for one-way analysis of variance.
- GLM METHOD.
- Post installation setup for SAS/ CONNECT software.