sasE-learning Syllabus

v  Basic Concepts	Overview       SAS Programs       SAS Libraries       Referencing SAS Files       SAS Data Sets       Using the Programming Workspace       Chapter Summary       Chapter Quiz
v  Referencing Files and Setting Options	Overview       Viewing SAS Libraries       Specifying Results Formats       Setting System Options       Additional Features       Chapter Summary       Chapter Quiz
v  Editing and Debugging SAS Programs	Overview       Opening a Stored SAS Program       Editing SAS Programs       Clearing SAS Programming Windows       Correcting Errors       Resolving Common Problems       Additional Features       Chapter Summary       Resolving Common Problems
v  Creating List Reports	Overview       Creating a Basic Report       Selecting Variables       Identifying Observations       Sorting Data       Generating Column Totals       Double Spacing Listing Output       Specifying Titles and Footnotes       Assigning Descriptive Labels       Formatting Data Values       Additional Features       Chapter Summary       Chapter Quiz
v  Creating SAS Data Sets from Raw Files and Excel Worksheets	Overview       Raw Data Files       Steps to Create a SAS Data Set From a Raw Data File       Referencing a SAS Library       Referencing a Raw Data File       Writing a DATA Step Program       Submitting the DATA Step Program       Creating and Modifying Variables       Subsetting Data       Reading Instream Data       Creating a Raw Data File       Additional Features       Reading Microsoft Excel Data       LIBNAME Statement Options       Creating Excel Worksheets       The IMPORT Wizard       Chapter Summary       Chapter Quiz
v  Understanding DATA Step Processing	Overview       Writing Basic DATA Steps       How SAS Processes Programs       Compilation Phase       Execution Phase       Debugging a DATA Step       Testing Your Programs       Chapter Summary       Chapter Quiz       Creating and Applying User Defined Formats       Introduction to PROC FORMAT       Defining a Unique Format       Associating User Defined Formats with Variables       Chapter Summary       Chapter Quiz
v  Creating Enhanced List and Summary Reports	Overview       Creating a Default List Report       Selecting Variables       Selecting Observations       Defining Variables       Defining Column Attributes       Defining Column Headings       Specifying Column Justification       Enhancing the Headings Appearance       Defining Variable Usage       Chapter Summary       Chapter Quiz
v  Producing Descriptive Statistics	Overview       Computing Statistics Using PROC MEANS       Selecting Statistics       Limiting Decimal Places       Specifying Variables in PROC MEANS       Group Processing Using the CLASS Statement       Creating a Summarized Data Set Using PROC MEANS       Creating a Summarized Data Set Using PROC SUMMARY       Producing Frequency Tables Using PROC FREQ       Specifying Variables in PROC FREQ       Creating Two Way Tables       Creating N Way Tables       Creating Tables in List Format       Chapter Summary       Chapter Quiz
v  Producing HTML Output	Overview       The Output Delivery System       Opening and Closing ODS Destinations       Creating Simple HTML Output       Creating HTML Output with a Table of Contents       Using Options to Specify Links and Paths       Changing the Appearance of HTML Output       Additional Features       Chapter Quiz
v  Creating and Managing Variables	Overview       Assigning Values Conditionally       Specifying Lengths for Variables       Sub setting Data       Assigning Permanent Labels and Formats       Assigning Values Conditionally Using SELECT Groups       Grouping Statements Using DO Groups       Chapter Summary       Chapter Quiz
v  Reading SAS Data Sets	Overview       Reading a Single Data Set       Manipulating Data       Using BY Group Processing       Detecting the End of a Data Set       Additional Features       Chapter Quiz
v  Combining SAS Data Sets	Overview       One to One Reading       Concatenating       Appending       Interleaving       Match Merging       Match Merge Processing       Renaming Variables       Excluding Unmatched Observations       Selecting Variables       Additional Features       Chapter Summary       Chapter Quiz
v  Transforming Data with SAS Functions	Overview       General Form of SAS Functions       Converting Data with Functions       Manipulating SAS Date Values with Functions       Modifying Character Values with Functions       Modifying Numeric Values with Functions       Nesting SAS Functions       Chapter Summary       Chapter Quiz
v  Generating Data with DO Loops	Overview       Nesting DO Loops       Iteratively Processing Data That Is Read from a Data Set       Conditionally Executing DO Loops       Using Conditional Clauses with the Iterative DO Statement       Creating Samples       Chapter Summary       Chapter Quiz
v  Processing Variables with Arrays	Overview       Creating One Dimensional Arrays       Expanding Your Use of Arrays       Additional Features       Chapter Summary       Chapter Quiz
v  Reading Raw Data in Fixed Fields	Overview       Identifying Nonstandard Numeric Data       Choosing an Input Style       Using Formatted Input       Using Informats       Record Formats       Chapter Summary       Chapter Quiz
v  Reading Free Format Data	Overview       Free Format Data       Reading Missing Values       Specifying the Length of Character Values       Modifying List Input       Creating Free Format Data       Mixing Input Styles       Additional Features       Chapter Quiz
v  Reading Date and Time Values	How SAS Stores Date Values       How SAS Stores Time Values       Using Dates and Times in Calculations       Using Date and Time Formats       Chapter Summary       Chapter Quiz
v  Creating a Single Observation from Multiple Records	Using Line Pointer Controls       Reading Multiple Records Sequentially       Reading Multiple Records Non Sequentially       Combining Line Pointer Controls       Chapter Summary       Chapter Quiz
v  Creating Multiple Observations from a Single Record	Overview       Reading Repeating Blocks of Data       Reading the Same Number of Repeating Fields       Reading a Varying Number of Repeating Fields       Chapter Summary       Chapter Quiz
v  INTRODUCTION TO DATABASE	SQL Procedures       Sas/sql –introduction       Features and uses       Terminology       Data types,       key words,       formatting output       group by clause, order by clause       creating &deleting tables       changing length statement       joins and views       Pro sql       Understanding sql through SAS       DDL Commands in SQL       DML Commands in SQL       Working with Joins       Working with Indexes       Working with Functions       Constraints       Creating Views       ProcSql Statement ,functions and operators       Connect, Disconnect statements       Aliases       Case Function       Like Operator       SYMPUT       SYMGET       Permanent storage of macros       Conditions in Macros
v  Macros	Introduction to Macros       Type of Macros       Macro Variables       Macro Processing       Macro Functions       Automatic macro Variables       Macro concepts       Macros and Macro variables       Using macro variables       Adding parameters to macros       Macros with conditional logic       Automatic variables