I have an Excel file with VBA code I need to convert to SAS 9.4 for efficiency

[kswarfield]

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

[Reeza]

Like a directory listing?

https://support.sas.com/kb/24/820.html

---

@kswarfield wrote:

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

---

[Tom]

Why not just read the text generated by the DIR command?

Does your SAS installation not allow operating system commands to be called?

[kswarfield]

I am not sure, I've not used it before and don't know how.