500072.00 Rupee ₹ SAS base and Advanced training at FuturePointtech Hyderabad

SAS BASE & Advanced SYLLABUS
Overview of SAS
Uses & Advantages of SAS
SAS Architecture
SAS Components
SAS Members (Datasets, Catalogues)
SAS Compilation/Execution Phase
SAS Software demo
Steps in SAS Editor Window (Data, Proc)
SAS Variables/Data Types
Number(dates also)
Character
SAS Naming conventions
1. Data set names
2. Catalogue names
3. Lib reference
4. Index names
SAS Operators
SAS Options (system, macro, data step)
SAS Functions
1. Character/String functions
2. Number functions
3. Aggregate functions
4. Statistical functions
5. Miscellaneous
Input Data reading techniques
1. Import Wizard
2. Infile/Input(flat files - .csv, .txt, .doc)
3. DDE(Excel files)
4. Libname(any type of file)
5. Proc Import(PC Files – Access, Excel)
6. SET Statement ( data sets)
Conditional Statements
Simple If statement
If – else statement
Nested-If statement
If – do
Where clause
Where dataset option
If Vs Where
Loops
1. Do loop
2. Do-While
3. While-Do
4. Continue
5. Leave
Formats/Informats
1. Predefined Formats
a. Date formats.
b. Character formats
c. Numeric formats
1. User defined Formats
a. Proc Format
i. Invalue (Input())
ii. Value (Put())
iii. Fmtlib
iv. Cntlin=
v. Cntlout=
b. Using Data step

Data descriptive Information
1. Proc Contents
2. Proc Datasets
3. Attrib Statement
4. Rename Statement
5. Length Statement
6. Proc Compare
Sorting/Merging techniques
1. Proc Sort
2. Data step Merge
3. Proc SQL
Data Management techniques
1. Proc Sort
2. Proc Transpose
3. Proc Append
4. Proc Compare
5. Proc Datasets
Outputting Data techniques
1. File/Put statement
2. Proc Export
3. Proc SQL
Analysis techniques
1. Proc Freq
2. Proc Means
3. Proc Univariate
4. Proc Summary
5. Proc Chart
6. Proc Graph
7. Proc Plot
Reporting Techniques
1. Proc Print
2. Proc Report
3. Proc Tabulate
4. ODS
Macro Concepts
1. What is Macros?
2. Macros how it works?
3. Macro variables ( Declare, Define, Use & Debugg)
4. Macro statements & blocks
5. Macro calling(Varibales & blocks )
Type of Macros
a. Local
b. Global
c. Symbol tables
d. Scope of types
Macro Debugging
a. MPrint/MPrintNest
b. MLogic/MLogicNest
c. Symbolgen
1. Macro Functions
1. Auto-call Libraries
2. Stored and Compiled macros
Performance Techniques
a. About
b. Ways to create
c. Advantages & Disadvantages
d. Modify
e. Delete
f. Update
1. Data Compression techniques
a. Data compression
b. Advantages & Disadvantages
c. Zipping concepts
SAS Jobs Management
1. Batch Job Processing
2. Diff between Interactive & Batch Job processing
3. Job Scheduling
4. E-mailing techniques
a. Sending Emails
b. Sending Attachments
c. Advantages & Disadvantages

Real time project scenarios and explanation

Most advanced topics explanation
1. SDTM
2. CDISC STANDARDS
3. TLF(TABLES,LISTINGS & FIGURES EXPLANATION)
4. ADAMS CREATION

We provide guidance for BASE & ADVANCED certifications and materials.

Interview Guidance.

Domain Explanation


http://www.futurepointtech.com/sas-training.html

Share