GitHub - jrsousa2/SAS: Collection of SAS and SQL codes that I developed plus a few sample results.

Collection of SAS and SQL codes that I've developed over the years.

I use these codes so I don't ever have to reinvent the wheel (some of them are convoluted).

I also use it for quick reference, since it's too much information to memorize.

This is a work in progress, please bear with me. I have to clean up and convert more code files.

Here are some examples of final products created in SAS:

A dashboard created with SAS/GRAPH (nowadays this could've been done more easily in Power BI):

A SAS stored process created to automate data pulls:

PS Any info that could id anybody was carefully concealed from both code and image.

Name		Name	Last commit message	Last commit date
Latest commit History 39 Commits
Array usage		Array usage
Backs up tables		Backs up tables
EG		EG
Export or Import tables		Export or Import tables
File sizes and owners		File sizes and owners
Graph dashboard		Graph dashboard
Indexes		Indexes
Insurance		Insurance
Layouts		Layouts
Libnames to DB's		Libnames to DB's
Mainframe FTP		Mainframe FTP
Optimizes text cols lengths in Table		Optimizes text cols lengths in Table
Proc Report		Proc Report
Reminders		Reminders
SQL syntax		SQL syntax
Scans a remote folder for files		Scans a remote folder for files
Scheduler		Scheduler
Sends Email		Sends Email
Settings		Settings
Smart field selection		Smart field selection
Splits file based on Tuple		Splits file based on Tuple
Stacks proc imported tables		Stacks proc imported tables
Stored Process		Stored Process
Summarize vars univariately		Summarize vars univariately
Teradata		Teradata
Transpose Excel files with same cols		Transpose Excel files with same cols
Unix		Unix
Zips a file		Zips a file
.gitignore		.gitignore
GitSAS.bat		GitSAS.bat
README.md		README.md

Provide feedback