DEMO

SAS OFFLINE BATCH

SAS OFFLINE DEMO CLASS : 13-June-2022 (Monday) @ 8.00 AM (OFFLINE)

SAS OFFLINE DEMO CLASS : 13-June-2022 (Monday) @ 8.00 AM (OFFLINE)

SAS OFFLINE DEMO CLASS : 13-June-2022 (Monday) @ 8.00 AM (OFFLINE)

SAS OFFLINE DEMO CLASS : 13-June-2022 (Monday) @ 8.00 AM (OFFLINE)

NEW BATCHES :-

BATCH TIMINGS :  

OFFLINE @08.00 AM TO 9.00 AM

 

 

Faculty: Mr. SRINIVAS RAO

Experience:

14+ Yrs Experience in SAS Programmer

Duration: 100 Hours (40 Hours – BASE, 30 Hours – ADVANCED, 30 Hours -PROJECT)

Lab: 24/7 Lab (With Lab Fac Assistance)

Venue: #7-1-621/113(67/3RT), Near Community Hall, between Apollo and Nagarjuna high school, S.R.Nagar, Hyderabad-38, Telangana.

SAS Base & Advance Course Content – Around 200 HOURS      

WHAT IS SAS and BASICS of SAS- 12HOURS

  • History Of Sas
  • Functionality Of Sas
  • Architecture Of Sas
  • Sas Program Rules
  • File Elements Of Sas
  • Sas Names & Rule
  • Missing Data
  • Types Of Variables
  • How Sas System Read Values Into Variables
  • Lengths of Variables
  • Sas Windowing Environment
  • Sas Program & Components Of Sas Program
  • Creation Of Libraries
  • Member Types
  • Datasets
  • Views
  • Catalogs
  • Indexes
  • Sas Programming (Briefly)
  • Data Step
  • Proc Step
  • Global Options
  • Global Statements
  • Backend Process Of SAS Program
  • Installation Process
  • ETL Concepts

 

BEGIN WITH DATASTEP - 10 HOURS

  • Data Step & Purpose of Data Step
  • Data Statement & Dataset Options
  • Infile Statement & Options
  • Input Statement & Types of Input & Options
  • Datalines / Cards Statement (or) Datalines4 / Cards4 Statement
  • Run Statement / Quit Statement

 

ATTRIBUTES OF VARIABLES - 8 HOURS

  • Data Types
  • Label Statement
  • Length Statement
  • Informat Statement
  • Format Statement
  • How Dates Works In Sas
  • System Defined / User Defined Informats & Formats

 

OTHER SAS STATEMENTS - 5 HOURS

  • Keep Statement
  • Drop Statement
  • Rename Statement
  • Replace Statement
  • Sum Statement
  • Retain Statement
  • Goto Statement
  • Link Statement
  • Return Statement
  • Output Statement
  • Stop Statement

 

CONDITIONAL STATEMENTS - 4 HOURS

  • If Statement
  • If Then Statement
  • If Then Else Statement
  • If Then Delete Statement
  • If Then Remove Statement
  • If Then Output Statement
  • If Then Do Statement
  • If Then Do While Statement
  • If Then Do Until Statement
  • If Then Goto Statement
  • Where Statement
  • Operators
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Expressions

 

LOOPS - 5 HOURS

  • Do Statement
  • Do Iterative Statement
  • Do While Statement
  • Do Until Statement
  • End Statement
  • Output Statement
  • Stop Statement

 

ARRAY – 5 HOURS

  • Why Do We Need Arrays?
  • Basic Array Concepts
  • Array Statement
  • Array References
  • Variable Name Array Reference
  • Using Array Indexes
  • One Dimension Arrays&Multi-Dimension Arrays
  • Temporary Arrays
  • Sorting Arrays
  • Determining Array Bounds: Lbound And Hbound Functions
  • When To Use Arrays
  • Common Errors And Misunderstandings
  • Invalid Index Range
  • Function Name As An Array Name
  • Array Referenced In Multiple Data Steps, But Defined In Only One

 

