As far as I know, SODA officially supports only two development interfaces, namely SAS Studio and SAS Enterprise Guide. For VS Code to work, SODA would have to allow VS Code API calls from your PC and I suspect this would not currently be allowed for security reasons. On the other hand, there is no harm in asking SAS if they would consider it.
If you want to learn more about the VS Code SAS extension check out the github site: https://github.com/sassoftware/vscode-sas-extension/issues
To me it still looks experimental and a "work in progress" and is probably not mature enough yet to be considered for this use case.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.