BASE - SAS

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
1. Number(dates also)
2. 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 SQL(Pass-thru-query, servers, warehouse)
6. Proc Import(PC Files – Access, Excel)
7. SET Statement ( data sets)
8. Proc download(rsubmit)

Conditional Statements
1. Simple If statement
2. If – else statement
3. Nested-If statement
4. If – do
5. Where clause
6. Where dataset option
7. 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
2. 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. DDE
3. Proc Export
4. Proc SQL
5. Proc Upload

Analysis techniques
1. Proc Freq
2. Proc Means
3. Proc Univariate
4. Proc Summary
5. Proc Rank
6. Proc Chart
7. Proc Graph
8. 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 )
6. Type of Macros
a. Local
b. Global
c. Symbol tables
d. Scope of types
7. Macro Debugging
a. MPrint/MPrintNest
b. MLogic/MLogicNest
c. Symbolgen
8. Macro Functions
9. Auto-call Libraries
10. Stored and Compiled macros
Performance Techniques
1. Indexes
a. About
b. Ways to create
c. Advantages & Disadvantages
d. Modify
e. Delete
f. Update
2. 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