• Home
  • Details of all courses

Course name

Course description


Introduction to the SAS working environment and SAS datasets



Course Duration: 22 mins
Required Credits: £0

Introduction to the SAS working environment and SAS datasets

In this training module we will cover the following topics:

    -   What is SAS and why do we use it?

    -   The SAS Windowing Environment  and the User Interface

    -   How to submit and save your programs in SAS

    -   SAS Libraries: Temporary and Permanent

    -   SAS datasets and what they are composed of

This module is designed to get you familiarised with working in SAS.  We will explain the different types of windows that make up the SAS windowing environment which we use to do our everyday work. For example, the Editor Window, where we write our programs, the Log window where we can see any errors that occur in our code and the Output Window where we can see summaries of our datasets. We will also explain the use of the Explorer and Results Windows, and Temporary and Permanent SAS Libraries. Finally, we will take a look at what SAS Datasets and their composites: Observations and Character and Numeric Variables.



DATA STEP and how SAS processes code



Course Duration: 32 mins
Required Credits: £0

DATA STEP and how SAS processes code

In this training module we will cover the following topics:

    -   What is a SAS DATA STEP?

    -   How SAS processes code within a DATA STEP

    -   The Compilation stage

    -   The Execution stage

    -   The Program Data Vector (PDV)

This module is designed to introduce you to SAS DATA STEPS, one of the two steps that is used to write SAS programs. We will take a look at the code of an example data step and explain some of the different elements that a data step usually consists of. We will also look at how SAS processes code behind the scenes, to help us understand this we will look at the Compilation and Execution stages that SAS goes through when processing code, and also the Program Data Vector or PDV.



How to restrict data and create new variables



Course Duration: 40 mins
Required Credits: £0

How to restrict data and create new variables 

In this training module we will cover the following topics:

 -   How to restrict data using the following SAS statements:

           -   IF statement

           -   WHERE statement

           -   KEEP statement

           -   DROP statement

      -   How to create character and numeric variables

      -   How to assign a length to our variables using the LENGTH statement

      -   What missing character and numeric values look like in our datasets

In this training module we will learn how to use SAS statements to create a dataset showing only the information or records that we want to see. By using SAS statements we will see how we can restrict data and bring in specific data in to our datasets. We will be looking at the IF, WHERE, KEEP and DROP statements and see how they can help us to do this. We will also learn how to create character and numeric variables, how to assign them a length and see what the data looks like in our dataset when a character or numeric value is missing.

 



Reading in external data into a SAS dataset



Course Duration: 50 mins
Required Credits: £0

Reading in external data into a SAS dataset

In this training module we will cover the following topics:

      -   How to read in an Excel (.xls) file into a SAS dataset

      -   How to read in an ASCII (.txt) file into a SAS dataset 

In this module we will learn how to read in an Excel (.xls) file into a SAS dataset using PROC IMPORT. We will also look at how to read in an ASCII (.txt) file into a SAS dataset using the INFILE and INPUT statements, as well as cover some essential SAS dataset options that help us to achieve this.



Sorting, Merging and Setting datasets



Course Duration: 71 mins
Required Credits: £0

Sorting, Merging and Setting datasets

In this training module we will cover the following topics:

      -   Sorting datasets with PROC SORT

-   How to SET datasets together

      -   How to MERGE datasets together

      -   When to SET or MERGE

      -   BY variables

In this module we will learn how to SET and MERGE datasets together, the difference between setting and merging, we will also look at PROC SORT and learn how to sort our datasets in order to merge them correctly. We also look at BY variables and why it is important to have a unique set of BY variables when merging datasets.



How and when to use the OUTPUT statement



Course Duration: 22 mins
Required Credits: £0

How and when to use the OUTPUT statement

In this module we cover the following topics:

     -  What is the OUTPUT statement

     -  How it works in SAS

     -  The implementation and importance of it

     -  Example code and the outcome we get using the OUTPUT statement

In this module we learn how the OUTPUT statement works and the benefits of using an explicit output statement. We will see how we can use OUTPUT so that we only see the information that we need/want to see in our datasets.



Understanding Loops



Course Duration: 50 mins
Required Credits: £0

Understanding Loops

In this module we will learn how we can use Loops in SAS to perform multiple tasks at once, saving us time and making programing less tedious. We will look at the standard DO Loop as well as look at the different types of Loops such as DO WHILE and DO UNTIL Loops and see how they can help us.



How to use the RETAIN statement



Course Duration: 36 mins
Required Credits: £0

