VBA and SAS IOM – applying formats

Sample code (and tips) for applying SAS Formats to data before pulling into excel: Dim obConnection As New ADODB.ConnectionDim obRecordSet As New ADODB.Recordset'workspace (ws) object previously definedobConnection.Open "provider=sas.iomprovider.1; Data...

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. This is further documented in usage note 41571.  A similar...