- Tutor is available to students
Introduction to Base SAS - In-house training
Enquire for in-house and bespoke options
Pairview Training
Summary
Overview
You will learn to…Import a variety of data formatsIteration and evaluation of DataClean & pre-process data in preparation for analysisPre-process unstructured data for text-miningAbout this course
This instructor-led course provides delegates with an overview of data mining as well as the fundamentals of using some of the most in-demand tools (e.g. SPSS, SAS, etc.) for advanced predictive analytics. The principles and practice of data mining are illustrated throughout the training using the CRISP-DM methodology and follows the stages of a typical data mining project. Each stage of the course will take you through each step of a typical data mining project from reading data to data exploration, data transformation, modelling, and effective interpretation of results. The course equips delegates with the basics of how to read, explore, and manipulate data with one of these concerned tools.
4 Benefits of booking this course with usBenefit 1Intensive training in some of the most commonly used platforms by data scientists, statisticians, analysts who need to make sense of data (e.g. SPSS, SAS, R, etc.) .Benefit 2Hands-on, practical experience of applying the skills in different business scenarios.Benefit 3Numerous career opportunities with average salaries to £60,000 – £80,000, provided by attentive experienced industry practitioners.
Description
- Module 1: Introduction to SAS Programmes
SAS System
SAS Syntax
SAS Programming Process
Rules within SAS programming - Module 2: Introduction to SAS Programmes
SAS Libraries:
Permanent SAS Files
Temporary SAS Files
FILENAME & LIBNAME Statements - Module 3: Accessing External & Reading Raw Data files into SAS using DATA STEP
Types of data SAS can read
Reading raw data file into SAS not in standard format
Reading external data into SAS
Reading Spreadsheet
Reading text file
Getting external data into SAS (Infile, Input, Proc) - Module 4: How to Import Data from SQL SERVER into SAS
How to map/link SAS to SQL server (2008,2012,2014) etc
How to import data into SAS from SQL server
Reading Database Table file
How to convert the SQL server data into a SAS File - Module 5: Formatting Data Values
Variables Attributes
Understanding Numeric Expressions and Assignment Statements
Missing Values
Character Variables
Numeric Variables
Date variables
Currency Variables - Module 6: Modifying and Combining SAS Data Sets
Modifying a Dataset using the SET statement
Using Data statement to Stack multiple data sets
Using Data statement to Merge multiple data set - Module 7: Manipulating and Transforming Data
Informants and Formats
Data Set Option (Drop, Keep, Firstobs, Obs)
PROC STEP - Module 8: Producing Detailed and Summary Reports
Using PROC means
PROC sort
PROC Freq
PROC Contents
PROC Summary
PROC Tabulate
PROC Rank
PROC Print
PROC Report
PROC Univariate etc…
Module 9: Using Basic Graphs and Statistical Procedure
Producing Statistics with PROC MEANS
Producing Statistics with PROC MEANS
Creating Bar Charts
Creating Histograms
Creating Scatter Plots
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.