SAS SCD2 Loader February 20, 2021 SAS SCD2 Loader macro code to keep a full history for a given table. Read More
Create Folder Recursively with Excel VBA January 31, 2021 How to: create folders recursively using VBA code in Excel. Read More
Weighted Moving Average (WMA) January 24, 2021 The Weighted Moving Average (WMA) is a smoothing calculation which like the Exponential Moving Average (EMA) applies greater weighting to more recient data but unlike the EMA is not cumulative. Read More
Open Explorer and select file in Excel VBA January 17, 2021 How to: open an Explorer window so a user can select a file in Excel VBA. Read More
SAS Remove Special Characters from String January 10, 2021 How to: check for, identify and remove non-alphanumeric characters when working with strings in SAS base code. About The below SAS code is one… Read More
Clear RAM (Garbage Collection) in Python January 1, 2021 Clear RAM usage at run time in Python with this function and optionally print the remining RAM usage. Helpful when executing code in loops… Read More
Scheduling Script (SAS Enterprise Guide) December 4, 2020 Execute SAS scripts at specific times from within SAS Enterprise Guide without user input (e.g. over night). Read More
Postgres – List Tables Sizes November 22, 2020 How to: list table sizes in PostgreSQL Database using only SQL and built in PG functions. Read More
Sharpe Ratio (SR) November 16, 2020 SR helps you understand the returns of a strategy/portfolio in relation to the risks taken to gain these returns. Read More
Exponential Moving Average (EMA) November 8, 2020 The Exponential Moving Average (EMA) is a cumulative smoothing calculation which applies greater weighting to more recient data within the period. Read More