How to use the RETAIN statement

In this module we learn about the RETAIN statement. As SAS works one observation at a time and does not carry over any values from one observation to the next, we will learn how we can use the RETAIN statement to allow us to do just that. 

We will learn how we can RETAIN a baseline value and calculate the change from baseline for every observation.



Understanding ARRAYs



Course Duration: 22 mins
Required Credits: £0

Understanding ARRAYs

In this module we will learn how to create and work with SAS ARRAYs.

We will learn how we can create an Array of SAS variables of the same type allowing us to preform the same operation on the said variables. We will see how using ARRAYs we can preform tasks on many variables at once making our programming life less tedious and make our programs more efficient.



Understanding the commonly used SAS Functions



Course Duration: 67 mins
Required Credits: £0

Understanding the commonly used SAS Functions

In this module we look at the commonly used SAS functions, we learn their syntax, their "Function" (what they do) and how to use them efficiently.

The functions covered are as follows:

    -  PUT                            -  LEFT               -  TRANSLATE      -  MEAN

    -  UPCASE                     -  RIGHT             -  LENGTH            -  MEDIAN

    -  LOWCASE                  -  STRIP             -  COUNT              -  SUM

    -  PROPCASE                -  TRIM               -  INPUT                -  MIN

    -  COMPBL                     -  SCAN             -  RANUNI             -  MAX

    -  | | (concatenate)           -  INDEX             -  N                       -  MOD

    -  CATX                          -  TRANWRD      -  NMISS               -  ABS

    -  FLOOR                       -  CEIL               -  LAG                  -  MDY

    -  TODAY                       -  DHMS             -  HMS                 -  TIME

    -  DATE                          -  DATEPART     -  TIMEPART

 



Creating and using Formats



Course Duration: 62 mins
Required Credits: £0

Creating and using Formats

In this module we cover the following topics:

- What are Formats and why we use them
- The basic syntax
- How to create user defined formats
- Format Catalog
- How to edit formats
- How to use formats effectively
- What are Informats
- Possible problems to look out for



Introduction to Proc SQL



Course Duration: 50 mins
Required Credits: £0

Introduction to Proc SQL

In this module we cover the following topics:

- What is Proc SQL and the benefits of using it.
- The basic SQL syntax
- Syntax comparison between SQL and Data Step
- Example SQL code
- SQL Views 



Creating new variables and datasets using SQL



Course Duration: 20 mins
Required Credits: £0

Creating new variables and datasets using SQL

In this module we will learn how we can create new variables and datasets using Proc SQL. We will see the differences between doing this in SQL and doing this in a DATA Step.



Merging datasets with Proc SQL and what to look out for



Course Duration: 20 mins
Required Credits: £0

Merging datasets with Proc SQL and what to look out for

In this module we cover the following topics:

- Merging data with Proc SQL
- LEFT Joins
- RIGHT Joins
- FULL Joins
- Many to Many Merge
- Possible warnings that we may get in the log and what to watch out for 

This module is coming soon!



Creating macro variables



Course Duration: 10 mins
Required Credits: £0

Creating macro variables

In this module we cover the following topics:

- What are Macro variables and the benefits of using them
- Syntax of Macro variables
- How to call Macro variables



Using Subqueries in SQL



Course Duration: 25 mins
Required Credits: £0

Using Subqueries in SQL

In this module we cover the following topics:

- How to use Subqueries in SAS
- Benefits of
Subqueries
- Syntax of
Subqueries

This module is coming soon!



How to summarise data with Proc SQL



Course Duration: 44 mins
Required Credits: £0

How to summarise data with Proc SQL

In this module we learn how to use Proq SQL to produce statistical summaries of our data. We will see how we can find out the Frequency, Minimum, Maximum, Mean and SUM of values in our data. We will also look at associated functions such as NMISS.

 



Understanding Proc TRANSPOSE



Course Duration: 29 mins
Required Credits: £0

Understanding Proc TRANSPOSE

In this module we will learn about the very useful SAS procedure Proc Transpose. We will see how we can use Proc Transpose to manipulate and transform data structures. So we can have our datasets show the data in the structure we want to see it.

For example, we might find it more useful (in some cases) to show our variables as observations (rows) and the values of said variables as variables (columns) Thus making things easier to understand just by looking at the dataset 

In this module we will learn how to use Proc Transpose, it's syntax and some commonly used options.



Understanding Proc Compare



Course Duration: 46 mins
Required Credits: £0

