SASPy

Date: Jan 14, 2022 Version: 4.0.0

Source Repository: http://github.com/sassoftware/saspy

Issues and Ideas: https://github.com/sassoftware/saspy/issues

Example Repo: https://github.com/sassoftware/saspy-examples

What is this?

This module provides Python APIs to the SAS system. You can start a SAS session and run analytics from Python through a combination of object-oriented methods or explicit SAS code submission. You can move data between SAS data sets and Pandas dataframes and exchange values between python variables and SAS macro variables.

The APIs provide interfaces for the following:

• Start a SAS session on the same host as Python or a remote host.
• Exchange data between SAS data sets and Pandas data frames.
• Use familiar methods such as describe() and head() to work with data.

Additional functionality such as machine learning, econometrics, and quality control are organized in Python classes.

See Getting started for programming examples.

Dependencies

• Python3.4 or higher.
• SAS 9.4 or higher. SAS Viya 3.1 or higher is also supported.
• To use the integrated object method (IOM) access method (one of four connection methods) requires Java 7 or higher on the client.

You can connect to SAS on any platform that is supported for the specified SAS releases.

• Installation
• Configuration
  • sascfg_personal.py
  • sascfg_personal.py details
  • Choosing an Access Method
  • STDIO
  • STDIO over SSH
  • IOM using Java
    • ATTN, log4j vulnerabilities found in Dec 2021
    • ATTN, as of saspy version 3.3.3, the classpath is no longer required in your configuration file!
    • The .authinfo file (_authinfo on Windows)
    • Remote
    • Local
    • IOM to MVS SAS
  • HTTP
  • IOM using COM
• Getting started
  • Initial import
  • Start a SAS session
  • Load data into SAS
    • CSV
    • Pandas DataFrame
    • Existing SAS data set
  • Explore the data
    • List the variables
    • See the first observations
    • Summary of numeric columns
    • Basic bar chart
    • Basic histogram
    • Basic heatmap
  • Submit SAS code directly from Python session
  • Split the data into training and test
  • Build an analytical model
    • More about the target and input parameters
  • Evaluating model diagnostics
• API Reference
  • SAS Session Object
  • SAS Data Object
  • Procedure Syntax Statements
  • SAS Results
  • SAS Procedures
    • Utility
    • Machine Learning (SAS Enterprise Miner)
    • Statistics
    • Econometic and Time Series
    • Quality Control
    • SAS Viya VDMML
  • SASPy Scripts
    • run_sas.py
• Advanced topics
  • Using Batch mode
  • Prompting
  • Moving values between Python Variables and SAS Macro Variables
  • Slow performance loading SAS data into a Pandas DataFrame ( to_df(), sd2df() )
  • Slow performance loading a DataFrame into a SAS data set; df2sd()
  • Using Proc iomoperate to find Object Spawner hosts and Workspace Server ports
  • Disconnecting from an IOM session and reconnecting back to it.
  • Configuring Grid Option Sets to have saspy run on a specific Queue.
  • Dates, Times and Datetimes, Oh my!
  • Advanced sd2df and df2sd techniques
  • Automatic checking for ERROR: in the LOG and the warnings module
  • saspy.logger from logging.logger as of V3.7.5
  • SASsession object as a context manager as of V3.7.5
  • Jupyter magics
• Contributing new methods
  • Overview
    • Process
• Limitations, restrictions and work arounds
  • SASLOG
    • Proc Printto
  • Terminating SAS out from under saspy
    • %abort macro and abort statement
    • Canceling submitted statements
  • Perfect Storm
    • Combining proc printto and abort cancel
    • printto= option on submit methods
• Troubleshooting
  • Connection and configuration issues
    • Common diagnostics
    • STDIO
    • STDIO over SSH
    • IOM
      • Java problems
      • Classpath problems
      • IOM specific errors
  • Problems running code
    • My model didn’t run
• License
  • Apache 2.0

Index

• Index