SAS Complete Course -Programming 1_2

Teacher
maziworld
Category:
SAS
4 out of 5
4
6 reviews
masterstudy_placeholder

Base SAS includes a programming language that manages your data, includes procedures for data analysis, reporting, and managing SAS files, and a windowing environment for text editing and file management.

Main Feactures of SAS or how doi I know wheather I am success in this course.you need to have the knowledge on :

  1. Data Access
  2. Management
  3. Analysis
  4. Presentation

 

What advanced SAS?

Write and execute SAS code during your exam. During this performance-based exam, candidates will access a SAS environment. Building on your skills earned with a Base Programming Credential, you will now work with SQL, the SAS Macro facility, and advanced coding techniques such as arrays, hash objects.

 

Software Installation : Currently software installation is a paid one. You need to do it from system administrator. The total software which consists of around 17 Gb. It will take 2 Hours to do the installation.

System requirements :

Processor : i3 and above

RAM : 4GB and above [preferable 8 GB Best ]

Harddisk : SSD Harddisk with 250 GB OR Above  / other harddisk also its ok

 

Target Audience :

Any person who completed the graducation is perfect. This Base SAS Is a foundation tool  and its very easy to learn very basic coding language will be there.the most important thing is that when ever you start the class from the day you need to have the SAS Software Installation.

 

Materials :

Books and Daily notes will be provided by us along with that recording also will be provided for reference . Step by step notes will be provided and excersises also.

Sample Videos : We request you that first don’t join the course directly as we provide the sample videos in the cirriculam first watch that try to understand. If you understand and feel comfortable with trainer explanation then gohead for classes. Join the course.

Working hours  : 9:00 am ist  to 8 pm ist .

Base SAS Certification

Chapter 1: Introduction

1
An overview foundation of SAS

Chapter 2: Getting started with SAS

1
Introduction to SAS programs
2
Submitting a program
3
Exercises /quiz

Chapter 3: Working with SAS Syntax

1
Mastering Fundamental Concepts
2
Diagnosis and Correcting syntax errors
3
Exercises

Chapter 4: Getting familiar with SAS Datasets

1
Understanding the PDV Process
2
Accessing sas data libraries and Relational databases
3
Exercises

Chapter 5: Reading SAS Datasets

1
Introduction to Reading Data
2
Using SAS Data as Input
3
Subsetting Observations variables
4
Adding permanent attributes
5
Exercises

Chapter 6: Reading excel worksheets

1
Using excel data as input
2
Reading excel worksheets
3
Exercises

Chapter 7: Reading delimited raw data files

1
Using standard delimited data as input
2
Using NON standard delimited data as input
3
Exercises

Chapter 8: Validating and Cleaning data

1
Introduction to Validating and Cleaning data
2
Examining data errors when reading raw datafiles
3
Validating data with print and freq procedure
4
Validation data with means and Univariate procedure
5
Cleaning invalid data with windows and UNIX
6
Using FSEDIT window to clean the data
7
Exercises

Chapter 9:Manipulating the data

1
Creating variables
2
Creating Varibles conditionally
3
Subsetting observations
4
Excersises

Chapter 10: Combining the sas datasets

1
Introduction to Combining the datasets
2
Appending the sas datasets
3
Concatenation of sas datasets
4
Merging the sas datasets [One to one / One to many ]
5
Merging datasets with Non-Matches
6
Exercises

Exercises Chapter 11: Enhancing the Reports

1
Using global statements
2
Adding labels and formats
3
Creating used defined formats
4
Subetting and Grouping Observations
5
Direct output to the external files HTML /PDF/EXCELXP/RTF
6
Exercises

Chapter 12: Producing summary reports

1
Using Freq Procedure
2
Using means procedure
3
Using Tabulate Procedure

Chapter 13 : Controlling input and output

1
Output multiple observations
2
Writing to multiple sas datasets
3
Selecting variables and Observations
4
Writing to an external file
5
Exercises

