COURSE DESCRIPTION
SAS Base and Advance – can answer many problems with its simple, dynamic, versatile, user friendly, secure programming Interface which encompasses variety of tools to perform various operations ranging from simple descriptive statistics to complex inferential statistical procedures supporting different programming languages including C,C++,SQL.
SAS Base and Advance – can access the data from variety of sources such as text, excel, csv, database and generate output in different file formats.
COURSE STRUCTURE
SAS BASE
It includes the basic programming concepts such as:
- Creating New Data Tables and copying from existing tables using INPUT,DATALINES,SET Statements in Data step.
- Accessing the data Through Libraries into SAS.
- Importing data into SAS environment using INFILE and PROC IMPORT.
- Exploring the Data using PROC PRINT, PROC FREQ, PROC MEANS and PROC UNIVARIATE.
- Filtering The data using WHERE Expression and Macro Variables.
- Formatting ,Sorting the Data and Removing duplicate rows using Formats and PROC SORT.
- Computing New Columns using
- A)Numeric functions such as int,ceil,round ,abs,sqrt.
- B)Aggregate functions such as sum,mean,median,min,max.
- C)Character functions such as length,upcase,lowcase,propcase,substr,index and other functions.
- Conditional processing of Data using IF-THEN,IF-THEN-ELSE, DO , DO-WHILE, DO-UNTIL loops.
- Restructuring the data using PROC TRANSPOSE.
- Joining the tables by concatenation using SET statement.
- Joining the tables by Merging using MERGE statement.
- Analyzing and Reporting the Data using PROC FREQ ,PROC MEANS and PROC REPORT.
- Exporting the results in differents Formats (Excel,RTF,PDF,CSV)using PROC EXPORT and ODS(Output Delivery System).
SAS ADVANCE
It Includes advance programmning concepts basically divided into:
I. MACROS:Macros are reusable Program codes written to ease the burden of programmers by reducing the complexity and length of program.
It includes advance concepts of Macro language such as
1.Creating Local and Global Macro variables using %let statement.
2.Defining and calling the Macros.
3.Performing Arithmetic calculations using eval() and sysevalf() functions.
4.Manipulating the data using macro functions such as %upcase(), %lowcase(), %length(), %index() etc.
5.Conditional processing of data using %if %then %else, %Do loop, %Do while, %Do until loops.
6.Creating re-usable Programs by adding SAS procedures like PROC PRINT, PROC FREQ, PROC MEANS etc. inside the macros.
7.Use of Automatic SAS macro variables in Titles and Footnote.
8.Creating Macro variables in data step by using call routine like call symput.
9. Debugging the macro programs using SYMBOLGEN, MPRINT, MLOGIC.
II. SQL:Structured Query language deals with DDL, DML, DQL, DCL as follows:
1.Creating New Tables or Copying from existing tables using PROC SQL.
2.Altering and Updating Tables using PROC SQL.
3.Updating rows .
4.Dropping Tables and Columns.
5.Inserting Rows into the tables.
6.Filtering the data using select statement and where expression in PROC SQL.
7.Renaming and Assigning labels to the variables.
8.Manipulating the data using Numeric, Aggregate and String functions in PROC SQL.
9.Sorting the data and grouping of variables in PROC SQL.
10.Cleaning the data and removing duplicate rows using Distinct clause in PROC SQL.
11. Joining the tables using SET OPERATORS(UNION ALL,UNION,INTERCEPT,EXCEPT).
12.Joining the tables using JOINS(INNER JOIN,OUTER JOIN etc).
13.Securing data and preventing duplicate records using PRIMARY KEY,FOREIGN KEY,CONSTRAINTS.
CERTIFICATION:
After completion of this course and evaluating your performance , E-certificate are awarded to the candidates.
LEARNING OUTCOMES
- Over 50 lectures and 60 hours of content.
- LIVE PROJECT End to End Software Testing Training Included.
- Learn Software Testing and Automation basics from a professional trainer from your own desk.
- Information packed practical training starting from basics to advanced Programming techniques.
- Best suitable for beginners to advanced level users and who learn faster when demonstrated.
- Course content designed by considering current software technology and the job market.
- Practical assignments at the end of every session.
- Practical learning experience with live project work and examples.
Curriculum
- 6 Sections
- 36 Lessons
- 10 Weeks
- WEEK 1-BASICS OF SAS AND READING INSTREAM DATA AND READING FROM EXTERNAL FILE10 ItemsIn this section we are going to see the basics of SAS , including Accesssing SAS on Demand, Reading Instream Data by List input and advanced list input methods. Also this section covers Reading And Displaying Dates by informat and format statements. We will also see How to import data from External Files in Data step Using Infile and in Proc Step Using PROC IMPORT. Also we will see how to read data by assigning libraries
- 1.1INTRODUCTION TO SAS
- 1.2ACCESSING SAS ON DEMAND
- 1.3READING INSTREAM DATA INTO SAS USING LIST INPUT METHOD
- 1.4READING INSTREAM DATA BY ADVANCED LIST INPUT METHOD
- 1.5READING DATES INTO SAS PART1
- 1.6READING DATES INTO SAS PART2
- 1.7READING DATA USING INFILE
- 1.8READING DATA USING PROC IMPORT PART
- 1.9Exporting data using PROC EXPORT
- 1.10READING THROUGH ASSIGNING LIBRARIES
- WEEK 2-SORTING , FILTERING AND MANIPULATING THE DATA7 ItemsIn this section we will see how to sot the data in ascending or descending order using PROC SORT. And also Removing Duplicate rows Using PROC SORT. We will also see Filtering the data Using WHERE Expression with Operators And also we will see Manipulation of Data using Functions.
- 2.1Sorting Data in Ascending or Descending Order using Proc Sort
- 2.2Removing Duplicate rows Using Proc Sort
- 2.3Filtering data By WHERE Expresiion Using Basic Operators
- 2.4Filtering Data by WHERE Expression Using Special Operators
- 2.5Simple Numeric Functions and Aggregate Numeric Functions
- 2.6Character or String Functions
- 2.7Date Functions
- WEEK 3-CONDITIONAL PROCESSING, SUMMARISING DATA AND BY GROUP PROCESSING6 ItemsIn this section we will see how to sot the data in ascending or descending order using PROC SORT. And also Removing Duplicate rows Using PROC SORT. We will also see Filtering the data Using WHERE Expression with Operators
- WEEK 4-ANALYZING DATA, MAKING CUSTOM FORMATS, TRANSPOSING DATA7 Items
- WEEK 5-VALIDATING DATA ,GENERATING REPORTS, MISCELLANEOUS PROCEDURES6 Items
- WEEK 6-SAS ADVANCE (MACROS AND SQL)0 Items
Requirements
- Graduates from any background
Features
- In this course SAS Programming concepts are covered from Basic to Advance level
- Intensive Training Covering A to Z concepts in SAS