@sassoftware/gpt-samples

A sample Assistant for Viya using OPENAI Assistant and SAS Viya

The key examples are:

• Assistant - An assistant built with openai Assistant API with functions using SAS REST API. This is the main focus of this repository.

• Couple of basic examples demonstrating chatgpt with functions.

The functions are small and easy to follow. Feel free to change these to suit own programming style.

The code is in https://github.com/sassoftware/restaf-demos/tree/gpt-samples

Table of Contents

• Data Points
• SAS Assistant
• Installation and setup
• Basic example
• Basic example with access to Viya

---;

Data Points

Requirements

• Make sure the node version is >=18.0.0

• gpt-4-turbo model is the default openai model..

• It is the user's reponsibility to get the api key for openai. The following environment variables are read.

  • If provider is openai:

    • openaiKey: process.env.OPENAI_KEY,

  • If provider is azureai:

    • azureaiKey: process.env.OPENAI_AZ_KEY,
    • azureaiEndpoint: process.env.OPENAI_AZ_ENDPOINT

• Recommend reusing a thread that was created in a earlier session. Run the tool once by selecting true for thread option to get the threadid. You can also get it from the openai Assistant playground.

  • OPENAI_THREADID - the id of the thread.

• Most examples useSAS REST API to access SAS Viya. The applications use @sassoftware/restaf, @sassoftware/restaflib and @sassoftware/restafedit to make these calls. See https://sassoftware.github.io/restaf/ for more information.

• The source code in this repository is provided under Apache-2.0 licensing model

Authentication

Please sas-cli auth login|logCode to setup authentication token.

Running without a Viya

Select none for Viya server at the initial prompt.

Running the Assistant

After setting the environment variables listed above, start the application as follows:

npx @sassoftware/gpt-samples@latest

Answer the configuration prompts. The tool will create or reuse and existing assistant. User can then enter prompts for the assistant.

Enter help to get guidance on what is possible

The gpt session will stay active until you enter exit

Cloning the repository

Installation and Setup

The instruction below is for those users who wish to clone the code and extend the application.

• git clone https://github.com/sassoftware/restaf-demos gpt-samples -b gpt-samples
• cd gpt-samples
• npm install

Customizing the application.

The contents of the folder gptFunctions can be modified to suit your needs. See online documentation here

Getting started - Basic example

This example demonstrates setting up access to gpt and defining a function called basic. This function's sole purpose is to reformat user provided keywords as html, array or JavaScript object. The code is in ./packages/basic/index.js

Usage

npm run basic <some text>

Some sample prompt and results:

npm run basic what is SAS Viya

SAS Viya is a cloud-based, in-memory analytics engine from SAS Institute, an American multinational developer of analytics software. SAS Viya provides quick, accurate results and reveals valuable insights from large amounts of data. It's capable of machine learning, text analytics, forecasting, optimization, and statistics. It can be used through a variety of programming languages including Python, R, Java, and Lua, or through its visual interface.

npm run basic keywords

Sure, can you provide me with the keywords you want to process?

npm run basic keywords a,b,c as array

[ 'a', 'b', 'c' ]

npm run basic keywords a,b,c as html

<ul><li>a</li><li>b</li><li>c</li></ul>

Example with access to Viya

This is similar to the previous example The basic function now executes SAS code or casl code.

The prompt should look something like this:

run file path to your .sas file or .casl file

The following starter files are included. Use .sas files if env VIYASOURCE is set to compute

• ../../programs/echo.casl
• ../../programs/datastep.casl
• ../../programs/datastep.sas

Usage for SAS example

npm run basicSAS "run file <some path>"

run file ../programs/datastep.casl

{
    "casResults": {
        "result": {
            "Fetch": {
                "_ctb": true,
                "attributes": {
                    "Action": {
                        "type": "string",
                        "value": "fetch"
                    },
                    "Actionset": {
                        "type": "string",
                        "value": "table"
                    },
                    "CreateTime": {
                        "type": "double",
                        "value": 2022787095.92428
                    }
                },
                "label": "Selected Rows from Table A",
                "name": "Fetch",
                "rows": [
                    [
                        1,
                        1
                    ]
                ],
                "schema": [
                    {
                        "attributes": {},
                        "format": "",
                        "label": "",
                        "name": "_Index_",
                        "type": "int",
                        "width": 8
                    },
                    {
                        "attributes": {},
                        "format": "",
                        "label": "",
                        "name": "x",
                        "type": "double",
                        "width": 8
                    }
                ],
                "title": "Selected Rows from Table A"
            }
        }
    }
}

run file ../programs/datastep.sas

Make sure the env variable VIYASOURCE is set to compute.

[
    {
        "line": "1    options NOSYNTAXCHECK OBS=MAX;%let syscc=0;",
        "type": "source",
        "version": 1
    },
    {
        "line": "2    data a;",
        "type": "source",
        "version": 1
    },
    {
        "line": "3      x=1;",
        "type": "source",
        "version": 1
    },
    {
        "line": "4    run;",
        "type": "source",
        "version": 1
    },
    {
        "line": "",
        "type": "note",
        "version": 1
    },
    {
        "line": "NOTE: The data set WORK.A has 1 observations and 1 variables.",
        "type": "note",
        "version": 1
    },
    {
        "line": "NOTE: DATA statement used (Total process time):",
        "type": "note",
        "version": 1
    },
    {
        "line": "      real time           0.00 seconds",
        "type": "note",
        "version": 1
    },
    {
        "line": "      cpu time            0.00 seconds",
        "type": "note",
        "version": 1
    },
    {
        "line": "      ",
        "type": "note",
        "version": 1
    },
    {
        "line": "",
        "type": "note",
        "version": 1
    },
    {
        "line": "5    ",
        "type": "source",
        "version": 1
    },
    {
        "line": "6    proc print; run;",
        "type": "source",
        "version": 1
    },
    {
        "line": "",
        "type": "note",
        "version": 1
    },
    {
        "line": "NOTE: There were 1 observations read from the data set WORK.A.",
        "type": "note",
        "version": 1
    },
    {
        "line": "NOTE: The PROCEDURE PRINT printed page 1.",
        "type": "note",
        "version": 1
    },
    {
        "line": "NOTE: PROCEDURE PRINT used (Total process time):",
        "type": "note",
        "version": 1
    },
    {
        "line": "      real time           0.05 seconds",
        "type": "note",
        "version": 1
    },
    {
        "line": "      cpu time            0.06 seconds",
        "type": "note",
        "version": 1
    },
    {
        "line": "      ",
        "type": "note",
        "version": 1
    },
    {
        "line": "",
        "type": "note",
        "version": 1
    },
    {
        "line": "7    ",
        "type": "source",
        "version": 1
    },
    {
        "line": "8    ;",
        "type": "source",
        "version": 1
    },
    {
        "line": "",
        "type": "note",
        "version": 1
    }
]