BY - GROUP PROCESSING – 4 HOURS

  • Definitions For By-Group Processing
  • By-Group Processing
  • Sorting Data (Proc Sort)
  • By Value&By Group
  • First.Variable And Last.Variable
  • Modifying Sas Data Sets: Examples.
  • Invoking By-Group Processing
  • Preprocessing Input Data For By-Group Processing
  • Sorting Observations For By-Group Processing
  • Indexing For By-Group Processing
  • How The Data Step Identifies By Groups
  • Processing Observations In A By Group
  • How Sas Determines First.Variable And Last.Variable
  • Processing By-Groups In The Data Step
  • Processing By-Groups Conditionally
  • Data Not In Alphabetic Or Numeric Order
  • Data Grouped By Formatted Values

 

COMBINING SAS DATA SETS - 10 HOURS

  • Concatenation
  • Interleaving
  • Merge
  • Update
  • Modify

 

FUNCTIONS (100 + Functions) - 10 HOURS

  • Character / String Functions
  • Numeric Functions
  • Date Functions

 

REVIEW OF DATASTEP - 2 HOURS

 

 

SAS - PROCEDURES (PROC STEP) – 1 HOUR

  • What Is Proc Step
  • Purpose Of Proc Step
  • Types of Procedures

 

DATA ACCESS PROCEDURES - 4 HOURS

  • Sql Pass Thru Query (Proc Sql)
  • Proc Access
  • Proc Dbload
  • Libname Facility
  • Proc Import
  • Proc Export

 

 UTILITY PROCEDURES - 15 HOURS

  • Proc Contents
  • Proc Setinit
  • Proc Options
  • Proc Pwencode
  • Proc Copy
  • Proc Delete
  • Proc Printto
  • Proc Sort
  • Proc Compare
  • Proc Append
  • Proc Datasets
  • Proc Format
  • Proc Rank
  • Proc Transpose
  • Proc Template
  • Proc Forms
  • Proc Catalog
  • Proc Cport
  • Proc Cimport
  • Proc Upload
  • Proc Download
  • Proc Migrate

 

STATISTICS &STATISTICAL PROCEDURES - 15 HOURS

  • Proc Means
  • Proc Summary
  • Proc Univariate
  • Proc Freq
  • Proc Corr
  • Proc Reg
  • Proc Anova
  • Proc Glm
  • Proc Lifetest
  • Proc Lifereg
  • Proc Logistics
  • Proc Npar1way
  • Proc Ttest

 

REPORTING PROCEDURES - 10 HOURS

  • Proc Print
  • Proc Tabulate
  • Proc Report
  • Data Step Reporting (_Null_ Reporting)

 

GRAPHICAL PROCEDURES - 5 HOURS

  • Proc Gchart
  • Proc Gplot
  • Proc Sgplot
  • Proc Gis
  • Proc Gmap

 

REVIEW OF PROCSTEP - 2 HOURS

 

 

ODS (OUTPUT DELIVERY SYSTM) - 5 HOURS

  • Definition & Purpose of ODS/
  • Reports into Html, Rtf, Pdf, Excel, Csv, Ps, Xml, Markup, Css, Pcl, Output & Listing.
  • Ods File Formatting Options
  • General Ods Statements
  • Excel  XP Tagsets
  • The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset
  • Exporting an XML Document Using a Customized Tagset
  • CSV Tagsets

 

SAS DDE (Dynamic Data Exchange) – 2 Hours

  • Introduction of DDE
  • DDE Preliminaries
  • Starting Up Excel
  • Loading and Saving a Workbook
  • Inserting SAS Data
  • Formatting of Excel Worksheet Cells
  • Insert an Excel Macro Sheet
  • Rename a Worksheet
  • Get Existing Sheet Names

 

