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
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
Why not just read the text generated by the DIR command?
Does your SAS installation not allow operating system commands to be called?
I am not sure, I've not used it before and don't know how.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.