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...
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...
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 ...
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 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...
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 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...
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...
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....
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 ...
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...