WPS Core

SAS Language Modules

Core language support

The WPS Core language module provides the main language syntax support for programming in the SAS language including DATA Steps, procedures, functions, call routines, formats, informats and macros together with logs, input data, output data and reporting of results.

Macros

WPS Core provides support for both old-style and new-style macros.

Functions and CALL routines

Many DATA step functions and CALL routines are supported by WPS Core including:

  • Date and Time
  • Maths
  • String
  • Financial
  • Statistics
  • Multi-byte (“K-functions”)
  • File System

Formats and Informats

Many Formats and Informats are supported by WPS Core including:

  • Date and Time
  • Numeric
  • String
  • User-Defined
  • INFILE Exits

Procedures

Many Procedures are supported by WPS Core.

Logs

Full support for program logs with error messages and warnings. The WPS Workbench provides the option to view, navigate, save and print logs. Locating errors in program logs is made easy with the outline view and log highlighting.

Output

WPS Core supports the following Output Delivery System (ODS) destinations:

  • ODS CHTML
  • ODS CSV
  • ODS CSVALL
  • ODS EXCEL
  • ODS EXCELXP
  • ODS HTML
  • ODS HTMLCSS
  • ODS LISTING
  • ODS MARKUP
  • ODS MSOFFICE2K
  • ODS OUTPUT
  • ODS PDF
  • ODS PHTML
  • ODS RFT

Data file formats

The table below provides a summary of data formats presently supported by the WPS Core module.

Data File Format Uncompressed
Data
Compressed
Data
Read Write Read Write
SD2 (SAS version 6 dataset)
SAS7BDAT (SAS version 7/8/9 dataset)
SASSEQ (SAS version 8/9 sequential/tape file)
V8SEQ (SAS version 8 sequential/tape file)
V9SEQ (SAS version 9 sequential/tape file)
WPD (WPS dataset)
WPDSEQ (WPS sequential file)
JSON
XML
Tableau
XPORT (transport format)
CPORT/CIMPORT (transport format)
Data File Format Uncompressed
Data
Read Write
SD2 (SAS version 6 dataset)
SAS7BDAT (SAS version 7/8/9 dataset)
SASSEQ (SAS version 8/9 sequential/tape file)
V8SEQ (SAS version 8 sequential/tape file)
V9SEQ (SAS version 9 sequential/tape file)
WPD (WPS dataset)
WPDSEQ (WPS sequential file)
JSON
XML
Tableau
XPORT (transport format)
CPORT/CIMPORT (transport format)
Data File Format Compressed
Data
Read Write
SD2 (SAS version 6 dataset)
SAS7BDAT (SAS version 7/8/9 dataset)
SASSEQ (SAS version 8/9 sequential/tape file)
V8SEQ (SAS version 8 sequential/tape file)
V9SEQ (SAS version 9 sequential/tape file)
WPD (WPS dataset)
WPDSEQ (WPS sequential file)
JSON
XML
Tableau
XPORT (transport format)
CPORT/CIMPORT (transport format)

Additional access to Microsoft ACCESS, Microsoft EXCEL, SPSS and dBASE files is supported by utilising the WPS Engine for DB Files module.

Connectivity to databases, data warehouses and Hadoop big data sources is achieved by utilising the appropriate WPS Data Engine Modules.

File Types

WPS Core also provides support for the following file access methods:

  • Catalog
  • Clipboard (Windows only)
  • Comma, tab and other delimited data files
  • DDE (Windows only)
  • DDEX
  • Dummy
  • Email
  • FTP
  • HTTP
  • Pipe
  • Socket
  • Sysout
  • Temp
  • URL
  • VSAM (IBM z/OS Mainframe only)

Dependencies and usage

WPS Core can be used on any supported platforms.

Language support in detail

The documents listed below provide details about the supported language syntax.

Language Syntax Description
WPS-Reference-for-Language-Elements-Syntax-Diagram.pdf (48.3 MB) Look up the syntax of all supported language elements and options from all the WPS modules (SYNTAX DIAGRAM version)

 

Other SAS language modules

WPS Core

Support for core language, macros, output and standard data file formats (datasets, sequential files, transport files)

WPS Graphing

Graphing and charting language support

WPS Statistics

Statistical analysis language support

WPS Time Series

Time Series analysis language support

WPS Matrix Programming

Language syntax for advanced matrix manipulation

WPS Machine Learning

Language support for machine learning algorithms

WPS Interop For R

Language of R support

WPS Interop For Python

Language of Python support

WPS Interop For Hadoop

Language support to interact with Hadoop big data environments

WPS Communicate

Programatically execute parts of a script on remote server installations of WPS and upload/download data to/from the remote servers

WPS Language SDK

Develop your own custom SAS language items

Have a question?

Get in touch with our sales team

Try or buy

Standard Edition
Academic Edition
Community Edition