DataScience with SAS Training

DataScience with SAS Training

DataScience with SAS Training

Learn how to use DataScience with SAS from beginner level to advanced techniques which is taught by experienced working professionals. With our DataScience with SAS Training in Pune, Mumbai, and Thane you’ll learn concepts in expert level with practical manner.

Batch Schedule for Data Science with SAS Training

Goals Info Cloud Technologies provides flexible timings to all our students. Here are the Data Science Training Classes Classes in Pune, Mumbai and Thane Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

11-07-2019 Starts Coming Thursday (Monday – Friday)08:00 AM (IST)Course Fees

15-07-2019 Starts Coming Monday (Monday – Friday)08:00 AM (IST)Course Fees

13-07-2019 Starts Coming Saturday (Saturday – Sunday)11:00 AM (IST)Course Fees

13-07-2019 Starts Coming Saturday (Saturday – Sunday)10:00 AM (IST)Course Fees

DataScience with SAS Syllabus

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?

Base SAS Fundamentals

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

Data Access & Data Transformation

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

Reading SAS data set

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

Reading Excel worksheets

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

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)

Writing to an External file

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

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

Creating subset of observations using

  • Where condition
  • Conditional processing using: IF statements

Processing Data Iteratively

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

Summarizing data

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

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
  • SAS functions to manipulate char and num data
  • SAS variables lists/ SAS variables lists range
  • Debugging SAS program
  • Accessing observations by creating index

Restructuring a SAS data set

  • Rotating with the data step
  • Using the transpose procedure

Combining SAS data sets

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

SAS Access & SAS Connect

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

SAS/REPORTS SAS/GRAPH

  • SAS/REPORTS SAS/GRAPH
  • SAS/STATS SAS/ODS

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
  • Summary report
  • Proc append
  • Proc delete

Generating Statistical Reports using

  • Regression proc
  • Uni/Multivariate proc
  • Anova proc

Generating Graphical reports using

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

SAS/SQL Programming

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

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

Sub Queries

  • Non correlated sub queries
  • Correlated sub queries

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

SET Operators

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

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

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
  • SAS Macro debugging options to track problems
  • Strong Macro using Autocall Features
  • User defined /Automatic Macro variables
  • Macro variables references
  • Macro functions
  • Quoting (Masking)
  • Macro parameters
  • Combing macro variables references with text
  • 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
  • Permanently storing and using stored compiled macro program

Basics Statistics

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

FAQ's

Call now: +91 – 99231 15877 and know the exciting offers available for you!

GoalsInfo Cloud Technologies offers 250+ IT training course in more than 20+ branches with 10+ years Experienced Expert level Trainers.

  • Fully hands-on training
  • 30+ hours course duration
  • Industry expert faculties
  • Completed 1500+ batches
  • 100% job oriented training
  • Certification guidance
  • Own course materials
  • Resume editing
  • Interview preparation
  • Affordable fees structure

GoalsInfo Cloud Technologies is the Legend in offering placement to the students. 

More than 2000+ students placed in last year. It has a dedicated placement portal which caters to the needs of the students during placements. GoalsInfo Cloud Technologies conducts development sessions including mock interviews, presentation skills to prepare students to face a challenging interview situation with ease.

  • 92% percent placement record.
  • 1000+ interviews organized.

No worries. GoalsInfo Cloud technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

GoalsInfo Cloud Technologies provides many suitable modes of training to the students like

  • Classroom training
  • One to One training
  • Fast track training
  • Customized training

You will receive GoalsInfo Cloud Technologies globally recognized course completion certification.

Yes, GoalsInfo Cloud Technologies provides group discounts for its training programs. To get more details, visit our website and contact our support team via Call, Email, Live Chat option or drop a Quick Enquiry. Depending on the group size, we offer discounts as per the terms and conditions.

Please Contact +91 9923115877 Or you can share your queries through [email protected]