Pinned Loading

1. SASCode-Global-Super-Store SASCode-Global-Super-Store Public

   SAS, PROC SQL; techniques demonstrated: Proc import, Append, Extract/Substr, Scan, Intnx, Intck, Case, Year, Scan vs Substr, CATS/X Concatenate, SAS Drop, Distinct (remove duplicatte after join), A…

2. Python-Code Python-Code Public

   Libraries: Pandas, Numpy, Matplotlib; Techniques demonstrated: Remove Duplicates, Concatenate, Join, Split, Extract, Add, Get difference, Define a function, Group by, Sum, Order by, Filter, Count; …

3. SAS-PROCSQL-CODE SAS-PROCSQL-CODE Public

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

4. Other-Practice-MSAccess Other-Practice-MSAccess Public

   Techniques demonstrated: find second highest (Aggregated functions, Sub-query), Group by, Having, Like, Concatenate in Access, Calculation, Self Join, Union, IIF, Extract date, MID/LEFT/RIGHT, Instr

   1