DICTIONARY TABLES - 2 HOURS

  • What is Dictionary Tables?
  • Purpose of Dictionary Tables?
  • Vallopt, Vcatalog, Vcformat, Vchkcon, Vcolumn, Vdctnry, Vdest, Vengine, Vfilter,
  • Vformat, Vfunc, Vgopt, Vindex, Vinfomp, Vlibnam, Vlocale, Vmacro, Vmember, Voption,
  • Vsaccess, Vscatlg, Vslib, Vstable, Vstyle, Vsview, Vtable, Vtitle and Vview etc...

 

LIST OF GLOBAL STATEMENTS - 3 HOURS

  • X
  • Dm
  • Libname
  • Filename
  • Legend
  • Symbol
  • Title
  • Footnote
  • Ods

 

 

LIST OF GLOBAL OPTIONS - 5 HOURS

  • Date/Nodate
  • Number/Nonumber
  • Orientation
  • Missing
  • LS (Line Size)
  • PS (Page Size)
  • Year cut off
  • Sysprint
  • Sysin
  • User
  • Font
  • Validvarname
  • Formchar
  • Byline
  • Compress
  • Caps/Nocaps
  • Source/Nosource
  • Notes/Nonotes
  • Repalce/Noreplace
  • Firstobs
  • Obs
  • Buffno
  • Buffsize
  • Fmtsearch
  • Macro
  • Mstored
  • SASMstore
  • SASAutos
  • Merror/NoMerror
  • Serror/NoSerror
  • Mprint/NoMprint
  • Mlogic/NoMlogic
  • Symbolgen/NoSymbolgen

 

PROC SQL – 20 HOURS

INTRODUCTION TO THE SQL PROCEDURE

  • What Is Sql?
  • What Is The Sql Procedure?
  • Terminology
  • Comparing Proc Sql With The Sas Data Step

 

RETRIEVING DATA FROM A SINGLE TABLE

  • Overview Of The Select Statement
  • Selecting Columns In A Table
  • Creating New Columns
  • Sorting Data
  • Retrieving Rows That Satisfy A Condition
  • Summarizing Data
  • Grouping Data
  • Filtering Grouped Data
  • Validating A Query

 

RETRIEVING DATA FROM MULTIPLE TABLES

  • Introduction
  • Selecting Data From More Than One Table By Using Joins
  • Using Sub queries To Select Data
  • When To Use Joins And Sub queries
  • Combining Queries With Set Operators

 

 

CREATING AND UPDATING TABLES AND VIEWS

  • Introduction
  • Creating Tables
  • Inserting Rows Into Tables
  • Updating Data Values In A Table
  • Deleting Rows
  • Altering Columns
  • Creating An Index
  • Deleting A Table
  • Using Sql Procedure Tables In Sas Software
  • Creating And Using Integrity Constraints In A Table
  • Creating And Using Proc Sql Views

 

PROGRAMMING WITH THE SQL PROCEDURE

  • Introduction
  • Using Proc Sql Options To Create And Debug Queries
  • Improving Query Performance
  • Accessing Sas System Information Using Dictionary Tables
  • Using Proc Sql With The Sas Macro Facility
  • Formatting Proc Sql Output Using The Report Procedure
  • Accessing A Dbms With Sas/Access Software
  • Using The Output Delivery System (Ods) With Proc Sql

 

PRACTICAL PROBLEM-SOLVING WITH PROC SQL

  • Computing A Weighted Average
  • Comparing Tables
  • Overlaying Missing Data Values
  • Computing Percentages Within Subtotals
  • Counting Duplicate Rows In A Table
  • Expanding Hierarchical Data In A Table
  • Summarizing Data In Multiple Columns
  • Creating A Summary Report
  • Creating A Customized Sort Order
  • Conditionally Updating A Table
  • Updating A Table With Values From Another Table
  • Creating And Using Macro Variables
  • Using Proc Sql Tables In Other Sas Procedures

 

 

