INTRODUCTION (PART-1)
- 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 (PART-2)
- Defining SAS Windows.
- Managing SAS Windows.
- Creating SAS Libraries.
- Managing SAS Libraries.
- Overview of SAS Data states.
- Types of Libraries.
- Storing files temporarily and permanently.
- Referencing SAS files.
- How long libraries remain in effect.
- Explore and manage SAS files.
- Enter and manage SAS files.
BASIC CONCEPTS (PART-3) Top
- Creation of SAS program.
- Complaints of SAS program.
- Processing a SAS program,
- Results of Processing.
- Getting the predefined data states into SAS.
- File Shortcuts.
- Using report editor.
DEBUGGING & INTERPRETING ERROR MESSAGES (PART-4)
- Types of Errors.
- Correcting Errors.
- Resubmitting a revised program.
- Identifying program/symptom of errors.
- Resolving common problem.
- Unbalanced quotes.
- Resolving the error in the windows environment.
- Comments in SAS program.
- Options in SAS program.
- Diagnosing a data step.
- Testing your programs.
- Using put statement.
- Automatic Variable.
SETTING UP YOUR SAS SYSTEM (PART-5)
- Viewing SAS data libraries.
- Producing html output.
- Setting system option.
- SAS system options.
CREATING LIST REPORTS (PART-6) Top
ENHANCING YOUR OUT WITH ODS (PART-7)
- Concepts of out put delivery system.
- How ODS works.
- Open and close ODS.
- Viewing output of ODS in different format.
- HTML
- Tracing and selecting procedure output.
- Using ODS statements to create printer output.
- Closing and listing destinations.
- Open and close.
- Create html output in body files.
- Create a linked table of contents for html output.
- Create a fame file to display a body of file and table of contents.
- Apply styles to html output.
- View html output.
CREATION DATABASE FROM RAWDATA (PART-8)
- Creation of data test from Raw data.
- 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.
UNDERSTANDING THE PROCESS OF PROGRAM (PART-9)
- How SAS software process the program.
- Defining the program data vector.
- Debugging the data step.
AUTOMATIC VARIABLES Top
- Use of automatic variables.
- Types of automatics variables.
- Use of _N_.
- Use of _ERROR_.
- Use of _NULL_.
CREATING AND REDEFFING VARIABLES. (PART-10)
- Creating and reading variables.
- Use if then statements.
- Defining formats and in formats.
- Control Statements.
- Using retain and statements.
- Defining (more statements).
COMBINATION THE SAS DATASETS (PART-11)
- One-o-one reading.
- Concating.
- Interleaving.
- Match merge.
- Function.
FILE SYSTEMS IN SAS (PART-12)
- Introduction of files used in SAS.
- Use of configuration file.
- Auto executable file.
- Buffer life.
- Log life.
- List files.
- Profile catalog file.
- Physical storage of files in external environment.
OPTIONS IN INFILE STATEMENT (PART-13)
- DELIMITOR.
- DSD.
- MISSOVER.
- SCANOVER.
- TRUNCOVER.
PROCEDURES IN BASE SAS (PART-14) Top
- 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.
- Procedure Gchart.
- Procedure Gplot.
- Procedure Report.
ADVANCED PROGRAMMING
MACROS (MODULE-2)
- 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.
- Numeric and character functions.
- SAS System options.
SAS/SQL (MODULE-3)
- Introduction to SQL.
- Understanding SQl through SAS.
- Using procedure SQL statements.
- SQl Statements.
ADVANCED TOPICS Top
- Reflexive Join.
- Normal Join.
- Inner Join.
- Outer Join.
- Right Join.
- Left Join.
- Full Join.
- Cross Join.
- Natural Join.
GRAPHS (MODULE-4)
- Introduction to graphics.
- Usage of 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 / ACCESS (MODULE-6)
- SAS/ACCESS interface to PC FILES.
- SAS/ ACCESS interface to RDBMS.
- SAS/ ACCESS interface to SAP /R/3.
- SAS/ ACCESS interface to BAAN.
SAS/WAREHOUSE ADMINISTRATOR (MODULE-7)
- Introduction to database.
- Defining data warehouse environment metadata items.
- Getting data I warehouse environment.
- Maintaining groups.
- Maintaining global metadata.
- Maintaining host definitions.
- Maintaining data tables.
- Defining a data mapping process.
- Loading the target tables.
- Defining process flow.
- Defining the edit load setup.
- Additional topic will covered (real-time techniques).
SAS/OLAP (MODULE-8)
- Introduction to OLAP.
- Types of OLAP.
- Using of SAS/OLAP.
- Defining MDDB (MDDB wizard interface).
SAS/ETS (MODULE-9) Top
- Introduction to ETS.
- Investment analysis.
- Time series forecasting analysis.
- Input dataset.
- Automatic model fitting window.
- Produce forecast window.
- Develop models window.
- Model viewer.
SAS/ STATISTICS (MODULE-10)
Correlation analysis.
Regression Analysis.
Mean.
Univeriant.
ANOVA for one-way analysis of variance.
GLM METHOD.
And etc..
SAS/QC Top |
