Curriculum
Section 1: Business Analytics Using SAS
1 SAS Introduction
2 Introduction to SAS Program
3 Read SAS Dataset
4 Practice Read Dataset
5 Practical Example on Read Dataset
6 Introduction to SAS Dataset
7 SAS Dataset Practical Example
8 SAS Dataset Practical Program
9 DateValue
10 SAS Formats Part 1
11 SAS Formats Part 2
12 Reading Excel Worksheets
13 Reading Excel Worksheet Example
14 Date Format Example
15 Raw Data File Standard Part 1
16 Raw Data File Standard Part 2
17 Raw Data File Standard Example
18 Raw Data File Non Standard
19 Raw Data File Non Standard Example
20 Length Statement
21 Compilation Execution
22 Dataerrors
23 Heading
24 Data Errorsz Example
25 Validate Data Procfreq
26 Validate Data Procpront
27 Validate Data Peocmeans
28 Dat Constant
29 Assignment Statement
30 If Then Statement
31 If Then Do End Statement
32 Diff Where and If Statement
33 Keep Drop
34 Keep Drop Example
35 Append
36 Append Examples part 1
37 Append Examples part 2
38 Concatenate
39 Merge
40 Merge One to One
41 Merge One to Many
42 Merge Non Match
43 Global Statements
44 Global Statements Examples Part 1
45 Global Statements Examples Part 2
46 Title n Foot Note
47 Title n Foot Note Example
48 By Statement
49 Multiple Where Stament
50 ODS
51 ODS Example
52 Sas Date Function
53 Sas Date Function Example
54 Sas Functions Part 1
55 Sas Functions Part 2
56 Sas Functions
57 Sas Functions Example Part 1
58 Sas Functions Example Part 2
59 Multiple SAS Datasets Part 1
60 Multiple SAS Datasets Part 2
61 Multiple SAS DatasetsExample
62 Select Group
63 Select Group Example
64 Do Loop Part 1
65 Do Loop Part 2
66 Do Loop Example
67 Array Part 1
68 Array Part 2
69 Array DoLoop
70 Array Temp
71 Array Example
72 Sas Statement Part 1
73 Sas Statement Part 2
Section 2: SAS - Advanced SAS For Business Analytics
74 Introduction to Advanced SAS
75 Why MACRO?
76 Developing Macro applications
77 Token
78 Macrovariables
79 Macrovariables Examples
80 Macrovariables Demo
81 Defining and Calling Macro
82 ?Demo
83 Macro – Putting Code
84 Macro Programming
85 Example for Macro Programming
86 Positional Parameters
87 Positional Parameters Example
88 Where are Macro Variables Stored?
89 Creating & Updating Variables
90 SAS with SQL
91 Understanding SQL Procedure
92 How to use SQL in SAS?
93 NOEXEC Keyword
94 ??Practical Examples- NOEXEC
95 ??Average Function
96 ??Minimum Function
97 ??Count Function
98 ??Executing Count Function
99 ??Group by Clause
100 ??Executing Group by and Having Clause
101 Order By Clause
102 ??Executing Order By Clause
103 ??SubQuery
104 ??Executing SubQuery
105 ??What are SQL Joins?
106 ??Syntax for the Outer Join
107 Practical example for Joins
108 ??Creating a Table in SQL
109 ??Understanding SQL View
110 ??Inserting Data into Table
111 Techniques for Programming Efficiency
112 Practical Example for Creating Table
113 ??Practical Example for Inserting Data into Table
114 ??Practical Example for Deleting Record from Table
115 ??Practical Example for View
Section 3: Online Business Analytics using SAS Programming
116 Introduction to Business Analytics Using SAS Part 1
117 Introduction to Business Analytics Using SAS Part 2
118 Introduction to SAS
119 SAS Functionalities
120 Logic Flow How Data is Convert Data to Information
121 Overview of SAS Windows Part 1
122 Overview of SAS Windows Part 2
123 Components of the SAS Language Part 1
124 Components of the SAS Language Part 2
125 Fundamental of SAS
126 Data Types in SAS
127 SAS Library
128 Assigning A Libref
129 Introduction to Creating and Reading Internal and External Data Source
130 Accessing Data from SAS System
131 Agenda
132 The SAS System
133 Reading Raw Data with the Input Statement
134 Modified List Input
135 Important Infile Option
136 Use of the Length Statement
137 Data Step Processing
138 Compilation Phase
139 Introduction to Data Validation and Cleaning
140 Where Statement
141 Logical and Arithmetic Operators
142 LIKE Operators
143 Addition Controlling Data
144 SAS Formats
145 Example Formatting Date Value
146 Introduction to Data Manipulation
147 The Sum Function
148 Group Processing
149 Quiz Answer
150 Creating Variables Conditionally
151 Logical Operators
152 Sub Setting Variables and Observations
153 Do Loop and SAS Arrays
154 Two Dimensional Array Declaration
155 Method of Combining
156 Concatenating with Proc Append Procedure
157 Merging
158 One to Many Merge
159 Final Results
160 Objectives Part 1
161 Objectives Part 2
162 Output Statement
163 Introduction to Data Transformation
164 Other Character Function
165 SUBSTR Function
166 Replacing Text Using SUBSTR
167 Index Function
168 Numeric Function
169 The Round Function Example
170 Date Function
171 INTCK Function
172 INTCK Function Continue
173 MCQ
174 MCQ Continue
175 Introduction to Report Generation
176 SAS System Option
177 The Footnote Statement
178 Assigning Temporary Labels
179 Closing Default Output Destination
180 Creating Customize Report Using PROC Report
181 Class Statement
182 Proc Means vs Proc Summary
183 Producing Frequency Table Using
184 Creating Table and List Format
185 Creating Tabular Report
