SAS

PART-IBASE SAS Introduction To SAS System & Architecture History And Various Modules Features Variables & SAS Syntax Rules SAS Data Sets Data Set Options Operators Reading Raw Data Infile Statement With Options Working With External Files & Options Multiple Observations Input Styles Select Statement Leave and Continue Statements Creating & Redefining Variables Where Statement If – Then Else Statement Goto, Stop And Error Statements Output Statement, Put Statement Do Loops Modifying And Combining Data Sets Updating Master Data Set Display Manager Commands SAS Functions BASE SAS PROCEDURES Proc sort Proc Print Proc Means Proc Freq Proc Plot Proc Chart Proc Copy Proc Summary Proc Append Proc Datasets Proc Contents Proc Delete Proc Format Proc Import Proc Export PART -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 Updating SAS/SQL Introduction To SAS/Sql Features Uses Terminology Data Types, Key Words, & Operators Functions, Predicates Formatting Output Group By Clause Order By Clause Having Clause Case Expression And Conditional Logic. Creating ,Populating & Deleting Tables Alter Table Statement Changing Column’s Length Joins Constraints Renaming A Table & Columns Views SAS/ACCESS Working With Oracle Working With Ms-Access Working With Ms-Excel DBLoad Procedure SAS/GRAPH Gchart Procedure Vertical, Horizontal, Pie Donut G3d Group, Subgroups Gplot Procedure Multiple Plots & Overlay Symbol Statement Title And Footnote Statements Goptions SAS/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 Statistics SAS/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 Macros SAS/STAT Proc Univariate Proc Corr Proc Reg Proc Anova SAS/ODS Creating Rtf File Creating Html File Creating Pdf File PART-III (Only One Project) Clinical Project