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

1. Do loop
2. Do-While
3. While-Do
4. Continue
5. Leave

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

We provide guidance for BASE & ADVANCED certifications and materials.

  • Interview Guidance.
  • Domain Explanation

live Chat

this watch was built by serious watch enthusiasts for serious watch enthusiasts. You receive a large amount of that within the watch industry, replica watches as a sportier and bolder evolution of the 1972-born Royal Oak). In 2015 replica Tag Heuer Autavia price , on the movement. The hours and minutes are shown via two skeletonized hands fit under the flying tourbillon. Replicas De relojes The handwork requires expert craftsmanship and is really impressive. The result after many hours of work is of exceptional beauty. The paillonne enamel surrounds the typical Jaquet Droz time indication.