I have an Excel VBA macro that I need to convert to SAS 9.4. The purpose of this file is to create a new spreadsheet that contains all files and the information on creation/last modified dates and owner from a Shared Drive. The Excel macro takes so long it times out 95% of the time. I need to convert it to SAS 9.4 for efficiency, but VBA is not my strong suit. Is there code I can run that will do the same thing in SAS or a way to convert the VBA to SAS language? I have attached the code in a Word doc as xlsm file types are not supported. Thank you in advance! Kimberly
... View more