Skip to main content
Glama
sassoftware

SAS MCP Server

Official
by sassoftware

Create Lookup Table

create_lookup_table

Create a SAS Intelligent Decisioning lookup table that maps unique keys to stored values, optionally publishing it for rules to use immediately.

Instructions

Create a SAS Intelligent Decisioning lookup table: keys and the value stored for each.

A rule uses it with a condition {"type": "lookup", "term": {...}, "lookup": "<name or ID>"} (is the variable's value a key?) or an action {"type": "lookupValue", "term": {...}, "expression": "<key expression>", "lookup": "<name or ID>"} (assign the key's value).

Rules only see an active version. With activate the table is published to MAS and CAS right away (usually seconds); otherwise call activate_lookup_table once the entries are final.

Keys are text up to 256 characters, values up to 512; numbers are stored as text. Keys must be unique and values not empty — an empty value behaves like a missing key.

Input Schema

NameRequiredDescriptionDefault
nameYesLookup table name.
folderNoWhere to store it: a folder path, ``My Folder``, a folder ID or URI. Omit to use the default folder; if there is none, ask the user.
entriesYes``{"Iran": "High", "Cuba": "High"}``, or a list of ``{"key", "value"}`` objects or ``[key, value]`` pairs.
activateNoPublish the first version right away (default false).
key_labelNoOptional name of the key column, e.g. "Country".
descriptionNoOptional description.
value_labelNoOptional name of the value column, e.g. "Risk level".
wait_secondsNoHow long to wait for activation to finish (max 300).

Output Schema

NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv1.19.0

TDQS

A4.5/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Goes well beyond the annotations: discloses that rules only see an active version, that activation publishes to MAS and CAS in 'usually seconds', and that wait_seconds governs how long to block. It also surfaces non-obvious validation constraints (key texts up to 256 chars, values up to 512, numbers stored as text, keys unique, empty value behaves like a missing key) that no annotation or schema field conveys.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Front-loads the core purpose, then layers activation semantics and constraints. Dense but every paragraph carries information; the embedded rule-JSON examples for `lookup` and `lookupValue` are the only portion that could arguably be trimmed for an agent that already knows the ruleset format.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For an 8-parameter creation tool with annotations and an output schema, this covers purpose, activation lifecycle, and data constraints well; return values need not be explained. It omits failure behavior — e.g. what happens on duplicate keys or name collisions — which an agent creating assets would benefit from knowing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so baseline is 3, and the description earns above that by adding real meaning: it explains the runtime consequence of `activate` (MAS/CAS publication) and puts hard limits on the shapes accepted by `entries` and the key/value content. The remaining parameters (folder, key_label, value_label, description) are left entirely to the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Opens with a specific verb and resource ('Create a SAS Intelligent Decisioning lookup table') and immediately defines what the resource is — keys plus a stored value per key. This distinguishes it clearly from sibling creators like create_value_list, create_business_ruleset, or create_segmentation_tree without needing to inspect any schema.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Explicitly routes on the activation decision: pass `activate` to publish immediately, or 'call activate_lookup_table once the entries are final' — naming the concrete sibling alternative. It does not address the update path (update_lookup_table) or when to prefer a value list instead, so it stops short of full when/when-not coverage.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools