The Simplest Guide to SAS Programming -Base and Advanced

Best seller

Created By Super Admin

$ 0

50% off $ 0

Estimated Time

0 hours 0 mins

On demand video

Enrolled By

0

Students & professionals

Total

0

Resources

Full

Lifetime

Access

About this Professional course

What You Will Learn

Course content

Introduction and Overview

Course Overview

Why SAS

0 hours 7 mins to complete

2 lessons

Getting started with SAS Programming

Why is SAS so easy to learn

SAS Studio through SAS OnDemand- Registration

Logging-in to SAS after installation

SAS Interface and windows

0 hours 8 mins to complete

4 lessons

Preparing Data

Bringing data into SAS using DELIMITER option

Bringing data into SAS using DSD option

Bringing data into SAS using column input

Bringing data into SAS using the column pointer

Bringing data into SAS using the line pointer#

Bringing data into SAS using the line slash

Bringing data into SAS using the trailing@

Bringing data into SAS using the trailing double @@

Bringing data into SAS using Proc Import xls

Bringing data into SAS using Proc Import txt

Creating new variables

Creating new variables - code

Keeping, Dropping and Renaming Variables in a Dataset

If-else conditional statements - deriving BMI variable

If-else conditional statements - deriving status variable

Filtering data

SAS Dates

SAS Functions - Upcase

SAS Functions - Lowcase, Propcase, Len, Cat

SAS Functions - Substr

SAS Functions -Trim, Left, Strip, Compress, Compbl

SAS Formats - Introduction

SAS Format Statement

Format Naming Convention

Format using the PUT function

SAS Informats

SAS Informats - code

Custom formats using Proc Format

Custom formats using Proc Format - code

Program Data Vector- PDV

Implicit Output- Descriptor portion

Implicit Output - var and data portion

Explicit Output

Explicit Output - code

Do Loops

Project Cars- Introduction

Project Cars- Assignment 1- Statement

Project Cars- Assignment 1 - Solution

Module Conclusion-preparing data

Preparing Data - Section Overview

SAS Dataset, Variables and Observations

SAS Libraries

Lib Naming Conventions

Dataset Naming Conventions

SAS Program Syntax

SAS Data Step and Proc Step

Referencing data in sas

Bringing data into SAS

Bringing data into SAS using Import Wizard

Bringing data into SAS using LIBNAME statement

Bringing data into SAS using FILENAME

4 hours 34 mins to complete

51 lessons

Structuring Data

Structuring Data - Section Overview

Stacking Data using a Data Step

Stacking Data using PROC APPEND

Stacking Data using PROC APPEND- code

Interleaving of data

Sorting Data using PROC SORT

Sorting Data using PROC SORT - multi-level sorting

Removing duplicates -NODUP Option

Removing duplicates -NODUPKEY Option

Simple merging of data

Merging data using Joins-Introduction

Merging data using Inner Join

Merging data using Inner join - code

Merging data using Full Join

Merging data using Left Join

Merging data using Right Join

Merging data using "far" joins

PROC SQL - ing data

Proc SQL - ing data - code

PROC SQL - filtering data

PROC SQL - sorting data

PROC SQL - removing duplicates

Transposing data - ID Statement

Transposing data - ID Statement - code

Transposing data - BY statement

Transposing data - BY statement - code

Retain Statement - Introduction

Retain Statement - how to use

Retain Statement - Example

Project Cars- Assignment 2- Statement

Project Cars- Assignment 2- Solution

Conclusion structuring data

3 hours 49 mins to complete

32 lessons

Visualizing Data

Visualizing Data - Section Overview

Charts - Introduction - Vertical Bar Chart

Charts - Horizontal Bar and Pie Charts

Vertical bar chart - DISCRETE option

Horizontal bar chart - DISCRETE option

Vertical bar chart - groups and subgroups

Horizontal bar chart - groups and subgroups

Plots

Report Output using PROC PRINT

Report Output using PROC REPORT - DISPLAY option

Report Output using PROC REPORT - ORDER & GROUP option

Summary statistics - PROC FREQ

Summary statistics - PROC MEANS

Summary statistics - PROC UNIVARIATE

Output Delivery System (ODS) - Report Formats

ODS with Proc Freq

ODS with Proc Means

ODS with Proc Univariate

Project Cars- Assignment 3- Statement

Project Cars- Assignment 3- Solution