SAS/MACROS - 20 HOURS

  • Introduction To The Macro Facility
  • Purpose Of The Macro Facility
  • Macro Program Flow
  • How To Create Macros
  • Session Compiled Macros
  • Autocall Macros
  • Macro Variables
  • Introduction To Macro Variables
  • Automatic Macro Variables
  • User-Defined Macro Variables
  • Delimiting Macro Variable Names
  • Deleting Macro Variables
  • Macro Functions
  • Macro Mask Functions
  • Macro Definitions
  • Defining And Calling A Macro
  • Macro Parameters
  • Macro Storage
  • Data Step And Sql Interfaces-
  • Creating Macro Variables In The Data Step
  • Indirect References To Macro Variables
  • Retrieving Macro Variables In The Data Step
  • Creating Macro Variables In Sql
  • Macro Programs
  • Conditional Processing
  • Parameter Validation
  • Iterative Processing
  • Global And Local Symbol Tables
  • Framework For Developing Macro Applications
  • Debugging And Troubleshooting
  • Generating Custom Messages
  • Creating Efficient Macros
  • Review Of Macros

 

PERFORMANCE TUNING CONCEPTS - 2 HOURS

  • Cpu Time
  • Data Storage
  • I/0
  • Memory
  • Programming Time

 

TESTING & DEBUGGING TECHNIQUES - 2 HOURS

  • Data Step Debugging
  • Macro Debugging
  • Debugging Options

 

ERROR HANDLING - 2 HOURS

  • Syntax Errors
  • Logical Errors
  • Semantic Errors

 

FEATURES BETWEEN SAS VERSIONS V9 - 2 HOURS

  • 9.1
  • 9.1.2
  • 9.1.3
  • 9.2
  • 9.3
  • 9.4

 

SAS WITH UNIX/LINUX ENVIRONMENT - 10 HOURS

 

CERTIFICATION CLASSES - 10 HOURS

  • Base Sas Certification
  • Adv Sas Certification

 

 

SAS EG (Enterprise Guide) - 10 HOURS

  • Getting Started with SAS Enterprise Guide
  • Creating Reports
  • Working with Data in the Query Builder
  • Joining Two Data Files Together
  • SAS Enterprise Guide Basics
  • Bringing Data into a Project
  • Working with Tasks
  • Producing Complex Reports in Summary Tables
  • Modifying Data Using the Query Builder
  • Sorting and Filtering Data
  • Combining Data Tables
  • Basic Statistical Analysis

 

PROJECTS

  • BFSI (Banking, Finance, Insurance/Healthcare) – 30HOURS
  • CLINICAL – 60HOURS (Along with CDISC)

 

FREE CLASSES

Along with SAS U will get Free classes which helps to make you more Understanding to get good & quick job.

  • Operating System ( Windows, Unix & Linux ) – 30 Hours
  • Database (Oracle Sql) – 30 HOURS
  • MS-Excel (Basics, Adv, Macros, Vba, Analytics & MIS) – 60 Hours
  • Statistics  - 30 Hours
  • Communication, Personality Development, Aptitude & Reasoning – 30 Hours

 

ELIGIBILITY:

Clinical / Life science /Healthcare Domain

  • B.Sc (B.Z.C, Chemistry, Biotech, Microbiology, Bio chemistry, Nutrition, Statistics)
  • M.Sc (Clinical research, Biotech, Microbiology, Zoology, Botony, Chemistry, Statistics)
  • PHARMACY (B.Pharmacy, D.Pharmacy, M.Pharmacy),
  • Medical (BDS, BHMS, BAMS, MBBS),
  • B.E/B.Tech (Biotech, Bio Informatics, Computer Science).

Banking/Finance/Healthcare/Retail & Telecom Domain     

(Any graduate/ post graduate is eligible)

  • B.Sc, B.A, B.COM, CA, BBA, BBM, BCA, B.Tech, B.E
  • M.Sc, M.A, M.COM, MBA, MCA, PGDM, M.Tech

 

For any queries please contact STANSYS

Between Apollo Clinic & Nagarjuna High School,

Sanjeevareddy Nagar, Hyderabad- 500038, Telangana.

 

FACULTY PROFILE

Faculty Name: Mr. Krishna

Experience: 13+ Yrs Experience in SAS Programmer

                   8+Yrs Experience in SAS Trainer

Worked for WIPRO, SAS INDIA, ICICI, TETRASOFT

