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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: