VBA and SAS IOM - applying formats

Sample code (and tips) for applying SAS Formats to data before pulling into excel:

Dim obConnection As 

Improve performance of DI Studio client

You can speed up the performance of your DI Studio client by increasing memory via the JavaArgs_1 variable in the distudio.ini file.  A suggested approach is to increase from -Xmx512m to -Xmx1024m.

Allow XCMD on the workspace server

Paul Homes has an excellent explanation of this..  The below may be helpful as a simple quick reference guide.

ssh: connect to host bitbucket.org port 22: Bad file number

Phew - 4.5 hours later, the problem is solved!  Let me save you 4 hours and 25 minutes, if you are submitting / getting the response below when trying to connect to your GIT repository from within a company firewall (on Windows):