Conclusion visualizing data

2 hours 42 mins to complete

21 lessons

Optimizing Code

Optimizing Code - Section Overview

Macro Variables - Introductionduction

Macro Variables - Introductionduction - code

Application of Macro variables

Application of Macro variables - code

Nested macro variables and ampersand resolutions

More on Ampersand resolutions using a cool example

SAS Macros - Introductionduction

SAS Macros - Examples

Macro Functions

Macro Functions - code

Project Cars- Assignment 4- Statement

Project Cars- Assignment 4- Solution

Conclusion optimizing code

1 hours 16 mins to complete

14 lessons

Practice Exercise | Case Study

Project Heavy-weight - Introduction

Project Heavy-weight - Project 1 -Statement

Project heavy-weight- Project 1 - Solution

Project Heavy-weight - Project 2 - Statement

Project Heavy-weight -Project 2 - Solution

Project Heavy-weight - Project 3 - Statement

Project Heavy-weight - Project 3 - Solution

0 hours 37 mins to complete

7 lessons

Top Reviews

No reviews yet

Frequently Asked Questions

How do I purchase a course?

To purchase your course online just follow the link. Online purchases can either be paid for immediately by credit/debit card, you can nominate somebody else to pay on your behalf, or an invoice can be requested.

How do I access the courses I have paid for?

On completing the online purchase process you will have immediate access to your course. 

How long do I have access to my purchased course?

You have access to the courses you have purchased indefinitely. Once the payment is made, the confirmation notice will be sent to the client via email within 24 hours of receipt of payment.

Do I have to complete a course in one go?

No, you can visit it at any time, wherever you are. Each course is made up of a number of individual modules which enables you to complete it in your own time and at times convenient to you. If you wish to return to the course at the point, you last left it at, please ensure you use the same device to access the course and do not clear your cache in between visits.

I have purchased the course online but cannot access the course?

Please contact the QH social media or by calling +97150209580.

Can I download or print a copy of the course material?

The software that we use for our eLearning does not have a download or print function, so there is no easy way to obtain this. For this reason, once you have purchased individual eLearning courses with us you have indefinite access to them so that you may return to the information and review it at any time.  

When I will receive the refund payment?

Refunds will be made onto the original mode of payment and will be processed within 10 to 45 days depending on the issuing bank of the credit card used.

What are the criteria in refund the payment for courses?

Any learner can withdraw from the programme and receive a refund based on the following Criteria:1- Online courses 24 hours Before the course starts: No refund.2- more than 24 hours before the course starts: Full refund.3- Products Full refunds within 14 days of purchase.Services As per terms and conditions in the service delivery contract.4. Payment confirmation

Can I cancel any program\course I sign in?

Customer can cancel their order/requested services within 24 hours; refunds will be made back to the payment solution used initially by the customer. Please allow for up to 45 days for the refund transfer to be completed.

If I fail a course, can I retake it?

If you did not pass the course with the grade required to earn the certificate, you can enroll in a future session.

Options for Purchasing a Program.?

There are 2 options:Option 1: purchase the program bundle:One-click bundle purchase to add all the program courses at once.Option 2: Upgrade Course by CourseYou can also purchase the program courses one by one.  

What types of certificates does SEP offers?

SEP currently offers two types of certificates:- Certificates for single courses- Program certificates for programs (series of courses)

Does SEP offer free certificates?

SEP courses do not award free certificates. Certificates are awarded only to passing students registered in the paid certificate track. The enrollment fee for this track varies by course.

Can I get a paper copy of my certificate?

SEP cannot send individual printed copies of certificates. However, you can save the certificate by downloading it as a PDF file.

I am not interested in a certificate. Can I still enroll in a course?

Yes. With the exception of professional education courses.

How do I download my certificate?

You can save your certificate on your computer by downloading it as a PDF using either the Chrome or Safari browser. 

How can I add my certificate to my LinkedIn profile?

To add your SEP certificate directly to your LinkedIn profileLog in to your LinkedIn account, then go to your profile.On the right, in the Add profile section dropdown, choose Background and then select the drop-down triangle next to Licenses & Certifications.In Name, enter the name of the course or program.In Issuing Organization, enter "SEP".(Optional) In Issue Date, enter the time period during which you earned the certification.(Optional) Select the checkbox This certification does not expire.You can leave the Credential ID field empty.In Certification URL, enter the URL for your certificate.