SAS Programming Training in Bangalore
5/5
Reviews 4.7 ratings out of 5 from 796 candidates for class room and online SAS training in Bengaluru
For course fees, duration and batches call 9343565658 / 9972522848
SAS Course Contents
This SAS training class covers SAS Base and Advanced Modules.
- SAS/BASE
- SAS/GRAPHS
- SAS/ACCESS
- SAS/ODS
Introduction
- How to Use this Document
- Little Bit History About SAS
- What is SAS?
- Launching SAS
- Windows in SAS for Windows
- Menus in SAS
- Working within SAS
- Using the Cursor
- Using Icons
- Using the Enhanced Editor
- Writing a SAS Program: the DATA Step
- Introduction to SAS®
- SAS® Software Versions
- Using SAS for Windows
- System Requirement
- Installing SAS® 9.2 and 9.4 for MS Windows, Unix, Linux
Accessing Data
- Introduction
- LIST,COLUMN,FORMTTED AND NAMED input to read raw data
- Using Various Components of an INPUT Statement
- Importing raw data from Excel files, Text files, CSV files, ODBC and Access files Etc… using the import procedure, data step and Import wizard
- Set statement to read and combine SAS data sets
- Using the merge statement to combine SAS data sets
- Appending multiple SAS data sets
- Explaining about User created functions and system defined functions
- Explaining about Types of functions such as Character, Numeric, statistical or mathematical and date or time functions
- Statements and types, global statements and local statements
- Using Do loops
Creating Data Structures
- Introduction
- Creating temporary and permanent SAS data sets
- Preparing temporary libraries and permanents libraries
- Applying conditional assignments and conditional subsets
- Using data step statements to export(or write) data to a file
- Exporting data to excel and access using the export procedure
- Understanding how the data step is compiled and executed
- Using data dynamic exchange(DDE) to import excel data
- Exporting SAS files to Excel Using DDE.
Managing Data
- Introduction
- Modifying variable attributes in the data set
- Assignment statement to accumulate variable values across executions of the data step
- Using SAS functions to manipulate character data, numeric data, and SAS date and time values
- Creating User defined in formats and Formats
- Changing SAS default setting using system options, data step options and statement options
- Use system defined and user defined formats
- Use system defined and user defined in formats
- Use SAS functions to convert character data to numeric data and vice versa
- Processing data using SAS arrays
- Sorting observations in a SAS data set
- Using SAS utility procedure to investigate SAS data libraries
Generating Reports
- Introduction
- Generating reports using the PRINT,MEANS,FREQ,TABULATE,REPORT etc…procedures
- Generating HTML, RTF, PDF, EXCEL, TEXT, CSV, and PDF reports using ODS statements
- Enhancing reports with options and statements
Handling Errors
- Introduction…
- Recognizing and correcting syntax and non-syntax errors
- Examining and resolving data errors
- Program debugging techniques
SAS Graphs
- Introduction
- Drawing graphs by programming and menu driven
- Using colors and images
- Language Elements
- Using Engines with SAS/GRAPH Software
- Running SAS/GRAPH Programs
- Procedure Output and the Graphics Output Area
- Printing Graphics Output
- Storing Graphics Output in SAS Catalogs
- Modifying SAS/GRAPH Output
- Transporting and Converting Graphics Output
- Using SAS/GRAPH Colors and Images
- Specifying Colors in SAS/GRAPH Programs
- Specifying Images in SAS/GRAPH Programs
- GChart
- GPlot
- Vbar
- Hbar
- Pie chart
- Histogram
- Box plot
- Probability plot
- Scatter plot (two dimensional and three dimensional)
SAS ODS
- Creating HTML outputs Using ODS
- Creating HTML outputs with a Table of Contents
- Selecting ODS tables for Display
- Excluding ODS tables for Display
- Exporting SAS outputs
- Preparing PDF,RTF,CSV,XML,HTML files using ODS
- Creating an output data set from an ODS tables
- Generating outputs in colors
- Creating an output data set from sub setting the data
- Determining the Names of ODS Tables
- Using the TEMPLATE Procedure to Customize Output
- Creating HTML Output, Linked Within a Single Analysis
- Creating HTML Output, Linked Between Analyses
Basic Statistics
Descriptive Statistics
- Introduction statistics
- Measurement Of scales
- Data Presentation
- Data Characteristics:
- Measures of Central tendency
- Measures of Dispersion
- Shape of Distribution(Normal distribution)
- Kurtosis and Skewness
- Descriptive Summary Statistics
Hypothesis Testing
- T-Test : Testing differences between two means
- Random assignment of subjects
- Two independent samples : Distribution free tests
- One-tailed vs. two tailed tests
- Paired t-tests(related samples)
Hypothesis Testing (More than two groups)
- One-way analysis of variance
- Analysis of variance : two independent variables
- Interpreting significant interactions
- Unbalanced designs: Proc GLM
Correlation Analysis
- Introduction
- Positive correlation
- Negative correlation
- Multiple correlation
- Linear and non-linear correlation
Regression Analysis
- Introduction
- Simple regression
- Multiple regression analysis
- Interpretation about statistics such as (R square, adjusted R square, et
SAS Advance Training Overview
This SAS training class covers SAS Base and Advanced Modules.
- SAS/Arrays
- SAS/SQL
- SAS/MACROS
SAS Arrays
- Introduction to Arrays
- Writing Efficient Programming with arrays
- Single and Double Dimensional array
- Creating Character Numeric and Temporary variables
SAS Macros
- Introduction Macro Processing
- Creating and Reusing macro variable
- Creating Positional and Keyword Parameters
- Working with system defined macro variables and user defined macro variables
- Converting Global macro variables into local macro variables vice versa
- Functions and routines, its different
- Introduction to Macro Processing
- Defining and Calling Macros
- How the Macro Processor Compiles a Macro Definition
- How the Macro Processor Executes a Compiled Macro
- System defined macro options
- Executing a macro program
- Passing values to a macro program through macro parameters
- Using SAS Base functions and Proc SQL statements in SAS macros
- Using conditional statements in macros
- Manipulating SAS Base programs to macros
- Macro quoting functions
- Macro facility error messages and debugging
- Using the stored compiled macro facility for saving macro
- Arithmetic and logical expressions
- Reading external files using macros
- Writing SAS files using macros
- Step wise method for writing macro programs
- Saving Macros in an Auto call Library
- Saving Macros Using the Stored Compiled Macro Facility
SAS SQL
- Introduction to the SQL Procedure
- What Is SQL?
- What Is the SQL Procedure?
- Comparing PROC SQL with the SAS DATA Step
- Creating data sets using SQL procedure
- Overview of the query window
- Retrieving Data from a Single Table
- Retrieving Data from Multiple Tables
- Creating and Updating Tables and Views
- Inserting Rows into Tables
- Updating Data Values in a Table
- Deleting Rows and Tables
- Altering Columns
- Creating an Index
- Using SQL Procedure Tables in SAS Software
- Creating and Using Integrity Constraints in a Table
- Using PROC SQL Options to Create and Debug Queries
- Improving Query Performance HYPERLINK “a001385596.htm”Accessing SAS System Information Using DICTIONARY Tables
- Using the Output Delivery System (ODS) with PROC SQL
- Performing simple queries
- Combine tables using inner join, outer join(outer left join, outer right join, outer full join)
- Summarizing groups of data
- Sub setting groups of data
- Handling missing values
- Handling embedded blanks in column names
- Using SAS base functions in SQL
- Building calculated columns
- Reading oracle data tables into SAS by pass through facility
- Connecting to Oracle, DB2, SYBASE, EXCEL, ACCESS, ODBC, OSIRIS, REMOTE, SPDE, SPSS, TERADATA, XML, AND XPORT engines etc…. to import data sets
- Explaining about conditional statements
- Modifying variables using Base Options in SQL
- Creating macro variables in SQL
VIJAYANAGAR
# 2948 E, 1st floor, Maruthi Arcade, Service Road, Above Karnataka Bank, Opp Maruthi Mandir, Vijayanagar, Bengaluru,
Karnataka - 560040
9343565658
BTM LAYOUT
# 7, 2nd floor, BTM 2nd stage,
Above James bond dry cleaner, near water tank bus stop,
Karnataka - 560076
9972522848