Enrol for free Demo!
Advance SAS Course | With SAS Certification
Reviews
sachin phate
- 2018-02-16
best in pune. thank you aspire
Juhi Gujarathi
- 2017-06-19
Aspire has provided both practical and theoretical training,staff was cooperative,faculty was highly experienced in SAS, good training i have got from ASpir
Aashay wasnik
- 2016-12-24
I did SAS course from Aspire. it was a good learning experience.
Advance SAS
- PROC SQL Basics
- Writing a PROC SQL Step
- Selecting Columns
- Specifying the Table
- Specifying Sub setting Criteria
- Ordering Rows
- Querying Multiple Tables
- Summarizing Groups of Data
- Creating Output Tables
- Viewing SELECT Statement Syntax
- Displaying All Columns
- Limiting the Number of Rows Displayed
- Eliminating Duplicate Rows from Output
- Sub setting Rows by Using Conditional Operators
- Sub setting Rows by Using Calculated Values
- Enhancing Query Output
- Summarizing and Grouping Data
- Sub setting Data by Using Sub queries
- Sub setting Data by Using No correlated Sub queries
- Sub setting Data by Using Correlated Sub queries
- Understanding Joins
- Generating a Cartesian product
- Using Inner Joins
- Using Outer Joins
- Creating an Inner Join with Outer Join-Style Syntax
- Comparing SQL Joins and DATA Step Match-Merges
- Restricting data set size by selecting variables with DROP= and KEEP=
- Using In-Line Views
- Joining Multiple Tables and Views
- Understanding Set Operations
- Using the EXCEPT Set Operator
- Using the INTERSECT Set Operator
- Using the UNION Set Operator
- Using the OUTER UNION Set Operator
- Comparing Outer Unions and Other SAS Techniques
- Understanding Methods of Creating Tables
- Creating an Empty Table by Defining Columns
- Displaying the Structure of a Table
- Creating an Empty Table That Is Like another Table
- Creating a Table from a Query Result
- Inserting Rows of Data into a Table
- Creating a Table That Has Integrity Constraints
- Handling Errors in Row Insertions
- Displaying Integrity Constraints for a Table
- Comparing methods of merging (joining) data sets
- Updating Values in Existing Table Rows
- Deleting Rows in a Table
- Altering Columns in a Table
- Dropping Tables
- Understanding Indexes
- Deciding Whether to Create an Index
- Creating an Index
- Displaying Index Specifications
- Managing Index Usage
- Dropping Indexes
- Creating and Using PROC SQL Views
- Displaying the Definition for a PROC SQL View
- Managing PROC SQL Views
- Updating PROC SQL Views
- Dropping PROC SQL Views
- Specifying SQL Options
- Controlling Execution
- Controlling Output
- Testing and Evaluating Performance Resetting Options
- Using Dictionary Tables
- Basic Concepts
- Using Automatic Macro Variables
- Using User-Defined Macro Variables
- Processing Macro Variables
- Displaying Macro Variable Values in the SAS Log
- Using Macro Functions to Mask Special Characters
- Using Macro Functions to Manipulate Character Strings
- Using SAS Functions with Macro Variables
- Combining Macro Variable References with Text
- Creating a Macro Variable during DATA Step Execution
- Creating Multiple Macro Variables during DATA Step Execution
- Referencing Macro Variables Indirectly
- Obtaining Macro Variable Values during DATA Step Execution
- Creating Macro Variables during PROC SQL Step Execution
- Working with PROC SQL Views
- Using Macro Variables in SCL Programs
- Basic Concepts
- Developing and Debugging Macros
- Using Macro Parameters
- Understanding Symbol Tables
- Processing Statements Conditionally
- Processing Statements Iteratively
- Using Arithmetic and Logical Express
- Understanding Session-Compiled Macros
- Storing Macro Definitions in External Files
- Storing Macro Definitions in Catalog SOURCE Entries
- Using the Auto call Facility
- Using Stored Compiled Macros
Benefits of Aspire Techsoft training
ASAP methodology
24 HOURS LAB
MATERIAL SOFT COPY& HARD COPY
100% PLACEMENT ASSISTANCE
RESUME PREPARATION
SOFT SKILLS& HR TIPS
sachin phate
- 2018-02-16
best in pune. thank you aspire
Juhi Gujarathi
- 2017-06-19
Aspire has provided both practical and theoretical training,staff was cooperative,faculty was highly experienced in SAS, good training i have got from ASpir
Aashay wasnik
- 2016-12-24
I did SAS course from Aspire. it was a good learning experience.
Your Ratings
Courses We Offer
ADD NEW SKILLS TO YOUR PROFILE
SAS Course
SAS is a software suite developed by SAS Institute for advanced analytics, business intelligence, data management, and predictive analytics.
- Duration
- 2 months
SAP Course
SAP ERP is enterprise resource planning software developed by the German company SAP SE. SAP ERP incorporates the key business functions of an organization.
- Duration
- 2 months
Hadoop Course
Apache Hadoop is an open-source software framework written in Java for distributed storage and distributed processing of very large data sets on computer clusters built from commodity hardware.
- Duration
- 2 months
Java Course
A high-level programming language developed by Sun Microsystem. Java is an OOP language similar to C++, but simplified to eliminate language features that cause common programming errors.
- Duration
- 2 months
Software Testing
Software testing is the process of evaluation a software item to detect differences between given input and expected output. Also to assess the feature of a software item. Testing assesses the quality of the product.
- Duration
- 2 months
Datawarehousing Course
A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data.
- Duration
- 2 months
PHP Course
PHP is used to create dynamic web pages , generated from the information accessed using MySQL database. Since PHP's syntax is similar to that of C and Perl, it is easy with basic programming skill.
- Duration
- 2 months
Diploma of WEB Designing
Web technology acts as a bridge between Web Servers and Web Clients. The technology consists of markup languages, programming interfaces and databases. it is reach many people all over the world.
- Duration
- 2 months
