Archives: Courses

Proc SQL Courses

This is a sample course. For the full courses, please see course 1 and course 2. Proc SQL is an advanced SAS programming technique that allows you to retrieve, manipulate and analyze data in SAS. It can achieve many of the same tasks as data step, but with less code and higher efficiency. It is …

Proc SQL Courses Read More »

Credit Card Database Marketing Project

Credit card companies know the purchasing behavior of their customers. They know exactly what was purchased, the purchase date, where the purchase was made, and who made the purchase. They then launch ultra-targeted promotional campaigns based on their customers' buying preferences. In this database marketing project, you will learn how to analyze a number of …

Credit Card Database Marketing Project Read More »

Hypothesis Testing (mini course)

This is a mini course for hypothesis testing, and is part of the SAS Base Programming Course for Absolute Beginners (Part 2). It covers how to test a hypothesis in SAS, step-by-step. You will learn the concepts of sample means and repeated samplings, when to accept or reject a hypothesis and the meaning behind it, …

Hypothesis Testing (mini course) Read More »

SDTM, ADaM Implementation Project

CDISC Standard Implementation Project We are a CRO (contract research organization) and we are looking for someone to help us with an open-label, non-randomized, multi-centre Phase 1 study to assess the pharmacokinetics, safety and tolerability of ABC drug following a single oral 80 mg dose to patients with advanced solid tumors and normal renal function …

SDTM, ADaM Implementation Project Read More »

Introduction to Time Series Analysis

Time series modeling has a wide range of business applications. Hotels use their historic booking data to predict the booking rate for the upcoming holiday season. Retailers analyze the seasonal trend and forecast their sales for inventory management. In this project, we will analyze the 60-day average daily demand at a physical retail store. By …

Introduction to Time Series Analysis Read More »

Proc SQL Course 2

SASCrunch Proc SQL Course (Part 2) is an advanced SAS programming course focusing on the Proc SQL procedure in SAS. It covers different types of joins and SET operators using Proc SQL. You will also learn how to update and modify SAS tables, and create integrity constraints using the SQL PROC procedure. Upon completion of …

Proc SQL Course 2 Read More »

Proc SQL Course 1

Proc SQL is an advanced SAS programming technique that allows you to retrieve, manipulate and analyze data in SAS. It can achieve many of the same tasks as the DATA step, but with less code and higher efficiency. It is often the preferred programming method of SAS professionals who work with relational databases that require …

Proc SQL Course 1 Read More »