@sassoftware/mcp-serverjs Part 3: Additional tools for executing SAS programs

[#1]

Introduction

This is the third in the series discussing the functionality of the MCP server (@sassoftware/mcp-serverjs). In this article I discuss four new tools

1. program - Execute arbitrary SAS code directly - either inline code strings or stored .sas files in a SAS folder. User can supply input values which are passed to the program as macros.
2. jobdef -  Execute a job definition with input values which are passed to the jobdef as macros
3. job - Execute a job with input values which are passed to the job as macros
4. sasQuery - Execute natural language queries against SAS table. Automatically translates business questions into SAS PROC SQL statements for quick data exploration. The tool executes a job and passes the generated sql and the user prompt it as macros.

SAS Studio Flows:  A SAS Studio flow can be published as a job. So the job tool can be used to run a SAS Studio flow. In a future article I will explore running simple and complex SAS Studio flows from the mcp server, But my reluctance to claim victory should not stop you from trying your flows thru the mcp server.

The latest version has been published to github 

Scenarios for running SAS code

In the following video I show running SAS code in SAS Studio. In the second video I show how to run these programs from the mcp server

Using MCP to run SAS code

What is next

The next project is to enable the mcp server as a remote mcp server.

Links to previous articles

1.  A ModelContextProtocol Server(mcp) for Scoring with SAS Viya

2. A ModelContextProtocol Server(mcp) for Scoring with SAS Viya - Part 2: Persistence