From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to PROC SQL - SAS Tutorial
From the course: SAS Essential Training: 1 Descriptive Analysis for Healthcare Research
Introduction to PROC SQL
- [Instructor] In this movie, I will introduce you to SAS's PROC SQL. SQL stands for Structured Query Language and it's pronounced "sequel" by a lot of people, like me. Some of you watching this movie might already know some flavor of the programming language SQL, but some of you may not. Before we get to PROC SQL, let's compare the original concept of SQL to SAS. Please understand that SAS is Software Optimize for Statistical Analysis, while SQL is Software Optimize for Data Management. In SAS, that data management happens in the data step and the syntax of the data step is data blah, set blah, then all your transformations, and there are a lot of different commands you can use in data step code. On the other hand, SQL has just a few main data management commands that get reused and put together to achieve any data management task. Also, SQL is highly optimized for data management, so instead of long data steps, you have smaller snippets of code that execute quickly. I apologize to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.