SAS MCP Server
OfficialServer Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| VIYA_ENDPOINT | Yes | The URL of your SAS Viya server |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_sas_codeA | Executes the provided SAS code in the Viya environment and returns information about the completed Job. This will create a job definition for the SAS code, execute it, and then retrieve the results. |
| list_cas_serversA | List available CAS servers on the Viya environment. |
| list_caslibsB | List CAS libraries (caslibs) available on a CAS server. |
| list_castablesB | List tables in a CAS library. |
| get_castable_infoA | Get metadata for a CAS table (row count, column count, size, etc.). |
| get_castable_columnsA | Get column metadata for a CAS table (names, types, labels, formats). |
| get_castable_dataB | Fetch rows from a CAS table with column names. |
| upload_dataB | Upload CSV data into a CAS table. |
| promote_table_to_memoryA | Promote a CAS table to global scope (makes it visible to all sessions). |
| list_filesB | List files in the Viya Files Service. |
| upload_fileB | Upload a file to the Viya Files Service. |
| download_fileB | Download file content from the Viya Files Service. |
| list_reportsB | List Visual Analytics reports. |
| get_reportA | Get a Visual Analytics report's metadata and definition. |
| get_report_imageB | Render a Visual Analytics report section as an image. |
| submit_batch_jobB | Submit a SAS job for asynchronous execution via the Job Execution service. |
| get_job_statusB | Check the status of a submitted job. |
| list_jobsC | List recent jobs from the Job Execution service. |
| cancel_jobB | Cancel a running job. |
| get_job_logB | Retrieve the log of a completed job. |
| list_ml_projectsB | List AutoML pipeline automation projects. |
| create_ml_projectB | Create a new AutoML pipeline automation project. |
| run_ml_projectC | Run an AutoML pipeline automation project. |
| list_registered_modelsC | List models in the Model Repository. |
| list_models_and_decisionsC | List published scoring models and decisions (MAS modules). |
| score_dataB | Score data against a published model or decision (MAS module). |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
| debug_sas_log | Analyze a SAS log for errors, warnings, and notes with root-cause explanations and suggested fixes. |
| explore_dataset | Generate comprehensive SAS data-profiling code (CONTENTS, MEANS, FREQ, UNIVARIATE). |
| data_quality_check | Generate SAS code for a data quality assessment (completeness, uniqueness, validity). |
| statistical_analysis | Set up a complete SAS statistical analysis workflow with diagnostics. |
| optimize_sas_code | Review and optimize SAS code for performance, readability, or both. |
| explain_sas_code | Provide a block-by-block explanation of SAS code, tailored to skill level. |
| sas_macro_builder | Build a production-quality reusable SAS macro. |
| generate_report | Generate SAS ODS/PROC REPORT code for formatted output. |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/sassoftware/sas-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server