SAS (BASE, ADVANCED)
SAS is the leader in analytics. Through innovative analytics, business intelligence and data management software and services, SAS helps customers at more than 80,000 sites make better decisions faster. Since 1976, SAS has been giving customers around the world
SAS, (pronounced “sass”) once stood for “Statistical Analysis System,”
But now it is only SAS.
SAS began at North Carolina State University as a project to analyze agricultural research. Founded in 1976 to help all sort of customers.
SAS is both software and company.
The world biggest private sector company.
SAS giving operations in various sectors like,
Automotive
Communications
Education
Banking/Financial Services
Government
Health Insurance
Health Care Providers
Hospitality & Entertainment
Insurance
Life Sciences
Manufacturing
Media
Oil & Gas
Retail
Hotels
Utilities
And giving solution lines as
Analytics
Business Intelligence
Customer Intelligence
Data Integration & ETL
Financial Intelligence
Foundation Tools
Fraud Management
Governance, Risk & Compliance
High-Performance Computing
Human Capital Intelligence
IT Management
On Demand Solutions
Performance Management
Risk Management
Supply Chain Intelligence
Sustainability Management
In 1966, there was no SAS.
But there was a need for a computerized statistics program to analyze vast amounts of agricultural data collected through
United States Department of Agriculture (USDA) grants.
Then research started by University Statisticians Southern Experiment Stations, Eight land-grant universities that received the majority of their research funding from the USDA. And some schools came together under a grant from the National Institutes of Health (NIH) to develop a general-purpose statistical software package to analyze all the agricultural data they were generating.
North Carolina State University, located in the capital city of Raleigh, North Carolina became the leader in the consortium.
North Carolina State University faculty members
Jim Goodnight and Jim Barr
Emerged as the project leaders –
Barr creating the architecture and
Goodnight implementing the features
In 1972 NIH stopped to give funds to this team, then the consortium agreed to chip in $5,000 apiece each year to allow NCSU to continue developing and maintaining the system and supporting their statistical analysis needs.
During the coming years, SAS software was licensed by pharmaceutical companies, insurance companies and banks, as well as by the academic community that had given birth to the project.
Jane Helwig, another Statistics Department employee at NCSU, Joined the project consortium as documentation writer
John Sall, a graduate student and programmer, rounded out the core team.
Incorporation
In 1976 Goodnight, Barr, Helwig and Sall left NCSU and formed
SAS Institute Inc. – a private company “devoted to the maintenance and further development of SAS.” They opened offices in a building #2806 Hillsborough Street, across from the university.
By 1980, the growing company building capacity is not sufficient in Hillsborough Street building, and then it’s moved to the site of its present headquarters offices just outside Raleigh in Cary, North Carolina. In that time employs were 20.
In this time SAS was growing, the entire computer hardware and software industry was changing, with new operating systems and platforms placing new demands on software developers one of the first steps for SAS was to adapt the software to operate on IBM’s Disk Operating System (DOS).
Now it is working on different operating systems like windows, Dos, Z/OS, UNIX and various UNIX flavors.
In 1990 SAS Company grow with employ force of 7000.
SAS celebrated its 25th anniversary in 2001,
Its turn out from various difficulties along with the millennium and the Y2K frenzy. And they created new logo and tagline presently which we are seeing Tagline is –
THE POWER TO KNOW®
SAS has been named one of FORTUNE magazine’s “100 Best Companies to Work For” every year since 1998 and no1 in 2010
SAS named the best company to work for in 2010 by FORTUNE.
Course Content
SAS (BASE, ADVANCED)
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
SAS DDE (Dynamic Data Exchange) – 2 Hours
DICTIONARY TABLES – 2 HOURS
LIST OF GLOBAL STATEMENTS – 3 HOURS
LIST OF GLOBAL OPTIONS – 5 HOURS
PROC SQL – 20 HOURS
INTRODUCTION TO THE SQL PROCEDURE
RETRIEVING DATA FROM A SINGLE TABLE
RETRIEVING DATA FROM MULTIPLE TABLES
CREATING AND UPDATING TABLES AND VIEWS
PROGRAMMING WITH THE SQL PROCEDURE
PRACTICAL PROBLEM-SOLVING WITH PROC SQL
SAS/MACROS – 20 HOURS
PERFORMANCE TUNING CONCEPTS – 2 HOURS
TESTING & DEBUGGING TECHNIQUES – 2 HOURS
ERROR HANDLING – 2 HOURS
FEATURES BETWEEN SAS VERSIONS V9 – 2 HOURS
SAS WITH UNIX/LINUX ENVIRONMENT – 10 HOURS
CERTIFICATION CLASSES – 10 HOURS
SAS EG (Enterprise Guide) – 10 HOURS
PROJECTS
FREE CLASSES
Along with SAS U will get Free classes which helps to make you more Understanding to get good & quick job.
ELIGIBILITY:
Clinical / Life science /Healthcare Domain
Banking/Finance/Healthcare/Retail & Telecom Domain
(Any graduate/ post graduate is eligible)
For any queries please contact STANSYS
• 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
o CSV Tagsets
o Introduction of DDE
o DDE Preliminaries
o Starting Up Excel
o Loading and Saving a Workbook
o Inserting SAS Data
o Formatting of Excel Worksheet Cells
o Insert an Excel Macro Sheet
o Rename a Worksheet
o Get Existing Sheet Names
o What is Dictionary Tables?
o Purpose of Dictionary Tables?
o Vallopt, Vcatalog, Vcformat, Vchkcon, Vcolumn, Vdctnry, Vdest, Vengine, Vfilter,
o Vformat, Vfunc, Vgopt, Vindex, Vinfomp, Vlibnam, Vlocale, Vmacro, Vmember, Voption,
o Vsaccess, Vscatlg, Vslib, Vstable, Vstyle, Vsview, Vtable, Vtitle and Vview etc…
o X
o Dm
o Libname
o Filename
o Legend
o Symbol
o Title
o Footnote
o Ods
o Date/Nodate
o Number/Nonumber
o Orientation
o Missing
o LS (Line Size)
o PS (Page Size)
o Year cut off
o Sysprint
o Sysin
o User
o Font
o Validvarname
o Formchar
o Byline
o Compress
o Caps/Nocaps
o Source/Nosource
o Notes/Nonotes
o Repalce/Noreplace
o Firstobs
o Obs
o Buffno
o Buffsize
o Fmtsearch
o Macro
o Mstored
o SASMstore
o SASAutos
o Merror/NoMerror
o Serror/NoSerror
o Mprint/NoMprint
o Mlogic/NoMlogic
o Symbolgen/NoSymbolgen
o What Is Sql?
o What Is The Sql Procedure?
o Terminology
o Comparing Proc Sql With The Sas Data Step
o Overview Of The Select Statement
o Selecting Columns In A Table
o Creating New Columns
o Sorting Data
o Retrieving Rows That Satisfy A Condition
o Summarizing Data
o Grouping Data
o Filtering Grouped Data
o Validating A Query
o Introduction
o Selecting Data From More Than One Table By Using Joins
o Using Sub queries To Select Data
o When To Use Joins And Sub queries
o Combining Queries With Set Operators
o Introduction
o Creating Tables
o Inserting Rows Into Tables
o Updating Data Values In A Table
o Deleting Rows
o Altering Columns
o Creating An Index
o Deleting A Table
o Using Sql Procedure Tables In Sas Software
o Creating And Using Integrity Constraints In A Table
o Creating And Using Proc Sql Views
o Introduction
o Using Proc Sql Options To Create And Debug Queries
o Improving Query Performance
o Accessing Sas System Information Using Dictionary Tables
o Using Proc Sql With The Sas Macro Facility
o Formatting Proc Sql Output Using The Report Procedure
o Accessing A Dbms With Sas/Access Software
o Using The Output Delivery System (Ods) With Proc Sql
o Computing A Weighted Average
o Comparing Tables
o Overlaying Missing Data Values
o Computing Percentages Within Subtotals
o Counting Duplicate Rows In A Table
o Expanding Hierarchical Data In A Table
o Summarizing Data In Multiple Columns
o Creating A Summary Report
o Creating A Customized Sort Order
o Conditionally Updating A Table
o Updating A Table With Values From Another Table
o Creating And Using Macro Variables
o Using Proc Sql Tables In Other Sas Procedures
o Introduction To The Macro Facility
o Purpose Of The Macro Facility
o Macro Program Flow
o How To Create Macros
o Session Compiled Macros
o Autocall Macros
o Macro Variables
o Introduction To Macro Variables
o Automatic Macro Variables
o User-Defined Macro Variables
o Delimiting Macro Variable Names
o Deleting Macro Variables
o Macro Functions
o Macro Mask Functions
o Macro Definitions
o Defining And Calling A Macro
o Macro Parameters
o Macro Storage
o Data Step And Sql Interfaces-
o Creating Macro Variables In The Data Step
o Indirect References To Macro Variables
o Retrieving Macro Variables In The Data Step
o Creating Macro Variables In Sql
o Macro Programs
o Conditional Processing
o Parameter Validation
o Iterative Processing
o Global And Local Symbol Tables
o Framework For Developing Macro Applications
o Debugging And Troubleshooting
o Generating Custom Messages
o Creating Efficient Macros
o Review Of Macros
o Cpu Time
o Data Storage
o I/0
o Memory
o Programming Time
o Data Step Debugging
o Macro Debugging
o Debugging Options
o Syntax Errors
o Logical Errors
o Semantic Errors
o 9.1
o 9.1.2
o 9.1.3
o 9.2
o 9.3
o 9.4
o Getting Started with SAS in UNIX Environments
o Starting SAS Sessions in UNIX Environments
o Running SAS in a Foreground or Background Process
o Selecting a Method of Running SAS in UNIX Environments
o SAS Windowing Environment in UNIX Environments
o Interactive Line Mode in UNIX Environments
o Batch Mode in UNIX Environments
o Running SAS on a Remote Host in UNIX Environments
o X Command Line Options
o Executing Operating System Commands from Your SAS Session
o Customizing Your SAS Registry Files
o Customizing Your SAS Session by Using System Options
o Customizing Your SAS Session by Using Configuration and Autoexec Files
o Defining Environment Variables in UNIX Environments
o Determining the Completion Status of a SAS Job in UNIX Environments
o Exiting or Interrupting Your SAS Session in UNIX Environments
o Ending a Process That Is Running as a SAS Server
o Ending a SAS Process on a Relational Database
o Base Sas Certification
o Adv Sas Certification
o Getting Started with SAS Enterprise Guide
o Creating Reports
o Working with Data in the Query Builder
o Joining Two Data Files Together
o SAS Enterprise Guide Basics
o Bringing Data into a Project
o Working with Tasks
o Producing Complex Reports in Summary Tables
o Modifying Data Using the Query Builder
o Sorting and Filtering Data
o Combining Data Tables
o Basic Statistical Analysis
o BFSI (Banking, Finance, Insurance/Healthcare) – 30HOURS
o CLINICAL – 60HOURS (Along with CDISC)
o Operating System ( Windows, Unix & Linux ) – 30 Hours
o Database (Oracle Sql) – 30 HOURS
o MS-Excel (Basics, Adv, Macros, Vba, Analytics & MIS) – 60 Hours
o Statistics – 30 Hours
o Communication, Personality Development, Aptitude & Reasoning – 30 Hours
o B.Sc (B.Z.C, Chemistry, Biotech, Microbiology, Bio chemistry, Nutrition, Statistics)
o M.Sc (Clinical research, Biotech, Microbiology, Zoology, Botony, Chemistry, Statistics)
o PHARMACY (B.Pharmacy, D.Pharmacy, M.Pharmacy),
o Medical (BDS, BHMS, BAMS, MBBS),
o B.E/B.Tech (Biotech, Bio Informatics, Computer Science).
o B.Sc, B.A, B.COM, CA, BBA, BBM, BCA, B.Tech, B.E
o M.Sc, M.A, M.COM, MBA, MCA, PGDM, M.Tech
Between Apollo Clinic & Nagarjuna High School,
Sanjeevareddy Nagar, Hyderabad- 500038, Telangana.
- Mobile: 9542195422
- Whatsapp: 9542195422
- Phone: 040-48524449
- Mail id: stansys.sas@gmail.com
- Face Book: stansyssoftwresolutions@gmail.com
- Website: stansys.in
- Address: #7-1-621/113(67/3RT), Near S.R Nagar Community Hall,
FACULTY NAME: SRINIVAS
8+ YEARS OF WORK AND TEACHING IN SASR
EDUCATION: MS
SAS CERTIFIED CANDIDATE: BASE, ADVANCE AND CLINICAL SAS
