Hardik Posted December 3, 2010 Report Share Posted December 3, 2010 Dear StudentsI am offering SAS 9.1 Online Training with advance topics like DW, ETL and a Clinical project.Interested students can reach me at hardikkonda@gmail,.comCourse ContentsPART-IBASE SAS Introduction To SAS System & Architecture History And Various Modules Features Variables & SAS Syntax Rules SAS Data Sets Data Set Options Operators If – Then Else Statement Where Statement Creating & Redefining Variables Reading Raw Data Infile Statement With Options Multiple Observations and Multiple Datasets. Input Styles SAS Functions Select Statement Do Loops Leave and Continue Statements Output Statement & Put Statement Stop And Error Statements Array Statement Modifying And Combining Data Sets Updating Master Data Set Key Board Macros & Add Abbreviations Display Manager CommandsBASE SAS PROCEDURES Proc Sort Proc Print Proc Means Proc Freq Proc Plot Proc Chart Proc Compare Proc Copy Proc Summary Proc Append Proc Datasets Proc Contents Proc Delete Proc Format Proc PrinttoSAS/REPORTS Frequency Report One-Way Frequency Report Cross Tabular Frequency Report Summary Statistics Creating A List Report Define Statement Order Usage and Group Printing Grand Totals Rbreak Statement Tabulate Procedure One-Dimensional Tables Two-Dimensional Tables Obtaining A Total Analysis Variables with options Summary StatisticsSAS/ODS Creating Rtf File Creating Html File Creating Pdf File Creating Xml FilePART -IIORACLE-SQL CONCEPTS Introduction History Features Sql Command Set Operators In Sql Order By Clause Group By Clause Having Clause Distinct Clause Create and Insert Deleting,Populating And UpdatingSAS/SQL Introduction To SAS/SQL Features & Uses Terminology Data Types, Key Words, & Operators Functions, Predicates & Functions Formatting Output Group By Clause, Order By Clause & Having Clause Case Expression and Conditional Logic. Creating ,Populating & Deleting Tables Alter Table Statement Renaming A Table & Columns Changing Column’s Length Joins & ViewsSAS/ACCESS Import & Export Procedures Importing data from Ms-Access & Ms-Excel Importing data from Oracle database DbLoad ProcedureSAS/GRAPH Gchart Procedure Vertical, Horizontal, Pie Donut Group,Subgroups Gplot Procedure Mutliple Plots & Overlay Symbol Statement Title and Footnote Statements GoptionsSAS/MACROS Macro Concepts Macros And Macro Variables Creating Macro Variables Using Macro Variables Creating Modular Code With Macros Invoking A Macro Adding Parameters To Macros Macros With Conditional Logic Using Various Procedures In Macros Automatic Variables Macro Functions Including External MacrosSAS/STAT Proc Univariate Proc Corr Proc Reg Proc AnovaSAS/WAREHOUSE ADMINISTRATOR Introduction To DW Relationship Between SAS And Data Warehousing Database Designing Types Of Schema Global Warehouse Designing StepsSAS/ETL Introduction To ETL Application Of ETL In DW ETL Process Model Development In SAS With Project PART-III (Only One Project) CLINICAL PROJECT BANKING PROJECTThanksHardik Quote Link to comment Share on other sites More sharing options...
massraja Posted December 4, 2010 Report Share Posted December 4, 2010 sCo_hmmthink sCo_hmmthink Quote Link to comment Share on other sites More sharing options...
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.