Hardik K Posted September 4, 2011 Report Posted September 4, 2011 Dear StudentsI am offering SAS Online Training with advance topics like DW, ETL and a Clinical project. Intereste d students can reach me at : [email protected]Course ContentsPART-IBASE SAS Introduct ion To SAS System & Architect ure History And Various Modules Features Variables & SAS Syntax Rules SAS Data Sets Data Set Options Operators If – Then Else Statement Where Statement Creating & Redefinin g Variables Reading Raw Data Infile Statement With Options Multiple Observati ons and Multiple Datasets. Input Styles SAS Functions Select Statement Do Loops Leave and Continue Statement s Output Statement & Put Statement Stop And Error Statement s Array Statement Modifying And Combining Data Sets Updating Master Data Set Key Board Macros & Add Abbreviat ions Display Manager CommandsBASE SAS PROCEDURE S 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 Statistic s 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 Statistic sSAS/ODS Creating Rtf File Creating Html File Creating Pdf File Creating Xml FilePART -IIORACLE-SQL CONCEPTS Introduct ion 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 Introduct ion To SAS/SQL Features & Uses Terminolo gy Data Types, Key Words, & Operators Functions, Predicate s & Functions Formattin g Output Group By Clause, Order By Clause & Having Clause Case Expressio n and Condition al Logic. Creating ,Populating & Deleting Tables Alter Table Statement Renaming A Table & Columns Changing Column’s Length Joins & ViewsSAS/ACCESS Import & Export Procedure s Importing data from Ms-Access & Ms- Excel Importing data from Oracle database DbLoad ProcedureSAS/GRAPH Gchart Procedure Vertical, Horizonta l, Pie Donut Group,Subgroups Gplot Procedure Mutliple Plots & Overlay Symbol Statement Title and Footnote Statement s GoptionsSAS/MACROS Macro Concepts Macros And Macro Variables Creating Macro Variables Using Macro Variables Creating Modular Code With Macros Invoking A Macro Adding Parameter s To Macros Macros With Condition al Logic Using Various Procedure s In Macros Automatic Variables Macro Functions Including External MacrosSAS/STAT Proc Univariat e Proc Corr Proc Reg Proc AnovaSAS/WAREHOUSE ADMINISTR ATOR Introduct ion To DW Relations hip Between SAS And Data Warehousi ng Database Designing Types Of Schema Global Warehouse Designing StepsSAS/ETL Introduct ion To ETL Applicati on Of ETL In DW ETL Process Model Developme nt InSAS With Project PART-III (Only One Project) CLINICAL PROJECT BANKING PROJECTThanksHardikEmail : [email protected] Quote
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.