WPS Core

SAS Language Modules

WPS Core

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 EXCELXP
  • ODS HTML
  • ODS HTMLCSS
  • ODS LISTING
  • ODS MARKUP
  • ODS MSOFFICE2K
  • ODS OUTPUT
  • ODS PDF
  • ODS PHTML

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) YesNoYesNo
SAS7BDAT (SAS version 7/8/9 dataset) YesYesYesYes
SASSEQ (SAS version 8/9 sequential/tape file) YesYesYesNo
V8SEQ (SAS version 8 sequential/tape file) YesYesYesNo
V9SEQ (SAS version 9 sequential/tape file) YesYesYesNo
WPD (WPS dataset) YesYesYesYes
WPDSEQ (WPS sequential file) YesYesNoNo
JSON YesYesNoNo
XML YesYesNoNo
Tableau NoYesNoNo
XPORT (transport format) YesYesNoNo
CPORT/CIMPORT (transport format) YesYesYesYes

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 (16.4 MB) Look up the syntax of all supported language elements and options from all the WPS modules (SYNTAX DIAGRAM version)
WPS-Reference-for-Language-Elements.pdf (25.2 MB) Look up the syntax of all supported language elements and options from all the WPS modules (TEXTUAL SYNTAX version)

Other SAS language modules