1 intro

2 SAS Windows,Program flow,Libraries

3 Reading data from text, csv files & SET statement

4 Features, Write your first program

5 Define library, Use SET Statement

6 Reading data to create datasets – Using Infile, PROC IMPORT

7 Dataset creation -Using List Input, Column Input, Datalines

8 Data Step Processing

9 Informats

10 Formats

11 Dates in SAS

12 Reading raw data using Formatted, Mixed Formatted Input

14 Demo – Listed, Column, Formatted & Mixed Input

15 Demo – Reading Non Standard data

16 PROC CONTENTS

17 Demo – Procedure CONTENTS, PRINT

18 Demo – Procedure FREQ

19 Demo – Procedure FORMAT, title statement

21 Selecting variables – KEEP, DROP

22 Subsetting datasets – IF, WHERE, DELETE, OUTPUT

23 ELSE Statements

24 Demo – KEEP, DROP

24 Procedures – IMPORT, EXPORT, SORT

25 Demo – Conditional Processing -If Else, If Else If

26 Demo- Subsetting datasets-IF, WHERE

28 Demo – PROC SORT

29 Using ODS Statements to Create outputs

30 Demo – Using ODS statements

31 Character functions

32 Numeric & Date functions, Put & Input functions

33 Demo – Character functions

34 Demo – Numeric functions

35 Demo – Date functions

36 Demo – Input and Put

37 Stacking & Interleaving Data Sets using the SET Statement

38 Using Merge statement

39 Example on Merge, IN dataset option

40 One-to-Many merge, Many-to-Many

41 Demo – SET, Interleave

42 Demo – One-to-One merge, types of merges, match merge

43 Demo – One-Many & Many-Many Match merge

44 Procedures – MEANS, SUMMARY, TABULATE

45 Demo- Procedure MEANS

46 Demo- Procedure SUMMARY

47 Demo- Procedure TABULATE

48 The Simplest SELECT, WHERE, ORDER Statement

49 SQL Joins

50 Using Group Functions

51 Quick Summary

52 Demo -SELECT, WHERE, ORDER

53 Demo – GROUP BY, HAVING

54 Demo – SQL Joins

55 Define Macros Variables and Macros

56 Demo – Define Macro Variables

57 Demo – Define Macros

58 Demo – Symput, Symget