More than 4500+ students got trained

So far 2000+ (knowing) students got placed in different MNC’S

Corporate Trainer for Accenture, Capgemini, Wipro, ICICI

Training& Certifications:

Trained from SAS INDIA (BASE, ADVANCED, BI, RISK MANAGEMENT)

BASE & ADVANCED SAS Certified Professional

Contact Number: 040-48524449 / 9542195422

SAS OFFLINE & ONLINE BATCH

SAS OFFLINE & ONLINE DEMO CLASS : 13-June-2022 (Monday) @ 8 .00 AM

SAS OFFLINE & ONLINE DEMO CLASS : 13-June-2022 (Monday) @ 8 .00 AM

SAS OFFLINE & ONLINE DEMO CLASS : 13-June-2022 (Monday) @ 8 .00 AM

SAS OFFLINE & ONLINE DEMO CLASS : 13-June-2022 (Monday)  @ 8 .00 AM

 

OFFLINE @ 8.00 AM  to 9.00 AM

NEW BATCHES :-

BATCH TIMINGS :  

ONLINE: 8.00 PM TO 9.00 PM

Faculty: Mr. SRINIVAS RAO

Experience:

14+ Yrs Experience in SAS Programmer

Duration: 100 Hours (40 Hours – BASE, 30 Hours – ADVANCED, 30 Hours -PROJECT)

Lab: 24/7 Lab (With Lab Fac Assistance)

Venue: #7-1-621/113(67/3RT), Near Community Hall, between Apollo and Nagarjuna high school, S.R.Nagar, Hyderabad-38, Telangana.

 

We are going to cover (100 Hours)

WHAT IS SAS and BASICS of SAS- 12HOURS

  • History Of Sas
  • Functionality Of Sas
  • Architecture Of Sas
  • Sas Program Rules
  • File Elements Of Sas
  • Sas Names & Rule
  • Missing Data
  • Types Of Variables
  • How Sas System Read Values Into Variables
  • Lengths of Variables
  • Sas Windowing Environment
  • Sas Program & Components Of Sas Program
  • Creation Of Libraries
  • Member Types
  • Datasets
  • Views
  • Catalogs
  • Indexes
  • Sas Programming (Briefly)
  • Data Step
  • Proc Step
  • Global Options
  • Global Statements
  • Backend Process Of SAS Program
  • Installation Process
  • ETL Concepts

 

BEGIN WITH DATASTEP - 10 HOURS

  • Data Step & Purpose of Data Step
  • Data Statement & Dataset Options
  • Infile Statement & Options
  • Input Statement & Types of Input & Options
  • Datalines / Cards Statement (or) Datalines4 / Cards4 Statement
  • Run Statement / Quit Statement

 

ATTRIBUTES OF VARIABLES - 8 HOURS

  • Data Types
  • Label Statement
  • Length Statement
  • Informat Statement
  • Format Statement
  • How Dates Works In Sas
  • System Defined / User Defined Informats & Formats

 

OTHER SAS STATEMENTS - 5 HOURS

  • Keep Statement
  • Drop Statement
  • Rename Statement
  • Replace Statement
  • Sum Statement
  • Retain Statement
  • Goto Statement
  • Link Statement
  • Return Statement
  • Output Statement
  • Stop Statement

 

CONDITIONAL STATEMENTS - 4 HOURS

  • If Statement
  • If Then Statement
  • If Then Else Statement
  • If Then Delete Statement
  • If Then Remove Statement
  • If Then Output Statement
  • If Then Do Statement
  • If Then Do While Statement
  • If Then Do Until Statement
  • If Then Goto Statement
  • Where Statement
  • Operators
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • Expressions

 

LOOPS - 5 HOURS

  • Do Statement
  • Do Iterative Statement
  • Do While Statement
  • Do Until Statement
  • End Statement
  • Output Statement
  • Stop Statement

 