Understanding Proc Compare

In this module we look at the SAS procedure Proc Compare. We see how it is used to compare datasets with one another and find any differences between them. This is a very useful procedure in making sure the outputs from your SAS programs are correct and is mainly used for validation purposes.

We will also learn how to read the compare results and really understand what SAS is telling us. Also we will look at some of the useful options that we can use with Proc Compare such as the LISTALL option.



Proc Freq



Course Duration: 15 mins
Required Credits: £0

PROC FREQ

In this module we learn how to use PROC FREQ to do frequency calculations on our data. We will also look at some of the useful options that we can use in PROC FREQ.



Proc Means



Course Duration: 47 mins
Required Credits: £0

PROC MEANS

In this module we learn how to use PROC MEANS to produce statistical summaries of our data. We will see how to use PROC MEANS to find out the Minimum, Maximum, Mean and Standard deviation of values in our data.



Proc Univariate



Course Duration: 35 mins
Required Credits: £0

Proc Univariate

In this module we cover the following topics:

- What is Proc Univariate and what it does
- Syntax and useful options
- How it helps us to check the integrity of data
- How it can help us identify outlier values.
- How to read and understand all the different things it can show us.
- How we can use it to produce statistical summaries



Proc Report



Course Duration: 55 mins
Required Credits: £0

Proc Report

In this module we will learn how we can use the SAS procedure Proc Report to present or display data the way we want to see it, in a report format.

We will see how we can use Proc Report to display summary tables and listings for clinical trail reporting.

We will look at the syntax for Proc Report as well as look at some of the useful options that we can use.



Proc GPLOT



Course Duration: 20 mins
Required Credits: £0

Proc GPLOT

This module is coming soon!



Introduction to Clinical Trials



Course Duration: 33 mins
Required Credits: £0

Introduction to Clinical Trials

 In this module we will cover the following topics:

 - What are Clinical Trials

 - Types of Clinical Trials 

 - Clinical Trial Phases

 - Clinical Trial Design

 - Clinical Trial Length

 - Role of a SAS Programmer in Clinical Trials Reporting

 - Professionals involved in Clinical Trials

This module is designed to introduce you to Clinical Trials, covering all the important aspects of this industry.



Introduction to Clinical Trial Reporting



Course Duration: 33 mins
Required Credits: £0

Introduction to Clinical Trial Reporting

In this training module we will look at the following:

- How data flows through out the whole reporting process

- The different kinds of Clinical Trial Documentation, such as the Trial Protocol, the Trial Statistical Analysis Plan and so on, which are all very important and must be adhered to during the reporting process

- The types of Raw Data that is collected

- How and why Analysis Datasets are produced

-  What kind of reports we finally need to produce and see how they come together



Know the data



Course Duration: 27 mins
Required Credits: £0

Know the data

In this module we will learn about the following topics:

- What is Clinical Data

- How Clinical Data is captured

- The different types of Clinical Data, such as Safety, Efficacy etc.



Produce descriptive summary tables



Course Duration: 46 mins
Required Credits: £0

Produce descriptive summary tables

In this module we will learn the following:  

 - What are summary tables  and why we create them

 -  How to create summary tables

 -  What we should check for after creating summary tables

The Test for this module is coming soon!



Produce listings



Course Duration: 29 mins
Required Credits: £0

Produce listings

In this module we will learn  the following:

 - What is listing output and why we create them

 - How to create listing output

 - What we should check after creating listing output 

The Test for this module is coming soon!



Good Programming Practice



Course Duration: 40 mins
Required Credits: £0

Good Programming Practice

In this module we will learn the importance of good programming practice (GPP). We will learn how by following GPP we can do the following:

- Make our coding more efficient.

- Make our programs easier to read and understand, not only by ourselves but by others  who may need to use our programs and adapt them in the future.

- How to structure our programs effectively.

- How to comment our work.

- How to create abbreviations.

The Test for this module is coming soon!



Introduction to Macros and how to create them



Course Duration: 62 mins
Required Credits: £0

Introduction to Macros and how to create them

In this training module we will cover the following topics:

    -   What are SAS macros

    -   When it's useful to create a Macro

    -   Macro syntax

    -   Hows to use Macros

This module is designed to get you familiarised with SAS Macros. The module will explain the elements that you need to know about creating basic SAS macros. You will also learn how you can create a macro that will create multiple summary outputs using one macro program. 

 



One-to-one SAS support



Course Duration: 0 min
Required Credits: £0

One-to-one SAS support