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 PACKAGE
- ODS PDF
- ODS PHTML
- ODS RTF
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) | ![]() |
![]() |
![]() |
![]() |
ZIP | ![]() |
![]() |
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) | ![]() |
![]() |
ZIP |
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) | ![]() |
![]() |
ZIP | ![]() |
![]() |
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
- FTP
- HTTP
- Pipe
- Socket
- Sysout
- Temp
- URL
- VSAM (IBM z/OS Mainframe only)
- ZIP
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 | Look up the syntax of all supported language elements and options from all the WPS modules |
Have a question?
Try or buy
Standard Edition
Academic Edition
Community Edition