ARRAY – 5 HOURS

  • Why Do We Need Arrays?
  • Basic Array Concepts
  • Array Statement
  • Array References
  • Variable Name Array Reference
  • Using Array Indexes
  • One Dimension Arrays&Multi-Dimension Arrays
  • Temporary Arrays
  • Sorting Arrays
  • Determining Array Bounds: Lbound And Hbound Functions
  • When To Use Arrays
  • Common Errors And Misunderstandings
  • Invalid Index Range
  • Function Name As An Array Name
  • Array Referenced In Multiple Data Steps, But Defined In Only One

 

BY - GROUP PROCESSING – 4 HOURS

  • Definitions For By-Group Processing
  • By-Group Processing
  • Sorting Data (Proc Sort)
  • By Value&By Group
  • First.Variable And Last.Variable
  • Modifying Sas Data Sets: Examples.
  • Invoking By-Group Processing
  • Preprocessing Input Data For By-Group Processing
  • Sorting Observations For By-Group Processing
  • Indexing For By-Group Processing
  • How The Data Step Identifies By Groups
  • Processing Observations In A By Group
  • How Sas Determines First.Variable And Last.Variable
  • Processing By-Groups In The Data Step
  • Processing By-Groups Conditionally
  • Data Not In Alphabetic Or Numeric Order
  • Data Grouped By Formatted Values

 

COMBINING SAS DATA SETS - 10 HOURS

  • Concatenation
  • Interleaving
  • Merge
  • Update
  • Modify

 

FUNCTIONS (100 + Functions) - 10 HOURS

  • Character / String Functions
  • Numeric Functions
  • Date Functions
  • REVIEW OF DATASTEP - 2 HOURS

SAS - PROCEDURES (PROC STEP) – 1 HOUR

  • What Is Proc Step
  • Purpose Of Proc Step
  • Types of Procedures

 

DATA ACCESS PROCEDURES - 4 HOURS

  • Sql Pass Thru Query (Proc Sql)
  • Proc Access
  • Proc Dbload
  • Libname Facility
  • Proc Import
  • Proc Export

 

 UTILITY PROCEDURES - 15 HOURS

  • Proc Contents
  • Proc Setinit
  • Proc Options
  • Proc Pwencode
  • Proc Copy
  • Proc Delete
  • Proc Printto
  • Proc Sort
  • Proc Compare
  • Proc Append
  • Proc Datasets
  • Proc Format
  • Proc Rank
  • Proc Transpose
  • Proc Template
  • Proc Forms
  • Proc Catalog
  • Proc Cport
  • Proc Cimport
  • Proc Upload
  • Proc Download
  • Proc Migrate

 

STATISTICS &STATISTICAL PROCEDURES - 15 HOURS

  • Proc Means
  • Proc Summary
  • Proc Univariate
  • Proc Freq
  • Proc Corr
  • Proc Reg
  • Proc Anova
  • Proc Glm
  • Proc Lifetest
  • Proc Lifereg
  • Proc Logistics
  • Proc Npar1way
  • Proc Ttest

 

REPORTING PROCEDURES - 10 HOURS

  • Proc Print
  • Proc Tabulate
  • Proc Report
  • Data Step Reporting (_Null_ Reporting)

 

GRAPHICAL PROCEDURES - 5 HOURS

  • Proc Gchart
  • Proc Gplot
  • Proc Sgplot
  • Proc Gis
  • Proc Gmap

 

REVIEW OF PROCSTEP - 2 HOURS

 

 

ODS (OUTPUT DELIVERY SYSTM) - 5 HOURS

  • Definition & Purpose of ODS/
  • Reports into Html, Rtf, Pdf, Excel, Csv, Ps, Xml, Markup, Css, Pcl, Output & Listing.
  • Ods File Formatting Options
  • General Ods Statements
  • Excel  XP Tagsets
  • The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset
  • Exporting an XML Document Using a Customized Tagset
  • CSV Tagsets

 

SAS DDE (Dynamic Data Exchange) – 2 Hours

  • Introduction of DDE
  • DDE Preliminaries
  • Starting Up Excel
  • Loading and Saving a Workbook
  • Inserting SAS Data
  • Formatting of Excel Worksheet Cells
  • Insert an Excel Macro Sheet
  • Rename a Worksheet
  • Get Existing Sheet Names

 

