The Core Module of WPS
WPS Core module provides all of the basic facilities required to run programs written in the SAS language. Support for the syntax and semantics of the SAS language includes DATA Steps, procedures, functions, call routines, formats, informats, macros, logs, input data, output data and readable output, and the ability to interface with many industry standard data sources.
Language Support in Detail
A complete list of all language elements supported can be found in the language support section of this website.
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
- Math
- 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", id: "DataFileFormats
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) | ![]() | ![]() | ![]() | ![]() |
Additional access to Microsoft ACCESS, Microsoft EXCEL, SPSS and dBASE files is supported by utilizing the WPS Engine for DB Files module.
Connectivity to databases, data warehouses and Hadoop big data sources is achieved by utilizing the appropriate WPS Data Engine Modules.
File Types", id: "FileTypes
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)
Dependencies and Usage
WPS Core can be used on any supported platforms.

