Analytics Sequar
Legal Status of Firm
Limited Company (Ltd./Pvt.Ltd.)
Indiamart Member Since
Jan 2014
Advance SAS Training
Advance SAS Training programme has been designed for the candidates who are already well versed and proficient with BASE SAS Programming . It requires lots of logical and analytical approach to write a programme. Candidate requires to go through some of the SQL and database knowledge also as it requires to connect and fetch the database from different sources and database. SAS/SQL
• Introduction to Proc SQL
- • Creating tables
* • Inserting data into tables
* • Alter the tables & etc…
* • Modifying the tables
Retrieving Data from Multiple tables
* • Natural Join
Product Details
Company Details
Product Description
Advance SAS Training programme has been designed for the candidates who are already well versed and proficient with BASE SAS Programming . It requires lots of logical and analytical approach to write a programme. Candidate requires to go through some of the SQL and database knowledge also as it requires to connect and fetch the database from different sources and database.
SAS/SQL- • Introduction to Proc SQL
- • Creating tables
- • Inserting data into tables
- • Alter the tables & etc…
- • Modifying the tables
- • Natural Join
- • Inner Join
- • Outer Join (Right, Left, Full)
- • Introduction to Graphs
- • Types of Graphs
- • Chart
- • Plot
- • illustration of axis options
- • Illustration of symbol options
- • Illustration of footnote, note, title
- • Introduction to Statistics
- • Producing Descriptive Statistics
- • Computing Statistics for Numeric Variables
- • Proc Correlation
- • Proc Regression
- • Proc Means
- • Proc Summary
- • Proc Univariate
- • Proc Freq
- • Proc Annova
- • Concatenating
- • Merging
- • One-to-one merging
- • One-to-many merging
- • Many-to-one merging
- • Many-to-many merging
- • Matching merging
- • Updating
- • Writing SAS programs that work
- • Fixing programs that Don't work
- • Searching for the Missing Semicolon
- • Program data vector(PDV)
- • Compilation Phase
- • Execution Phase
- • Creating a File shortcut with the File Shortcut Assignment Window
- • Making a file shortcut to a program
- • Deleting a file shortcut
- • Browsing and submitting a file shortcut for a SAS program
- • Viewing file shortcut properties
- • Fundamentals of the ODS
- • ODS and the Data step
- • Syntax for ODS Enhanced features in a Data step
- • Introduction to ODS language Statements
- • Introduction to Macro Language Elements
- • Introduction to Macro Variables
- • Automatic Macro Variables
- • User defined Macro Variables
- • Introduction to Macro Processing
- • Macro Statements
- • Macro Functions
- • Integration of Database
- • Connecting to a DBMS Using the SQL Procedure Pass-Through Facility
- • Connecting to a excel Using the SQL Procedure Pass-Through Facility
- • Connecting to a access Using the SQL Procedure Pass-Through Facility
- • Connecting to a DBMS Using the Libname Statement
- • Define SAS/Access Software
- • Identify the types of data repositories that SAS/Access can access
- • The interface engine
- • The SAS/Access Libname Statement
- • The SQL Procedure Pass-Through Facility
- • The Access Procedure
- • Requirements to Connect to a Database
- • SAS/Access Libname engines
- • Data sources
About the Company
We are a group of qualified professionals providing quality training in the field of Statistical Analysis & Data Management using Business Intelligence tools(SAS,SQL & SPSS). We have significant experience of working with multinational companies and international clients.
Seller Contact Details
D- 60, 2 Minute Walking Distance From Laxmi Nagar Metro Station, Laxmi Nagar, Laxmi Nagar New Delhi - 110001, India
Get Directions