Register for Demo Class

For Online Training

We are the No1 Leading Provider for Online Training

Video Reviews

Reviews

Besant Technologies
5 Star Rating: Recommended 4.9 out of 5 based on 3802 reviews.

Review Source:









Bangalore Support

E : traininginblr[at]gmail.com

BTM Layout :
+(91) 762 494 1772
+(91) 762 494 1774


Marathahalli :
+(91) 910 812 6341
+(91) 910 812 6342


Rajaji Nagar :
+(91) 734 915 0004
+(91) 734 916 0004
+(91) 755 011 2282 | +(91) 755 023 5062|traininginblr[at]gmail.com

DataScience with SAS Training in BTM Layout

Home/DataScience with SAS Training in BTM Layout
DataScience with SAS Training in BTM Layout 2018-04-25T16:58:52+00:00

Session : 1 – Overview of SAS

  • Introduction and History of SAS
  • Significance of SAS software solutions in various industries
  • Demonstrate SAS Capabilities
  • Job Profile / career opportunities with SAS worldwide?

Session : 2 – Base SAS Fundamentals

  • Explore SAS Windowing Environment
  • SAS Tasks
  • Working with SAS Syntax
  • Create and submit a SAS sample program

Session : 3 – Data Access & Data Transformation

  • Accessing SAS Data libraries
  • Getting familiar with SAS Data set

Session : 4 – Reading SAS data set

  • Introduction to reading data
  • Examine structure of SAS data set
  • Understanding of SAS works

Session : 5 – Reading Excel worksheets

  • Using Excel data as input
  • Create as sample program to import and export excel sheets

Session : 6 – Reading Raw data from External File

  • Introduction to raw data
  • Reading delimited raw data file (List Input)
  • Using standard delimited data as input
  • Using nonstandard delimited data as input
  • Reading raw data aligned to columns (Fixed or column input)
  • Reading raw data with special instructions (Formatted input)

Session : 7 – Writing to an External file

  • Write data values from SAS data set to an external file

Session : 8 – Data transformations (Data step processing)

  • Create multiple output datasets from single SAS dataset
  • Writing observations to one or more SAS datasets
  • Controlling which observations and variables to be written to output data

Session : 9 – Creating subset of observations using

  • Where condition
  • Conditional processing using: IF statements

Session : 10 – Processing Data Iteratively

  • Iterative DO loop processing with END statement
  • DO WHILE & DO UNTIL Statement
  • SAS Array statement

Session : 11 – Summarizing data

  • Creating and Accumulating total variable (Retain)
  • Using Assignment statement
  • Accumulating totals for a group of data (BY group)

Session : 12 – Manipulating Data

  • Sorting SAS data sets
  • Manipulating SAS data values
  • Presentation of user defined values /data/currency values using FORMAT procedure
  • SAS functions to manipulate char and num data
  • Convert data type form char-to num and num-to-char
  • SAS variables lists/ SAS variables lists range
  • Debugging SAS program
  • Accessing observations by creating index

Session : 13 – Restructuring a SAS data set

  • Rotating with the data step
  • Using the transpose procedure

Session : 14 – Combining SAS data sets

  • Concatenation
  • Interleaving
  • One to one reading
  • One to one merging (with non-matching)
  • Match merging (Merging types with IN=option)

Session : 15 – SAS Access & SAS Connect

  • Validating and cleaning data
  • Detect and correct syntax errors
  • Examining data errors

Session : 16 – Analysis & Presentation

Session : 17 – SAS/REPORTS SAS/GRAPH

Session : 18 – SAS/STATS SAS/ODS

Session : 19 – Producing detailed /Summary Reports

  • Freq Report
  • Means Report
  • Tabulate Report
  • Proc report
  • Summary report
  • Univariate report
  • Contents report
  • Print report
  • Compare proc
  • Copy proc
  • Datasets proc
  • Proc append
  • Proc delete

Session : 20 – Generating Statistical Reports using

  • Regression proc
  • Uni/Multivariate proc
  • Anova proc

Session : 21 – Generating Graphical reports using

  • Producing Bar and Pie charts (GCHART Proc)
  • Producing plots (GPLOT Proc)
  • Presenting Output Report result in:
  • PDF
  • Text files
  • Excel
  • HTML Files

Session : 22 – SAS/SQL Programming

  • Introduction and overview to SQL procedure
  • Proc SQL and Data step comparisons

Session : 23 – Basics Queries

  • Proc SQL syntax overview
  • Specifying columns/creating new columns
  • Specifying rows/subsetting on rows
  • Ordering or sorting data
  • Formatting output results
  • Presenting detailed data
  • Presenting summarized data

Session : 24 – Sub Queries

  • Non correlated sub queries
  • Correlated sub queries

Session : 25 – SQL Joins (Combining SAS data sets using SQL Joins)

  • Introduction to SQL joins
  • Types of joins with examples
  • Simple to complex joins
  • Choosing between data step merges and SQL joins

Session : 26 – SET Operators

  • Introduction to set operations
  • Except/Intersect/Union/Outer union operator

Session : 27 – Additional SQL Procedures features

  • Creating views with SQL procedure
  • Dictionary tables and views
  • Interfacing Proc SQL with the macro programming language
  • Creating and maintaining indexes
  • SQL Pass-Through facility

Session : 28 – SAS Macro Language

  • Introduction to macro facility
  • Generate SAS code using macros
  • Macro compilation
  • Creating macro variables
  • Scope or macro variables
  • Global/Local Macro variables
  • User defined /Automatic Macro variables
  • Macro variables references
  • Combing macro variables references with text
  • Macro functions
  • Quoting (Masking)
  • Creating macro variables in Data step (Call SYMPUT Routine)
  • Obtaining variable value during macro execution (SYMGET function)
  • Creating macro variables during PROC SQL execution (INTO Clause)
  • Creating a delimited list of values
  • Macro parameters
  • Strong Macro using Autocall Features
  • Permanently storing and using stored compiled macro program
  • SAS Macro debugging options to track problems

Session : 29 – Basics Statistics

  • Standard deviation
  • Correlation Coefficients
  • Outliers
  • Linear regressions
  • Clustering
  • Chi Square

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya

Quick Enquiry