import export

Introduction

One of the common activities is to import and export different contents in a Viya Server. The viyacaddy package is make this job a little easier for a select set of data.

This cli is useful for:

1. Exporting selected VA reports as json files.

2. Importing Va reports stored as json files

3. Importing hdat, sas7bat, csv files into CAS

4. Importing .sas and .ds2 files into sashdat (for use with scoring actions)

Installing the cli

You can install the cli as follows:

 npm install -g @sassoftware/viyacaddy

You can also install it in a docker (see below)

Usage

The cli can be run in interactive mode or in "batch" mode.

Interactive mode

  npx @sassoftware/viyacaddy --env <your-env-file>

You will get prompt to enter commands.

The env file has the following format

```env
VIYA_SERVER=http://your-viya-server
CLIENTID=<a password client>
CLIENTSECRET=<a client secret>
```

Note that the default clientid sas.ec (no secret)can be used (consult your SAS Administrator).

Batch mode

  npx @sassoftware/viyacaddy --env <your-env-file> -- file <cmdfile>

The env file is now augmented with an userid and password as follows:

```env
    VIYA_SERVER=http://your-viya-server
    CLIENTID=<a password client>
    CLIENTSECRET=<a client secret>
    USER=username
    PASSWORD=password
    ```

You can use a previously generated token instead of userid and password. Create a token and save it in some file (say mytoken) and modify the env file as follows

```env
    VIYA_SERVER=http://your-viya-server
    CLIENTID=<a password client>
    CLIENTSECRET=<a client secret>
    TOKEN_FILE=mytoken
    ```

The cmdfile is a text file with a list of valid viyacaddy commands. These commands are executed in parallel.

Current commands

When data or report is imported, the cli will delete any existing file and create the new one. Also the new data will not be loaded into memory. That task is left to the applications that will use the tables and reports that are imported.

Basic commands

• logon - to logon to Viya. This command will prompt for username and password
• exit - to exit the cli
• help - get help on commands

Utility

• caslibs -- lists the names of all caslibs

Tables command

• tables import -- to import hdat, b7dat,csv, astore, ds2 and sas files into cas tables in a caslib

    tables import <input directory> <list of files|*> -c <caslib>
  

• tables list -- to list the names of the tables in a specific caslib

    tables list <caslib>
  

Reports command

• Import VA reports from specified directory into a SAS Viya folder

     reports import <input directory> <list of names|*> -f <folder>
  

• Export VA reports in json format to specified directory

     reports export  <list of reports> -d <directory-to-store-reports>
  

• List reports in VA

     reports list   -- list the names of all the reports
  

Notes on imported tables

• sasb7dat,sashdat,csv -- sashdat file
• astore -- sashdata file (schema: index , state)
• sas, ds2 -- sashdat - "model" table that can be executed with datastep.runCodeTable and ds2.runModel actions.(schema: modelName, dataStepsrc|ds2Src)

Examples

```script
reports import ./reportfiles a.json b.json -f Public <-- import a.json and b.json from 

reportfiles directory into Public folder

reports import ./reportfiles * -f Public <-- import all files from reportfiles directory into Public folder

reports import ./reportfiles 'a report with spaces'  -f Public <-- If file name has spaces enclose the name in quotes

reports export a b -d ./reportfiles <-- export reports a and b as json files into the reportsfiles directory

reports list <-- list all the reports available to the user

tables import  ./data  iris.csv retails.sas7bdat -c Public <-- import the two files from data directory into Public caslib

tables import  ./data  *  -c Public <-- import all the files in data directory into Public caslib

tables list public <-- list names of tables in the public caslib

```

Sample cmdfile

Here is a sample command file

```txt
reports import c:/public/dev/reports * -f Public
tables import ../../data Cluster_SDOH6.sas -c public
```