SAS SAS PROC SQL Features

SAS PROC SQL Features

Catalog: SAS
Short name: PROC SQL Features
Course start date: 2024-07-02
Paystack

Description

SAS which stands for Statistical Analysis System is a software developed by the SAS Institute a private company based out of Cary, North Carolina, USA. Its primary objective is to be able to process large chunks of data and analyse it to aid in the process of intelligent decision making. SAS has been widely accepted in the world and it accounts for almost 70% of the data processing market place. SAS/Graph® Training is an essential course, as it is a prerequisite for many courses in the statistical analysis domain.


Through this training you shall be able to Create SAS data sets and run PROC SQL programs effectively.


The training will include the following;


1) Introduction

2) Difference between Data & Proc Step

3) Procedures Using Proc SQL


Creation

Reading

Updation

Deletion

Sorting

Summarizing & grouping

Querying multiple tables

4) SQL JOINCROSS JOIN

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

5) Subqueries

6) Set Operators

Course Duration:-1h 53m

Sections

General
0 activities

Introduction to PROC SQL
Different Procedure for Proc SQL
Rename Variables in Proc sql
Labeling and Formatting in sas
Usage of Filtering option in sas
multiple observation in proc sql
Use of keep option
sql joins
sql joins Continues
Set operators in sql
Conclusion
Course Certificate

Secure Video
11
Certificate
1
Cost: 5000

Tag

Course Duration:-1h 53m