enquiry@mymiit.com 9900996527 | 9902524178
Home > Courses > SAS

SAS

Image

SAS(Statistical Analysis Software or System) is one of the BI(Business intelligence tool), It is an integrated system of software products provided by SAS Institute.SAS  was used for data management, predictive analysis, data visualization(i.e reporting).SAS is platform independent we can run SAS on any operating system,  with the help of the SAS we can perform various operations like Data management, Quality Improvement, Application Development, Data Extraction Data Transformation and Data Modification.SAS is used by industries worldwide that rely on it for data access, transformations, and reporting. Addressing data questions with reliable Base SAS code, while supporting new business requirements with one tool, enables more effective use of your existing hardware resources and staff skills.Base SAS software optimizes all hardware Resources and scales across different infrastructure environments. Numerous components are available for additional functionality, including direct access to standardized data sources and advanced statistical analysis.

 

SAS Objectives

we learn about SAS-Statistical Analysis Software or System, The programmer can perform: Data entry, data retrieval, data management, and mining report writing and graphics, statistical and mathematical analysis, business planning, forecasting, and decision support, quality improvement, applications development, data warehousing (extract, transform, load), platform independent. Read, format and analyze any data. From small data issues to large and complex data problems, programmers can quickly read, format and report on data in any format. Make programming fast and easy. Base SAS significantly reduces the amount of code required to deliver information, increasing your programmers’ productivity. Extend the ease of SAS to more users.

Prerequisites

This SAS course can be taken by any graduate who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System and it is easy to learn whoever even don’t have knowledge on programming language .

SAS Syllabus

Introduction to Base SAS
  1. SAS Windows Environment  
  2. Types Of Blocks 
  3. Types Of Reports 
  4. Data Types 
Types of Input Methods
  1. Named Input Method 
  2. Column Input Method 
  3. Format Input Method 
  4. Absolute Input Method
  5. Mixed Input Method
  6. Advanced List Input Method
Infile Options
  1. Dlm 
  2. Dsd (Data separated delimiter or data sensitive delimiter) 
  3. Flow Over 
  4. Stop Over 
  5. Miss Over 
  6. Trunc Over 
  7. First Obs 
  8. Obs 

 

Nonstandard Data
  1. Date 
  2. Time 
  3. Date And Time 
  4. Informat Technique 
  5. Format technique
Types Of Transformations
  1. Sorting Transformation 
  2. Splitter Transformation 
  3. Append Transformation 
  4. Update Transformation 
  5. Modify Transformation 
User Defined Libraries And SAS Access
  1. Temporary Libraries 
  2. Permanent Libraries 
  3. Import Procedure 
  4. Export Procedure
Options
  1. Global Options 
  2. Dataset Options 
  3. Statement Options
Operators
  1. Arithmetic Operators 
  2. Comparison Operators 
  3. Logical Operators
Conditionl Statements And Loops
  1. If Statement 
  2. Where Statement
  3. Do While 
  4. Do Until
  5. Do loop
Functions
  1. Data Step Functions 
  2. Arithmetic Functions 
  3. Aggregate Functions 
  4. String Functions 
  5. Date And Time Functions 
Adding Process
  1. Appending Process 
  2. Concatenation Process 
  3. Interleaving Process
Merge Process
  1. One to one merge without relation 
  2. One to one merge with relation 
  3. One to many merge with relation 
  4. Many to one merge with relation 
  5. Many to many merge with relation
Introduction To Base SAS Using SQL
  1. Creates Table 
  2. Insert The Data 
  3. Update The Data 
  4. Modify The Table 
  5. Delete The Data 
  6. Drop The Table 
  7. Create View 
  8. Drop View 
  9. Assign Constraint 
  10. Delete the Constraint 
SQL Concepts
  1. DDL 
  2. DML 
  3. DCL
Data Conversions
  1. Numeric to Character
  2. Character to Character 
  3. Character to Numeric 
  4. Numeric to Numeric 
Sql Operators

Union  
Intersect 
Except 

Joins In Sql
  1. Simple Join 
  2. Inner Join 
  3. Outer Join 
  4. Natural Join 
  5. Self Join 
  6. Cross Join  
Functions In Sql
  1. Sql Functions 
  2. Arithmetic Functions 
  3. Aggregate Functions 
  4. String  Functions 
  5. Date And Time Functions  
Constraints
  1. Types Of Constraints 
  2. Unique  
  3. Not Null 
  4. Check 
  5. Primary Key 
  6. Foreign key 

  

Procedures (Base SAS)
  1. Format Procedure 
  2. Datasets Procedure 
  3. Transpose Procedure 
  4. Rank Procedure 
  5. Frequency Procedure 
  6. Means Procedure 
  7. Report Procedure 

  

Graphs (Base SAS)
  1. Charts  
  2. Plots 

  

Introduction To Base SAS Using Macros
  1. System Defined Macro Variables 
  2. User Defined Macro Variables 
  3. Work With Macro Variables 
  4. Macro Quoting Functions 
  5. Macro Options 
  6. Macro Expressions 
  7. Macro Interface functions.

  

Macro Quoting Functions and Macro Functions
  1. % str
  2. % nrstr
  3. %bquote
  4. %nrbquo
  5. %Length
  6. %Upcase
  7. %Lowcase
  8. %Scan function
  9. %Substr function

  

Macro Options
  1. Merror
  2. Serror
  3. Mprint
  4. Mprintnest
Macro Expressions and Interface Functions
  1. Arithmetic expressions
  2. Logical expressions
  3. Text expressions
  4. Data Step Interface Functions
  5. Macro Interface Functions
No faculty for current course

Post an Enquiry

Name
Email Id
Contact No
Course
Details
);
Scroll to Top