Programming Skills

Base SAS Training

Base SAS is a flexible and extensible fourth-generation programming language designed for data access, transformation and reporting.

Base SAS Online training

at BestOnlineTrainers starts with the basics of SAS, Oracle SQL concepts and ends with one project. Base SAS provides a scalable, integrated software environment specially designed for data access, transformation and reporting. It includes a fourth-generation programming language; ready-to-use programs for data manipulation, information storage and retrieval, descriptive statistics and report writing; and a powerful macro facility that reduces programming time and maintenance headaches.

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile

PART-I

BASE SAS

  • Introduction To SAS System & Architecture
  • History And Various Modules
  • Features
  • Variables & SAS Syntax Rules
  • SAS Data Sets
  • Data Set Options
  • Operators
  • Reading Raw Data
  • Infile Statement With Options
  • Working With External Files & Options
  • Multiple Observations
  • Input Styles
  • Select Statement
  • Leave and Continue Statements
  • Creating & Redefining Variables
  • Where Statement
  • If – Then Else Statement
  • Goto, Stop And Error Statements
  • Output Statement, Put Statement
  • Do Loops
  • Modifying And Combining Data Sets
  • Updating Master Data Set
  • Display Manager Commands
  • SAS Functions

Base SAS Procedures

  • Proc sort
  • Proc Print
  • Proc Means
  • Proc Freq
  • Proc Plot
  • Proc Chart
  • Proc Copy
  • Proc Summary
  • Proc Append
  • Proc Datasets
  • Proc Contents
  • Proc Delete
  • Proc Format
  • Proc Import
  • Proc Export

PART -II

Oracle - SQL Concepts

  • Introduction
  • History
  • Features
  • Sql Command Set
  • Operators In Sql
  • Order By Clause
  • Group By Clause
  • Having Clause
  • Distinct Clause
  • Create and Insert
  • Deleting, Populating And Updating

SAS/SQL

  • Introduction To SAS/Sql
  • Features
  • Uses
  • Terminology
  • Data Types, Key Words, & Operators
  • Functions, Predicates
  • Formatting Output
  • Group By Clause
  • Order By Clause
  • Having Clause
  • Case Expression And Conditional Logic.
  • Creating ,Populating & Deleting Tables
  • Alter Table Statement
  • Changing Column’s Length
  • Joins
  • Constraints
  • Renaming A Table & Columns
  • Views

SAS/ACCESS

  • Working With Oracle
  • Working With Ms-Access
  • Working With Ms-Excel
  • DBLoad Procedure

SAS/GRAPH

  • Gchart Procedure
  • Vertical, Horizontal, Pie
  • Donut
  • G3d
  • Group, Subgroups
  • Gplot Procedure
  • Multiple Plots & Overlay
  • Symbol Statement
  • Title And Footnote Statements
  • Goptions

SAS/REPORTS

  • Frequency Report
  • One-Way Frequency Report
  • Cross Tabular Frequency Report
  • Summary Statistics
  • Creating A List Report
  • Define Statement
  • Order Usage and Group
  • Printing Grand Totals
  • Rbreak Statement
  • Tabulate Procedure
  • One-Dimensional Tables
  • Two-Dimensional Tables
  • Obtaining A Total
  • Analysis Variables with options
  • Summary Statistics

SAS/MACROS

  • Macro Concepts
  • Macros And Macro Variables
  • Creating Macro Variables
  • Using Macro Variables
  • Creating Modular Code With Macros
  • Invoking A Macro
  • Adding Parameters To Macros
  • Macros With Conditional Logic
  • Using Various Procedures In Macros
  • Automatic Variables
  • Macro Functions
  • Including External Macros

SAS/STAT

  • Proc Univariate
  • Proc Corr
  • Proc Reg
  • Proc Anova

SAS/ODS

  • Creating Rtf File
  • Creating Html File
  • Creating Pdf File

PART-III (Only One Project)

  • Clinical Project
  • Banking Project

Base SAS training is intended for:

  • Programmers
  • Students who want to make their career in Base SAS

We guarantee learning at your convenience & pace.

  • Instant Access:
    Get instant access to self-paced training after signup.
  • Streaming video recording:
    Watch lessons any time at your schedule, free recording.
  • Exercises:
    Practical exercises help you test what you are learning as you go.
  • Free Demo:
    Sign up for free demo to check whether the course is right for you and interact with the faculty live.
  • Experienced Trainers:
    We only hire the industry’s best trainers
  • Live free interactive web sessions:
    Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
  • Structured Curriculum Schedule:
    Progress with your complete daily interactive lessons and assignments.
  • Faculty Mentoring:
    Turn in daily and weekly homework for personalized feedback from faculty.
  • Virtual Office Hours:
    Live interaction with the faculty and other students around the world.
  • Hands on Live Projects:
    Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

N/A

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:

 

Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K