Hardik K Posted March 6, 2012 Report Posted March 6, 2012 [color=#000000] Dear Students[/color] [color=#000000] I am offering SAS Online Training with advance topics like DW, ETL and a Clinical project. Intereste d students can reach me at : [email protected][/color] [color=#000000] Course Contents[/color] [color=#000000] PART-I[/color][color=#000000] BASE SAS[/color][color=#000000] Introduct ion To SAS System & Architect ure[/color][color=#000000] History And Various Modules[/color][color=#000000] Features[/color][color=#000000] Variables & SAS Syntax Rules[/color][color=#000000] SAS Data Sets[/color][color=#000000] Data Set Options[/color][color=#000000] Operators[/color][color=#000000] If – Then Else Statement[/color][color=#000000] Where Statement[/color][color=#000000] Creating & Redefinin g Variables[/color][color=#000000] Reading Raw Data[/color][color=#000000] Infile Statement With Options[/color][color=#000000] Multiple Observati ons and Multiple Datasets.[/color][color=#000000] Input Styles[/color][color=#000000] SAS Functions[/color][color=#000000] Select Statement[/color][color=#000000] Do Loops[/color][color=#000000] Leave and Continue Statement s[/color][color=#000000] Output Statement & Put Statement[/color][color=#000000] Stop And Error Statement s[/color][color=#000000] Array Statement[/color][color=#000000] Modifying And Combining Data Sets[/color][color=#000000] Updating Master Data Set[/color][color=#000000] Key Board Macros & Add Abbreviat ions[/color][color=#000000] Display Manager Commands[/color] [color=#000000] BASE SAS PROCEDURE S[/color][color=#000000] Proc Sort[/color][color=#000000] Proc Print[/color][color=#000000] Proc Means[/color][color=#000000] Proc Freq[/color][color=#000000] Proc Plot[/color][color=#000000] Proc Chart[/color][color=#000000] Proc Compare[/color][color=#000000] Proc Copy[/color][color=#000000] Proc Summary[/color][color=#000000] Proc Append[/color][color=#000000] Proc Datasets[/color][color=#000000] Proc Contents[/color][color=#000000] Proc Delete[/color][color=#000000] Proc Format[/color][color=#000000] Proc Printto[/color] [color=#000000] SAS/REPORTS[/color][color=#000000] Frequency Report[/color][color=#000000] One-Way Frequency Report[/color][color=#000000] Cross Tabular Frequency Report[/color][color=#000000] Summary Statistic s[/color][color=#000000] Creating A List Report[/color][color=#000000] Define Statement[/color][color=#000000] Order Usage and Group[/color][color=#000000] Printing Grand Totals[/color][color=#000000] Rbreak Statement[/color][color=#000000] Tabulate Procedure[/color][color=#000000] One-Dimensional Tables[/color][color=#000000] Two-Dimensional Tables[/color][color=#000000] Obtaining A Total[/color][color=#000000] Analysis Variables with options[/color][color=#000000] Summary Statistic s[/color] [color=#000000] SAS/ODS[/color][color=#000000] Creating Rtf File[/color][color=#000000] Creating Html File[/color][color=#000000] Creating Pdf File[/color][color=#000000] Creating Xml File[/color] [color=#000000] PART -II[/color][color=#000000] ORACLE-SQL CONCEPTS[/color][color=#000000] Introduct ion[/color][color=#000000] History[/color][color=#000000] Features[/color][color=#000000] Sql Command Set[/color][color=#000000] Operators In Sql[/color][color=#000000] Order By Clause[/color][color=#000000] Group By Clause[/color][color=#000000] Having Clause[/color][color=#000000] Distinct Clause[/color][color=#000000] Create and Insert[/color][color=#000000] Deleting,Populating And Updating[/color] [color=#000000] SAS/SQL[/color][color=#000000] Introduct ion To SAS/SQL[/color][color=#000000] Features & Uses[/color][color=#000000] Terminolo gy[/color][color=#000000] Data Types, Key Words, & Operators[/color][color=#000000] Functions, Predicate s & Functions[/color][color=#000000] Formattin g Output[/color][color=#000000] Group By Clause, Order By Clause & Having Clause[/color][color=#000000] Case Expressio n and Condition al Logic.[/color][color=#000000] Creating ,Populating & Deleting Tables[/color][color=#000000] Alter Table Statement[/color][color=#000000] Renaming A Table & Columns[/color][color=#000000] Changing Column’s Length[/color][color=#000000] Joins & Views[/color] [color=#000000] SAS/ACCESS[/color][color=#000000] Import & Export Procedure s[/color][color=#000000] Importing data from Ms-Access & Ms- Excel[/color][color=#000000] Importing data from Oracle database[/color][color=#000000] DbLoad Procedure[/color] [color=#000000] SAS/GRAPH[/color][color=#000000] Gchart Procedure[/color][color=#000000] Vertical, Horizonta l, Pie[/color][color=#000000] Donut[/color][color=#000000] Group,Subgroups[/color][color=#000000] Gplot Procedure[/color][color=#000000] Mutliple Plots & Overlay[/color][color=#000000] Symbol Statement[/color][color=#000000] Title and Footnote Statement s[/color][color=#000000] Goptions[/color] [color=#000000] SAS/MACROS[/color][color=#000000] Macro Concepts[/color][color=#000000] Macros And Macro Variables[/color][color=#000000] Creating Macro Variables[/color][color=#000000] Using Macro Variables[/color][color=#000000] Creating Modular Code With Macros[/color][color=#000000] Invoking A Macro[/color][color=#000000] Adding Parameter s To Macros[/color][color=#000000] Macros With Condition al Logic[/color][color=#000000] Using Various Procedure s In Macros[/color][color=#000000] Automatic Variables[/color][color=#000000] Macro Functions[/color][color=#000000] Including External Macros[/color] [color=#000000] SAS/STAT[/color][color=#000000] Proc Univariat e[/color][color=#000000] Proc Corr[/color][color=#000000] Proc Reg[/color][color=#000000] Proc Anova[/color] [color=#000000] SAS/WAREHOUSE ADMINISTR ATOR[/color][color=#000000] Introduct ion To DW[/color][color=#000000] Relations hip Between SAS And Data Warehousi ng[/color][color=#000000] Database Designing[/color][color=#000000] Types Of Schema[/color][color=#000000] Global Warehouse Designing Steps[/color] [color=#000000] SAS/ETL[/color][color=#000000] Introduct ion To ETL[/color][color=#000000] Applicati on Of ETL In DW[/color][color=#000000] ETL Process Model Developme nt In[/color] [color=#000000] SAS With Project[/color] [color=#000000] PART-III (Only One Project)[/color][color=#000000] CLINICAL PROJECT[/color][color=#000000] BANKING PROJECT[/color] [color=#000000] Thanks[/color][color=#000000] Hardik[/color][color=#000000] Email : [email protected][/color] 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.