Home
actuary.dev
Cancel

Understanding PROC SQL in SAS

As my experience with SAS grows, I find myself predominantly using PROC SQL for any data manipulation tasks. This is the general structure of SQL queries that most interns and entry-level analysts...

SAS Creating Tables

In this post, I’ll briefly detail my method for storing tables in SAS using datalines. This can keep assumptions/input close to the programs that use the information while simultaneously allow for ...

SQL Leading vs Trailing Commas

When writing “PROC SQL” statements in SAS, you have the choice to put your commas at the beginning (leading) or at the end (trailing) of your lines when selecting multiple columns. Here’s an examp...

SAS Basics

SAS is programming language designed for statistical analysis and excels at database operations. Unlike many languages, SAS is whitespace-agnostic meaning tabs, line breaks, and excess spaces are t...

SAS Version Control

tl;dr In order to use GIT with SAS you need to: Only save linked programs and minimize the additions of new linked files (.EGPs are rarely uploaded and may be deleted/replaced.) Enable relativ...

Excel Tips

Excel Tips As an actuarial intern, you will likely be spending a lot of time working with data in Excel. To help you work more efficiently and accurately, it’s important to know some of the most u...

Universal Life Insurance

Introduction to Universal Life Insurance Overview A whole life insurance contract will stipulate the death benefit and cash value table for the life of an individual provided they pay a fixed prem...

Server Hardware

Modular and Energy-Efficient Server Setup for Virtualization In this blog post, I will share my server setup designed to be modular and energy-efficient, with a focus on virtualization and storage....

Actuarial Intern Resources

Exam Resources Wisconsin School of Business (free) Coaching Actuaries The Infinite Actuary Terminology and Core Concepts Introduction to Property and Casualty insurance by Milliman Programming ...

Life Insurance

Notation Summary \({p}_{x}\) - probability of living from age $x$ to age $x+1$ $q_{x}$ - probability of death between ages $x$ and $x+1$ \(_{n}q_{x}\) - probability of death between ages $x$ and...