Chapter 14 : Summarizing Data

1
Creating and Accumulating total variables
2
Accumulating totals for a group of data
3
Exercises

Chapter 15 : Reading and writing different types of data

1
Reading Delimited rawdata files
2
Controlling when a record loads
3
Reading hierarchical rawdata files
4
Exercises

Chapter 16: Transformations

1
Introduction
2
Manipulating character values
3
Manipulating Numeric Values
4
Manipulating Numeric values based on Dates
5
Converting variable type
6
Exercises

Chapter 17 : Debugging Techniques

1
Using PUT Statement
2
Debug Option

Chapter 18 : Processing data iteratively

1
DO Loop Processing
2
SAS Array Processing
3
Using SAS Arrays
4
Exercises

Chapter 19: Combining the sas datasets

1
Match merging two or more sas datasets
2
Simple joins using sas sql procedure
3
Exercises

Advanced Programming

1
Setting up for this course.
2
DATA step review.
3
Using Advanced Functions
4
Using a variety of advanced functions.
5
Performing pattern matching with Perl regular expressions.
6
Defining and Processing Arrays
7
Defining and referencing one-dimensional arrays.
8
Doing more with one-dimensional arrays.
9
Defining and referencing two-dimensional arrays.
10
Defining and Processing Hash Objects
11
Declaring hash objects.
12
Defining hash objects.
13
Finding key values in a hash object.
14
Writing a hash object to a table.
15
Using hash iterator objects.
16
Using Utility Procedures
17
Creating picture formats with the FORMAT procedure.
18
Creating functions with the FCMP procedure.

SAS SQL Course Contents

Chapter 1 : Introduction

1
Structured Query Language
2
SAS Functions
3
Case Study

Chapter 2 : Basic Queries

1
Overview of sql procedure
2
Specifying Columns
3
Specifying Rows
4
Presenting data
5
Summarizing data
6
Exercises

Chapter 3 : Combining Tables

1
Overview
2
Joins
3
Complex Joins
4
Set operators
5
Exercises

Chapter 4: Creating and modifying tables and views

1
Creating tables
2
Creating views
3
Creating Indexes
4
Maintaining Tables
5
Exercises

Chapter 5 : Additional SQL features

1
Setting PROC SQL Options
2
Dictionary Tables and Views
3
Interfacing PROC SQL with macro language
4
Program testing and performance

Chapter 6: Overview of table and column name

1
Table and Column names Sorted by Column names
2
Table and column names Sorted by table names
3
Partial table listings

Chapter 7: Dictonary Tables

Chapter 8: Highly Advanced Concepts

Chapter 9: Top 30 professional Programming techniques

SAS MACROS

Chapter 1: Introduction

1
Purpose of the macro facility
2
Program flow
3
Course data

Chapter 2 : Macro Variables

1
Introduction to Macro variables
2
Automatic Variables
3
Macro Variable References
4
User defined macro variables
5
Delimiting macro variables names
6
Macro Functions

Chapter 3: Macro definitions

1
Defining and calling a Macro
2
Macro Parameters

Chapter 4: DATA step and SQL Interfaces

1
Creating Macro variables in the data step
2
Indirect reference to macro variables
3
Retrieving macro variables in the data step
4
Creating macro variables in SQL

Chapter 5 : Macro Programs

1
Conditionally Processing
2
Iterative processing
3
Global and Local Symbol tables

Chapter 6 : Macro Execution Process

Chapter 7: Advanced Concepts

Chapter 8: Top 30 professional Programming techniques

Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Get course
Enrolled: 34 students
Duration: 75 Days
Lectures: 117
Video: Available
Level: Advanced

Archive

Working hours

Monday 9:00 am to 8 pm ist
Tuesday 9:00 am to 8 pm ist
Wednesday 9:00 am to 8 pm ist
Thursday 9:00 am to 8 pm ist
Friday 9:00 am to 8 pm ist
Saturday 9:00 am to 8 pm ist
Sunday Closed