DICTIONARY TABLES - 2 HOURS

  • What is Dictionary Tables?
  • Purpose of Dictionary Tables?
  • Vallopt, Vcatalog, Vcformat, Vchkcon, Vcolumn, Vdctnry, Vdest, Vengine, Vfilter,
  • Vformat, Vfunc, Vgopt, Vindex, Vinfomp, Vlibnam, Vlocale, Vmacro, Vmember, Voption,
  • Vsaccess, Vscatlg, Vslib, Vstable, Vstyle, Vsview, Vtable, Vtitle and Vview etc...

 

LIST OF GLOBAL STATEMENTS - 3 HOURS

  • X
  • Dm
  • Libname
  • Filename
  • Legend
  • Symbol
  • Title
  • Footnote
  • Ods

 

 

LIST OF GLOBAL OPTIONS - 5 HOURS

  • Date/Nodate
  • Number/Nonumber
  • Orientation
  • Missing
  • LS (Line Size)
  • PS (Page Size)
  • Year cut off
  • Sysprint
  • Sysin
  • User
  • Font
  • Validvarname
  • Formchar
  • Byline
  • Compress
  • Caps/Nocaps
  • Source/Nosource
  • Notes/Nonotes
  • Repalce/Noreplace
  • Firstobs
  • Obs
  • Buffno
  • Buffsize
  • Fmtsearch
  • Macro
  • Mstored
  • SASMstore
  • SASAutos
  • Merror/NoMerror
  • Serror/NoSerror
  • Mprint/NoMprint
  • Mlogic/NoMlogic
  • Symbolgen/NoSymbolgen

 

PROC SQL – 20 HOURS

INTRODUCTION TO THE SQL PROCEDURE

  • What Is Sql?
  • What Is The Sql Procedure?
  • Terminology
  • Comparing Proc Sql With The Sas Data Step
  • RETRIEVING DATA FROM A SINGLE TABLE
  • Overview Of The Select Statement
  • Selecting Columns In A Table
  • Creating New Columns
  • Sorting Data
  • Retrieving Rows That Satisfy A Condition
  • Summarizing Data
  • Grouping Data
  • Filtering Grouped Data
  • Validating A Query

 

RETRIEVING DATA FROM MULTIPLE TABLES

  • Introduction
  • Selecting Data From More Than One Table By Using Joins
  • Using Sub queries To Select Data
  • When To Use Joins And Sub queries
  • Combining Queries With Set Operators

CREATING AND UPDATING TABLES AND VIEWS

  • Introduction
  • Creating Tables
  • Inserting Rows Into Tables
  • Updating Data Values In A Table
  • Deleting Rows
  • Altering Columns
  • Creating An Index
  • Deleting A Table
  • Using Sql Procedure Tables In Sas Software
  • Creating And Using Integrity Constraints In A Table
  • Creating And Using Proc Sql Views

PROGRAMMING WITH THE SQL PROCEDURE

  • Introduction
  • Using Proc Sql Options To Create And Debug Queries
  • Improving Query Performance
  • Accessing Sas System Information Using Dictionary Tables
  • Using Proc Sql With The Sas Macro Facility
  • Formatting Proc Sql Output Using The Report Procedure
  • Accessing A Dbms With Sas/Access Software
  • Using The Output Delivery System (Ods) With Proc Sql

 

PRACTICAL PROBLEM-SOLVING WITH PROC SQL

  • Computing A Weighted Average
  • Comparing Tables
  • Overlaying Missing Data Values
  • Computing Percentages Within Subtotals
  • Counting Duplicate Rows In A Table
  • Expanding Hierarchical Data In A Table
  • Summarizing Data In Multiple Columns
  • Creating A Summary Report
  • Creating A Customized Sort Order
  • Conditionally Updating A Table
  • Updating A Table With Values From Another Table
  • Creating And Using Macro Variables
  • Using Proc Sql Tables In Other Sas Procedures

