SAS Programming

Name: SAS Programming
Rating: 4.2 (20 reviews)

This series of tutorials will help you understand the basic and advanced of SAS Programming on SAS Studio environment

Created byOrangeTree Global

Last updated 7/2024

English

What you'll learn

Students will have a good working knowledge on SAS Programming and can use it for their Educational as well as Business projects and assignments.
Working professionals can also benefit from this course as this course provides many tips and tricks which they can use it for their Corporate presentations.
The topics that will be covered in this course are as follows:
1. Introduction to SAS
2. The Procedure step in SAS
3. Subsetting in SAS
4. Sorting and finding the unique values in SAS
5. Table creation in SAS
6. Descriptive statistics in SAS
7. Exporting and Importing datafiles in SAS
8. Formats and Functions in SAS
9. Appending and Merging of data sets in SAS
10. Arrays and reading raw files in SAS
11. Structured Query Language (SQL) in SAS using Proc SQL
12. Data Manipulation and Joining using Proc SQL
13. SAS Macros

Course content

13 sections • 96 lectures • 10h 59m total length

What is SAS?3:18
Different SAS products, interface and how to use it?8:41
Concept of SAS Libraries7:47
Discover how SAS libraries work by contrasting permanent libraries and temporary work libraries, and learn to create a permanent library with a libname statement to store datasets across sessions.
Different steps in SAS commands4:40
Creating temporary and permanent SAS datasets13:37
Metadata structures of a SAS dataset10:30
Explore metadata structures of a SAS dataset, including variables, data types, formats and informats, and learn how currencies, dates, and lengths impact data entry and reading.
Using Rename and Label for variables in a dataset5:58

Generating list of reports using print procedure6:19
Print procedure for specific variables4:04
Learn to use the SAS print procedure to display only selected variables from a data set, such as name, height, and weight.
Supressing the OBS number and setting an ID variable4:18
Using custom labels in Print procedure3:50
Using keywords like Sum and N with print procedure3:22
Generating reports using proc contents5:24
Using Proc contents for multiple data3:42
Using additional keywords with proc contents4:20
Learn to use additional keywords with proc contents to tailor SAS dataset reports, suppressing itemized results and displaying directory information, with short and position chart options.

Creating subsets of a data using FIRST OBS and OBS technique6:14
Using keep and drop in SAS data step7:15
Introduction to basic where clause in SAS12:53
Patterns matching using where clause7:47
Explore pattern matching in SAS using the where clause to filter data by contains, starts with, ends with, and logical or for words like chocolate or charcoal, creating new datasets.
Wildcard matching and more using where clause8:41
If, then, else in SAS7:55
Select, when, otherwise in SAS6:36
Splitting of data sets in SAS6:23

Frequency distribution table in SAS5:14
Cross-tabulation in SAS8:02
Using additional keywords with cross-table5:55
Learn how to create and refine cross-tabulations in SAS by using additional keywords, selecting fiscal year and quarter by category, and displaying frequency and percent with the list keyword, charts.
Understanding the basics of Proc Tabulate technique6:32
This lecture introduces the basics of the proc tabulate technique in SAS. It demonstrates creating tables from a numeric measure using category and subcategory variables with sum or mean.
More applications using Proc Tabulate9:10

What is descriptive statistics and what are the techniques available in SAS?1:57
Explore descriptive statistics in SAS by extracting information from numeric variables in a dataset, including mean, maximum, minimum, and observations, using three SAS procedures.
Understanding Proc Summary technique in SAS11:05
Understanding Proc Means technique in SAS10:11
Understanding Proc Univariate technique in SAS8:41

Exporting SAS data file to CSV file6:46
Learn how to export SAS data files to csv using server-based folders, create a folder for export, specify the csv extension, and download the file for reuse.
Exporting SAS data file to Text file formats7:18
Exporting SAS data file to Excel file formats5:37
Importing CSV to SAS data file5:39
Importing Text file formats to SAS data file5:10
Importing Excel file formats to SAS data file4:26

Requirements

No prior knowledge on SAS or any other software is needed.

Description

The following topics will be covered as part of this series. Each topic is described in detail with hands-on exercises done on SAS Studio to help students learn with ease. We will cover all the nitty-gritty that you need to know to get started with SAS along with the data manipulation, extraction, merging, sql and macros. The lessons in this course are meant to be taken in order, as each lesson builds up on knowledge, and may mention some important ideas/concepts. If you skip videos, it may appear that some aspects are not being explained. For example, if you skip the import.txt lecture because you only care about importing .csv files, you may miss explanations about certain lines of codes.This series of tutorials will help you understand the basic and advanced of SAS Programming on SAS Studio environment. The topics that we will cover in this course are as follows:

Introduction to SAS
The Procedure step in SAS
Subsetting in SAS
Sorting and finding the unique values in SAS
Table creation in SAS
Descriptive statistics in SAS
Exporting and Importing datafiles in SAS
Formats and Functions in SAS
Appending and Merging of data sets in SAS
Arrays and reading raw files in SAS
Structured Query Language (SQL) in SAS using Proc SQL
Data Manipulation and Joining using Proc SQL
SAS Macros

Who this course is for:

This course is highly recommended for Students, Working Professionals, Business Analysts, Consultants, Businessmen, Teachers, Lecturers, Professors and data science enthusiasts.
The course is best for individuals who are in the field of Business Analytics or is eager to join the same

SAS Programming

What you'll learn

Explore related topics

Course content

Introduction to SAS7 lectures • 55min

The Procedure step in SAS8 lectures • 35min

Subsetting in SAS8 lectures • 1hr 4min

Sorting and finding the unique values in SAS4 lectures • 30min

Table creation in SAS5 lectures • 35min

Descriptive statistics in SAS4 lectures • 32min

Exporting and Importing datafiles in SAS6 lectures • 35min

Formats and Functions in SAS7 lectures • 1hr 15min

Appending and Merging of data sets in SAS7 lectures • 44min

Arrays and reading raw files in SAS4 lectures • 40min

Requirements

Description

Who this course is for: