Udemy - Business Analytics Program Using SAS 100% off

COURSE DESCRIPTION

Introduction

SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it. SAS provides a graphical point-and-click user interface for non-technical users and more advanced options through the SAS Programming Language. SAS programs have a DATA step, which retrieves and manipulates data, usually creating a SAS data set, and a PROC step, which analyzes the data

·Objective of the course
·Overview of SAS
·Introduction to SAS Program
·SAS programming and syntax rules
·Fundamental concepts of SAS

DATA Collection

(Creation of analysis datasets from raw datasets is the first step in analytics. In this assignment you will perform the role of a developer of analysis datasets. You will be provided with the raw datasets based on which the analysis datasets will need to be created. You will be required to create analysis datasets by writing code in SAS® based on the specifications provided to you.)

·Accessing data from SAS system
·Accessing data from CSV file(Delimited files)
·Accessing data from Excel
·Accessing data from other databases

DATA Validation and cleaning

Validating data helps to identify suspicious and invalid cases, variables, and data values in the active data set. Owing to the criticality of data, the accuracy of analysis datasets is validated by independent validators who write independent code and compare their results with the analysis datasets. In this assignment, you will perform the role of an independent validator for analysis datasets. You will be provided with the analysis datasets to be validated and the raw datasets from which the analysis datasets were created. You will be required to perform the validation of these analysis datasets by writing independent code in SAS®.

·Introduction to validation and cleaning techniques
·Handling data errors
·Validating with Procedures(Proc print , Proc Freq, Proc means and Univariate)
·Cleaning invalid data

DATA Manipulation

·Creating derived variables
·Creating variables conditionally
·Subsetting variables and observations
·Summarizing the data
·Do loops and SAS arrays
·Appending , concatenating and merging datasets

Data Transformations

·Character variable functions
·Numeric variable functions
·Converting variable type
·Creating Pivot table

Report Generation

Broadly Report Generationis a process whose purpose it is to take data from a source such as a database, XML stream or a spreadsheet and use it to produce a document in a format which satisfies a particular human readership.

For interpretation of data and making statistical and clinical inferences, summary reports and listings need to be created from the analysis datasets. In this assignment, you will perform the role of the developer of a report. You will be provided with the analysis datasets, specifications and mock shells. You will be required to generate the reports in Rich Text Format (RTF) by writing independent code in SAS®.

• using global statements
• adding labels and formats
• creating user-defined formats
• subsetting and grouping observations
• directing output to external files

·Producing reports using Proc Freq, Means and Tabulate procedure

Report Validation

As in case of analysis datasets, in case of reports, independent validation is performed to ensure accuracy of the report output. In this assignment you will perform the role of an independent validator. You will be provided with the Rich Text Format (RTF) reports to be validated and the analysis datasets from which the RTF reports were created. You will be required to perform the validation of these RTF reports by writing independent code in SAS®.

Validating reports using Proc Freq, Means and Tabulate procedure

Udemy Coupon Code: https://www.udemy.com/business-analytics-program-using-sas-sas/?couponCode=TINTIN