SAS/MACROS - 20 HOURS

  • Introduction To The Macro Facility
  • Purpose Of The Macro Facility
  • Macro Program Flow
  • How To Create Macros
  • Session Compiled Macros
  • Autocall Macros
  • Macro Variables
  • Introduction To Macro Variables
  • Automatic Macro Variables
  • User-Defined Macro Variables
  • Delimiting Macro Variable Names
  • Deleting Macro Variables
  • Macro Functions
  • Macro Mask Functions
  • Macro Definitions
  • Defining And Calling A Macro
  • Macro Parameters
  • Macro Storage
  • Data Step And Sql Interfaces-
  • Creating Macro Variables In The Data Step
  • Indirect References To Macro Variables
  • Retrieving Macro Variables In The Data Step
  • Creating Macro Variables In Sql
  • Macro Programs
  • Conditional Processing
  • Parameter Validation
  • Iterative Processing
  • Global And Local Symbol Tables
  • Framework For Developing Macro Applications
  • Debugging And Troubleshooting
  • Generating Custom Messages
  • Creating Efficient Macros
  • Review Of Macros

PERFORMANCE TUNING CONCEPTS - 2 HOURS

  • Cpu Time
  • Data Storage
  • I/0
  • Memory
  • Programming Time

TESTING & DEBUGGING TECHNIQUES - 2 HOURS

  • Data Step Debugging
  • Macro Debugging
  • Debugging Options

ERROR HANDLING - 2 HOURS

  • Syntax Errors
  • Logical Errors
  • Semantic Errors

FEATURES BETWEEN SAS VERSIONS V9 - 2 HOURS

  • 9.1
  • 9.1.2
  • 9.1.3
  • 9.2
  • 9.3
  • 9.4

SAS WITH UNIX/LINUX ENVIRONMENT - 10 HOURS

CERTIFICATION CLASSES - 10 HOURS

  • Base Sas Certification
  • Adv Sas Certification

 

SAS EG (Enterprise Guide) - 10 HOURS

  • Getting Started with SAS Enterprise Guide
  • Creating Reports
  • Working with Data in the Query Builder
  • Joining Two Data Files Together
  • SAS Enterprise Guide Basics
  • Bringing Data into a Project
  • Working with Tasks
  • Producing Complex Reports in Summary Tables
  • Modifying Data Using the Query Builder
  • Sorting and Filtering Data
  • Combining Data Tables
  • Basic Statistical Analysis

PROJECTS

  • BFSI (Banking, Finance, Insurance/Healthcare) – 30HOURS
  • CLINICAL – 60HOURS (Along with CDISC)

ELIGIBILITY:

Clinical / Life science /Healthcare Domain

  • B.Sc (B.Z.C, Chemistry, Biotech, Microbiology, Bio chemistry, Nutrition, Statistics)
  • M.Sc (Clinical research, Biotech, Microbiology, Zoology, Botony, Chemistry, Statistics)
  • PHARMACY (B.Pharmacy, D.Pharmacy, M.Pharmacy),
  • Medical (BDS, BHMS, BAMS, MBBS),
  • B.E/B.Tech (Biotech, Bio Informatics, Computer Science).

Banking/Finance/Healthcare/Retail & Telecom Domain     

(Any graduate/ post graduate is eligible)

  • B.Sc, B.A, B.COM, CA, BBA, BBM, BCA, B.Tech, B.E
  • M.Sc, M.A, M.COM, MBA, MCA, PGDM, M.Tech

For any queries please contact STANSYS

Between Apollo Clinic & Nagarjuna High School,

Sanjeevareddy Nagar, Hyderabad- 500038, Telangana.

More than 4500+ students got trained

So far 2000+ (knowing) students got placed in different MNC’S

Corporate Trainer for Accenture, Capgemini, Wipro, ICICI

And after training

Project/Real time Training
Resume preparation
Providing Interview questions
Conducting Mock Interviews
Providing documents & Certification
Providing Job reference

Whatsapp image