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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
This module is coming soon!
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
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
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
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
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
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
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