The SAS ODS is running on Linux Operating System, while VBA is a Windows technology! So unless you find a technology/interface that can run Windows programs on Linux/Unix operating systems, you are out of luck
If you ever manage to find a resolution for Issue #1, SAS ODA doesn't allow users to run OS commands. It's a security measure. Which means you'll not be able to run any commands from a command Prompt! 😐
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.