Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

SQL For The SAS Programmer/Analyst

Ermin Dedic

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (1h 23m)
    • Introduction to the Course

      2:00
    • SQL Syntax

      8:38
    • WHERE Clause

      6:13
    • Select Statement and Columns

      5:22
    • CASE Logic

      3:22
    • Summary Functions

      3:26
    • Inner Join

      8:56
    • Joining Three Tables

      2:29
    • Left/Right Join

      4:11
    • Full Join (Coalesce Function)

      6:25
    • Creating A Table

      4:30
    • Altering Columns

      5:33
    • Inserting Rows With a Query And Set Statement

      7:08
    • Comparing Tables

      2:33
    • Finding Duplicate Records

      3:10
    • Customize The Way You Sort

      3:46
    • Updating A Table Under Certain Conditions

      5:04

About This Class

26b213b1

The goal of the course is to teach you SQL as it relates to the SAS programming language. I am using a software called WPS, which allows you to program with SAS.

We will cover PROC SQL. SQL is especially utilized for extracting/selecting data from database tables, and also manipulating that data.

Whether you are looking for a new job, looking to move up at your current company, or looking to get into a respected well-paying career after school..this course is for you!

The course has four main sections. The first section is Base Knowledge. You will learn about SQL syntax, including specifics on the Select and Where clause. You will also learn about Case Logic and Summary Functions. The second section is about Joining tables. I show you how to use the inner join, join three tables, left/right join, and full join. The third section is Working with Tables. I show you how to create a table, Alter columns (add, modify, delete) and how to Insert Rows in different ways. The final section is on Practical/Useful applications of SQL. For example, you'll learn how to Compare tables, find duplicate observations/get rid of them, how to sort the way you want to, and how to update a table under certain conditions.

1

Student

--

Projects

0

Reviews (0)

I'm a Graduate Student (Educational Psychology) in Canada, and I'm passionate about statistics and data. I've developed an expertise in SAS Base programming and beginner/intermediate statistics largely through my schooling and partly self-study.

In my Graduate work, I focus on and study the assessment of intellectual, cognitive, academic, and social/behavioral/emotional functioning.

See full profile