Sample code (and tips) for applying SAS Formats to data before pulling into excel:
Dim obConnection As
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.
Paul Homes has an excellent explanation of this.. The below may be helpful as a simple quick reference guide.