topic Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server? in Administration and Deployment

Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server?

Acf2 — Sun, 21 Jan 2024 22:22:12 GMT

Has anyone got this working?

From vscode-sas-extension/connect-and-run.md at 431a2b6e3cf11c473c1a0221a10ce9be0fccde97 · sassoftware/vscode-sas-extension · GitHub :

Profile: SAS 9.4 (remote - IOM)

In order to use this option, you'll need to have "Integration Technologies Client" (ITC) installed on the machine this extension runs on. You can do this by making sure the "Integration Technologies Client" checkbox is checked when installing SAS 9.4, or by visiting the following link (Make sure to download the 9.4m8 option).

Profile Anatomy

The parameters listed below make up the profile settings for configuring a connection to a remote SAS 9.4 instance.

Name Description Additional Notes

Name	Name of the profile	This will display on the status bar
Host	IOM Server Host	This will appear when hovering over the status bar
Username	IOM Server Username	A username to use when establishing the IOM connection to the server
Port	IOM Server Port	The port of the IOM server. Default value is 8591

We cannot run a listening SSH service on our Windows 2019 server but the Integration Technologies client is showing a successful connection to SASApp - Logical Workspace Server and SASMeta. SASApp - Logical Stored Process Server times out but works using the MS Office addin. Hopefully, that is not relevant.

Using SAS.addProfile , specifying the connection name then 'SAS 9.4 (remote)' only prompts for the name of the SAS 9 SSH server and the SAS executable location on the server. How do we get the IOM option?

I have tried manually editing settings.json with these values replacing "ssh" with "com" and 22 with 8591 :

"profiles": {

"hqocaSAS94_com": {

"connectionType": "com",

"host": "hqocasocial2",

"username": "userid",

"port": 8591

}

Running a simple SAS program, I see a quick connection attempt then 'There was an error executing the SAS Program. See console log for more details'

The VSCode Debug Console is empty.

If someone has a working IOM connection, please provide the relevant section of settings.json from VSCode.

Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server?

SASKiwi — Mon, 22 Jan 2024 01:19:03 GMT

I suggest you open a Tech Support track for this. The instructions clearly state you should choose an IOM connection type while adding a new connection profile. If you aren't seeing that option to select, TS help seems like the best option.

I'm also moving this to the Admin and Deploy category for better visibility.

Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server?

Acf2 — Mon, 22 Jan 2024 11:53:41 GMT

As you suggest, I will contact SAS TS. I recently posted regarding 'Recent Files' in SAS/Studio which is related to this. VSCode keeps a lot of history whereas SAS/Studio submission history does not persist. Maybe I am unusual, but I am running on 3 different platforms with 3 different identities and it hard to keep track.

Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server?

AhmedAl_Attar — Mon, 22 Jan 2024 13:10:16 GMT

Hi @Acf2

I just tried creating Profile: SAS 9.4 (remote - IOM), and I was able to run code successfully 😀

Name	Description	Additional Notes
Name	Name of the profile	SASIOM
Host	IOM Server Host	<MetaData Server Name>
Username	IOM Server Username	<Registered UserName in the MetaData>
Port	IOM Server Port	8591

For this to work properly, you'll need to have a running

- MetaData Server

- SAS Object Spawner

Hope this helps

Re: Running SAS code from VS Code SAS Extension connecting to SAS v9.4 remote Server?

Acf2 — Mon, 22 Jan 2024 13:29:38 GMT

Success! I ran an update from v15.0 (2 months old) to v16.0 and was presented with an SAS Remote (IOM) option for a new connection. Looking good so far. Thanks