SAS, PROC SQL; techniques demonstrated: Join, Concatenate, Conversion, Extract, Aggregated functions, Intck, Intnx, Lead, Lag, Substring, Union, Macro, Proc, etc
