BI & Datawarehousing Training

SAS

(0 review)
Free
sas

SAS TRAINING

 

About the Course

 

SAS training course at Tamil Technologies explains in detail about the role of data scientists and how they use SAS and other tools, statistics, and data manipulation techniques to make best of the available data. As such, Data Analytics is one of the most popular domains and it is growing by leaps and bounds. Every company relies on data for its growth and that is the primary reason why these companies are looking for smart data scientists and analysts. During the SAS training course, you will have hands-on experience on various SAS functions and other important concepts such as PROC SQL, PROC, PROC UNIVARIATE, PROC MEANS, PROC FREQ, PROC CORP, and more. You will also undergo full-fledged training on SAS Macros, Regression, Clustering, and Data Manipulation. As a matter of fact, Data Manipulation is centric to SAS therefore there will be practical sessions on the same, followed by Resume and Interview preparation rounds.

 

Intended Audience for SAS Training Course

  • IT professionals who wish to switch in the field of data analytics
  • Analytics professionals keen to work in SAS
  • Software Developers interested in data analytics
  • Fresh graduates who wish to make a career in data analytics

Prerequisites for SAS

There are no technical prerequisites for this course. However, knowledge of statistics will prove beneficial.

SAS Course Content

INTRODUCTION TO THE ANALYTICS WORLD AND SAS ROLE:

  • Analytics World
    • Introduction to Analytics
    • ETL CONCEPT and role of SAS in ETL
    • SAS in advanced analytics
  • SAS Certification: Induction and walk through
    • Getting Started with SAS
    • SAS software installation
    • Introduction to SAS, GUI
    • Different components of SAS language
    • All SAS programming windows
    • Concept of SAS Libraries and Creating Libraries
    • Variable Attributes – (Name, Type, Length, Format, In format, Label)
    • Importing Data and Entering data manually
  • Understanding Datasets
    • Descriptor Portion of a Dataset (Proc Contents)
    • Data Portion of a SAS Dataset
    • Variable Names and Values
    • SAS Data Libraries

BASE SAS: ACCESSING THE DATA

  • Understanding Data Step Processing
    • Data Step and Proc Step
    • Data step execution
    • Compilation and execution phase
    • Input buffer and concept of PDV
  • Importing Raw Data Files
    • Column Input and List Input and Formatted methods
    • Delimiters, Reading missing and non standard values
    • Reading one to many and many to one records
    • Reading Hierarchical files
    • Creating raw data files and put statement
    • Formats / Informat
  • Importing and Exporting Data (Fixed Format / Delimited)
  • Proc Import / Delimited text files
  • Proc Export / Exporting Data from SAS
  • Datalines / Cards;
  • Atypical importing cases (mixing different style of inputs)
    • Reading Multiple Records per Observation
    • Reading “Mixed Record Types”
    • Sub-setting from a Raw Data File
    • Multiple Observations per Record
    • Reading Hierarchical Files
  • Importing Tips

BASE SAS – DATA UNDERSTANDING, MANAGING AND MANIPULATION

  • Understanding and Exploration Data
    • Introduction to basic Procedures – Proc Contents, Proc Print
  • Understanding and Exploration Data
    • Operators and Operands
    • Conditional Statements (Where, If, If then Else, If then Do and select when)
    • Difference between WHERE and IF statements and limitation of WHERE statements
    • SAS Labels, Commenting
    • SAS System Options (OBS, FSTOBS, NOOBS etc…)
  • Data Manipulation
    • Proc Sort – with options / De-Duping
    • Accumulator variable and By-Group processing
    • Explicit Output Statements
    • Nesting Do loops
    • Do While and Do Until Statement
    • Array elements and Range
  • Combining Datasets (Appending and Merging)
    • Concatenation
    • Interleaving
    • Proc Append
    • One To One Merging
    • Match Merging
    • IN = Controlling SAS merge and Indicator

ADVANCE SAS – DATA MINING WITH PROC SQL

  • Introduction to Databases
  • Introduction to Proc SQL
  • Basics of General SQL language
  • Creating table and Inserting Values
  • Retrieve & Summarize data
  • Group, Sort & Filter
  • Using Joins (Full, Inner, Left, Right and Outer)
  • Reporting and summary analysis
  • Concept of Indexes and creating Indexes (simple and composite)
  • Connecting SAS to external Databases
  • Implicit and Explicit pass through methods

ADVANCE SAS – SAS MACROS

  • Macro Parameters and Variables
  • Different types of Macro Creation
  • Defining and calling a macro
  • Using call Symput and Symget
  • Macros options (mprint symbolgen mlogic merror serror)

 

Course Features

  • Students 0 student
  • Max Students1000
  • Duration10 week
  • Skill levelall
  • LanguageEnglish
  • Re-take courseN/A
Curriculum is empty

Instructor

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Related Courses